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 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)
ORDER BY 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
