SELECT SQL_CALC_FOUND_ROWS p.product_id,p.adtype_id,p.product_type_id,p.price,p.price_type_id,p.photo, p.photo_ver, p.currency_id
FROM products p
LEFT JOIN product_details pd ON pd.product_id = p.product_id
WHERE p.status_id="1" AND p.photo IS NOT NULL AND p.city_id = "1" AND p.district_id = "10" AND p.sector_id = "47"
AND p.product_type_id="1"
AND p.adtype_id="7" AND p.product_id != "7505821"
AND pd.estate_type_id = "1" ORDER BY RAND() LIMIT 5
