<!-- sub query to order the group by functionality -->
select re.id as re_id , p.*, pa.lat as latitude,pa.lang as longitude,pa.address,pa.zip as post_code, pa.city as city_name, pa.state as statename,(select count(id) from fc_review where product_id=p.id) as reviewcount, pp.product_image from fc_product p JOIN fc_rentalsenquiry re on re.prd_id=p.id and re.booking_status='Booked' LEFT JOIN fc_product_address_new pa on pa.productId=p.id LEFT JOIN fc_rental_photos pp on pp.product_id=p.id
where re.id in (select max(id) from fc_rentalsenquiry group by prd_id) group by re.prd_id
Please Whitelist JSFiddle in your content blocker.
Help keep JSFiddle free for always by one of two ways:
Whitelist JSFiddle in your content blocker (two clicks)
Go PRO and get access to additional PRO features →
Join the 4+ million users, and keep the JSFiddle dream alive.
Ad-free
All ads in the editor and listing pages are turned completely off.
Use pre-released features
You get to try and use features (like the Palette Color Generator) months before everyone else.
Fiddle collections
Sort and categorize your Fiddles into multiple collections.
Private collections and fiddles
You can make as many Private Fiddles, and Private Collections as you wish!
Console
Debug your Fiddle with a minimal built-in JavaScript console.