

<br />
<b>Fatal error</b>:  Uncaught ErrorException: 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 33&lt;br /&gt;Error No: 1064&lt;br /&gt;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 company_user_id, p.property_id,p.project_id,p.set_exclusive, p.disc_price, pj.pay_milestones, pj.pay_percentages,p.floor_plan , 
		com.company_name as company_name,
		com.company_logo,
		com.address as comapny_address,
		com.company_email as company_email,
		com.office_phone as office_phone,
		u.email as agent_email,
		u.image,
		u.firstname,u.mk_flag,
		u.lastname,
		u.telephone,
		u.mobile as agent_mobile,
		u.user_id as agent_user_id,
		u.user_type,
		u.company_id,
		u.agent_license_number,pd.images,
		xc.bookingstatus , pj.header_image as projheader_image ,con.name as con_name,z.name as zonename
		FROM property_new p
		LEFT JOIN property_unit_type pu on(pu.unit_type_id = p.unit_type)
		LEFT JOIN country con on(con.country_id = p.country_id)
		LEFT JOIN zone z on(z.zone_id = p.zone_id)
		LEFT JOIN property_description_new pd on(pd.property_id = p.property_id)
		LEFT JOIN user u on(u.user_id = p.user_id)
		LEFT JOIN company com on(com.company_id = u.company_id)
		LEFT JOIN project_description pj on p.project_id = pj.project_id
		LEFT JOIN ex_contacts xc on p.property_id = xc.property_id
		where p.status = 1 AND u.status = 1 AND p.permitstatus in (1,5) AND p.property_id =  GROUP BY p.property_id in /home/realopedia/public_html/system/database/mysqli.php:46
Stack trace:
#0 /home/realopedia/public_html/system/library/db.php(20): DBMySQLi-&gt;query('SELECT \r\r\n\t\tp.w...')
#1 /home/realopedia/public_html/catalog/model/property/propertynew.php(2673): DB-&gt;query('SELECT \r\r\n\t\tp.w...')
#2 /home/realopedia/public_html/catalog/controller/property/propertydetail.php(67): ModelPropertyPropertynew-&gt;getPropertyDetailnew('')
#3 /home/realopedia/public_html/system/engine/front.php(42): ControllerPropertyPropertydetail-&gt;index()
#4 /home/realopedia/public_html/system/engine/front.php(29): Front-&gt;execute(Object(Action))
#5 /home/realopedia/public_html/index.php(359): Front-&gt;dispatch(Object(Action), Object(Action))
#6 {main}
  thrown in <b>/home/realopedia/public_html/system/database/mysqli.php</b> on line <b>46</b><br />