|
National Day for Truth and Reconciliation
Pacific Boat Brokers joins others in closing our office on Monday, September 30th to honour the lost children and Survivors of residential schools, their families and communities. × |
SQL: SELECT TOP (3) fi.ID, fi.feature_page, fi.file_number, fi.display_position, fi.highlight, bn.Vessel_Name, bn.Vessel_Location, bn.Length_Feet, bn.Length_Inches, bn.Listing_Price, bn.Manufacturer_ID, bn.Model, bn.page_name, dm.Manufacturer_Name FROM featured_items AS fi INNER JOIN Boats_new AS bn ON fi.file_number = bn.File_Number INNER JOIN DATA_Manufacturers AS dm ON bn.Manufacturer_ID = dm.Manufacturer_ID WHERE feature_page = 'Pleasure' ORDER BY NEWID()