Категории Тип действия Тип скидки
Новости Подписки Для браузеров Контакты

Всего
скидок: 2894
компаний: 283
 
SELECT DISTINCT IFNULL(`advcampaigns`.`logo`, `coupons`.`logo`) AS `logo`, `advcampaigns`.`name` AS `adv_name`, `coupons`.`name` AS `name`, IFNULL(`advcampaigns`.`rating`, `coupons`.`rating`) AS `rating`, coupons.gotolink, coupons.date_end, coupons.id, coupons.cpa_id FROM u0744530_default.coupons coupons LEFT JOIN u0744530_default.advcampaigns advcampaigns ON (coupons.advcampaign_id = advcampaigns.id AND coupons.cpa_id = advcampaigns.cpa_id) RIGHT JOIN u0744530_default.categories categories ON (coupons.categories LIKE CONCAT('%,', categories.id, ',%')) WHERE ((coupons.date_start < NOW() AND coupons.date_end > NOW()) OR coupons.active = 'true') AND categories.name = 'Valentine\'s Days' ORDER BY coupons.rating DESC LIMIT 14