SELECT
xc_ads.*, xc_ads_params.value_num AS ad_price, xc_currencies.name_currency, xc_favourites.id AS fav_id
FROM xc_ads
JOIN (
SELECT lat_lng_distance(xc_ads.lat, xc_ads.lng,39.043701171875,-77.474197387695) AS dist, xc_ads.id
FROM xc_ads
LEFT JOIN xc_ads_categories
ON xc_ads_categories.ad_id = xc_ads.id
LEFT JOIN xc_ads_params as param5
ON param5.param_id=5 AND param5.ad_id=xc_ads.id
LEFT JOIN xc_ads_params as param200
ON param200.param_id=200 AND param200.ad_id=xc_ads.id
LEFT JOIN xc_ads_params AS param199
ON param199.param_id = 199
AND param199.ad_id = xc_ads.id
WHERE ((NOT ISNULL(param200.value_num) AND param200.value_num>UNIX_TIMESTAMP() AND param199.value_num<>5687) OR (param199.value_num=5687))
AND xc_ads.status='approved' AND is_deal=1 AND xc_ads.category_id IN (1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1756,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1813,1814,1827,1837,1844,1846,1848,6) AND xc_ads.lat>38.465284642809 AND xc_ads.lat<39.622117700941 AND xc_ads.lng>-77.923433685988 AND xc_ads.lng<-77.024961089402
HAVING dist< 50
ORDER BY dist, xc_ads.bump_up_date
LIMIT 0,15
) as b
ON b.id = xc_ads.id
LEFT JOIN xc_currencies
ON xc_currencies.ID = xc_ads.currency_id
LEFT JOIN xc_ads_params
ON xc_ads_params.param_id=5 AND xc_ads_params.ad_id=xc_ads.id
LEFT JOIN xc_ads_categories
ON xc_ads_categories.ad_id = xc_ads.id
LEFT JOIN xc_ads_params AS deal_price
ON deal_price.param_id = 171
AND deal_price.ad_id = xc_ads.id
LEFT JOIN xc_favourites
ON xc_favourites.ad_id=xc_ads.id AND xc_favourites.user_id=0 GROUP BY xc_ads.id ORDER BY 1, dist, 1
