Fatal error: Uncaught exception 'ErrorException' with message 'Error: 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 p.property_id' at line 65<br />Error No: 1064<br />SELECT p.web_reference,p.prop_c_status,p.reference_mls,p.property_type,p.category_id,p.rent_period,pu.name as property_type_name,p.address,p.zipcode,p.tentanted,p.furnished,p.attribute_lot_plot_size_sqf,p.attribute_lot_plot_size_sqm, p.attribute_built_up_area_sqf,p.attribute_built_up_area_sqm,p.views,p.info_no_bedrooms,p.info_no_bathrooms,p.longitude, p.latitude,p.name,pd.description,p.country_id,p.zone_id,p.city_id,p.community_id_uae,p.rera_permit,p.currency,p.local_price, p.attribute_price,p.exclusive,p.frequency,p.facilities,p.videos,p.garage_type,p.access,p.flooring,p.community,p.is_featured,p.tentanted_exp_date, p.exterior_features,p.interior_features,p.parking_no,p.finishings,p.user_id,p.company_id,p.view360, com.user_id as c in /home/realopedia/public_html/system/database/mysqli.php on line 40