|
|
Find Your Boat by:****JavaScript based drop down DHTML menu generated by NavStudio. (OpenCube Inc. - http://www.opencube.com)****
|
Warning: mysql_query() [function.mysql-query]: Access denied for user 'boatbook'@'localhost' (using password: NO) in /home/boatbook/public_html/stunningyachts/search/search_luxury_yachts.php on line 145 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/boatbook/public_html/stunningyachts/search/search_luxury_yachts.php on line 145 SELECT *, property_extended.b3 AS model, properties.pid AS pid, properties.dormitoare AS berths, MAX(specialdays.price) AS maxdays, MAX(specialweeks.price) AS maxweeks, MIN(specialdays.price) AS mindays, MIN(specialweeks.price) AS minweeks, properties.typeofbooking AS daily FROM properties LEFT JOIN property_extended2 ON property_extended2.pid = properties.pid LEFT JOIN property_extended ON property_extended.id = properties.pid LEFT JOIN specialweeks ON specialweeks.pid = properties.pid LEFT JOIN specialdays ON specialdays.pid = properties.pid WHERE properties.hold = 1 AND properties.sleeps >= 20 AND properties.typeofbooking=1 AND (properties.regiunea LIKE '%French Riviera%' OR properties.town LIKE '%French Riviera%' OR properties.tara LIKE '%French Riviera%' ) AND properties.typeofproperties = 1 GROUP BY properties.pid ORDER BY properties.pprice DESC, properties.pprice2 DESC, pname ASC 1 caused: Access denied for user 'boatbook'@'localhost' (using password: NO) |