Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
/home/boatbook/public_html/yacht_search/plugin_enquiry_form.php on line
204
SELECT
properties.availability,
properties.pprice,
properties.pprice2,
properties.parcare,
properties.animale,
properties.internet,
properties.tv,
properties.telefon,
properties.piscina,
properties.handicap,
properties.customamenities1,
properties.customamenities2,
properties.customamenities3,
properties.customamenities4,
properties.customamenities5,
properties.customamenities6,
properties.customamenities7,
properties.customamenities8,
properties.customamenities9,
properties.customamenities10,
properties.video_url,
properties.pid,
properties.pname,
properties.picture,
properties.dormitoare AS berths,
properties.sleeps,
properties.regiunea AS regiunea,
properties.town,
properties.bb_comments,
properties.typeofproperties,
properties.racing,
MIN(CASE WHEN ajt_calendar_price.end_date >= NOW() THEN ajt_calendar_price.daily END) AS dailymin,
MAX(CASE WHEN ajt_calendar_price.end_date >= NOW() THEN ajt_calendar_price.daily END) AS dailymax,
MIN(CASE WHEN ajt_calendar_price.end_date >= NOW() THEN ajt_calendar_price.weekly END) AS weeklymin,
MAX(CASE WHEN ajt_calendar_price.end_date >= NOW() THEN ajt_calendar_price.weekly END) AS weeklymax,
properties.pprice AS pprice111,
properties.pprice2 AS pprice222,
properties.typeofbooking AS daily,
property_extended2.regionwinter AS winter,
property_extended.b13 AS cabins,
property_extended.b1 AS crewed,
GROUP_CONCAT(DISTINCT CONCAT('
',ajt_ports.port,'')) AS portlist2,
GROUP_CONCAT(DISTINCT regions.region_name) AS regionlist,
GROUP_CONCAT(DISTINCT ajt_ports.port) AS portlist,
COUNT(DISTINCT ajt_ports.port) AS num_ports,
properties.picturebig AS picturebig,
property_extended2.regionwinter,
properties.dormitoare,
boat_manufacturers.manufacturer AS b3,
boat_manufacturers.tree_url AS b3_tree,
boat_models.model AS b4,
boat_models.tree_url AS b4_tree,
boat_models.model_id AS mid,
property_extended.b6,
property_extended.b8,
property_extended.b9,
property_extended.b10,
property_extended.b14,
property_extended.b15,
property_extended.b16,
property_extended.b17,
property_extended.b18,
property_extended.b19,
property_extended.b21,
property_extended.b23,
property_extended.b25,
property_extended.b26,
property_extended.b5,
properties.largepic AS largeimage,
properties.description,
properties.picturebig,
properties.pshortdescription,
property_extended2.additional_ports,
properties.keywords,
property_extended2.amenities_fishing,
currency.currency AS booking_currency,
currency.html_ref AS currency_html_ref,
property_extended2.capacity_at_dock,
properties.seasonal_prices,
properties.low_price,
properties.high_price,
GROUP_CONCAT(CASE WHEN ajt_boat_ports.home = 1 THEN ajt_ports.port END) AS home_port,
properties.secondary_images,
properties.cyaurl,
properties.usecya,
properties.homeportinfo,
properties.crew_text,
properties.crew_url,
google_maps.google_code AS google_map
FROM properties
LEFT JOIN google_maps ON properties.google_map = google_maps.map_id
LEFT JOIN property_extended2 ON property_extended2.pid = properties.pid
LEFT JOIN property_extended ON property_extended.id = properties.pid
LEFT JOIN boat_models ON boat_models.model_id = property_extended.b31
LEFT JOIN boat_manufacturers ON boat_manufacturers.manufacturer_id = boat_models.manufacturer_id
LEFT JOIN currency ON properties.currency_id = currency.id
LEFT JOIN ajt_boat_ports ON properties.pid = ajt_boat_ports.boat_id
LEFT JOIN ajt_ports ON ajt_boat_ports.port_id = ajt_ports.port_id
LEFT JOIN regions ON ajt_ports.region_id = regions.region_id
LEFT JOIN ajt_calendar_price ON ajt_calendar_price.pid = properties.pid
WHERE properties.pid =
GROUP BY properties.pid
ORDER BY pname ASC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY properties.pid
ORDER BY pname ASC' at line 103
