SELECT P.*,U.URL FROM boat_details AS P LEFT JOIN tbl_url U ON (U.ParentID = P.BoatID AND U.LanguageID = 2 AND U.TypeID = 5) WHERE P.Deleted = 0 AND P.Active = 1 AND P.hide_on_homepage = 0 AND P.is_superyacht = 1 ORDER BY P.Length_mt DESC LIMIT 24 Super Yachts For Sale | Mega Yachts for Sale | YACHT International
Triez par: