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 (646,650,664,665,666,667,668,651,669,670,671,672,673,652,674,675,676,677,678,679,680,683,1835,1852,1873,653,842,843,844,845,846,847,848,849,850,851,852,853,854,855,1828,1832,1833,1834,647,649,1858,1856,1857,1915,1916,1917,1919,1895,1904,1905,1906,1907,1896,922,923,925,1898,1899,1900,1901,1902,1903,1897,1908,1909,1910,1913,1914,1918,655,776,856,857,859,862,1876,1877,657,832,833,834,835,837,658,691,692,693,695,696,697,1836,1853,1854,1855,1859,1864,1874,1878,1879,1880,1894,1911,660,903,904,906,907,908,909,910,911,912,1867,661,877,878,879,880,881,883,884,885,886,887,888,889,890,1812,1829,1830,1831,1843,1845,1849,1882,1890,662,898,899,900,901,902,663,924,926,927,928,929,1826,1838,1842,1815,1816,1817,1818,1819,1820,1821,1839,1822,681,682,1809,1810,1811,1823,1824,1841,648,709,727,738,745,746,748,769,774,775,784,786,795,804,811,814,817,822,710,715,719,736,741,742,747,751,756,757,758,759,760,763,764,765,768,780,788,711,714,716,717,718,720,721,722,726,729,734,735,753,754,770,772,785,791,1920,712,737,739,778,779,790,792,793,794,796,797,798,799,800,801,802,807,808,810,812,813,815,816,819,820,821,823,824,825,826,713,724,731,732,733,743,761,762,767,771,782,789,805,829,838,839,841,1847,1805,654,858,860,861,863,864,865,1850,1891,656,684,686,687,688,689,690,1825,1840,1851,1865,1875,1881,1886,1888,1892,1912,659,699,700,701,702,703,705,706,707,708,1806,831,905,1807,1808,337) 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
