(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '1'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '2'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '3'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '5'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '7'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '12'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '13'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '26'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '27'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '28'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '29'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '30'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '31'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '34'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '35'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '36'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '38'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '39'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '40'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '41'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '42'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '43'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '44'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '46'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '49'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '52'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '53'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '54'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '55'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '56'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '60'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '62'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '64'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '65'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '66'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '67'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '68'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '69'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '70'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '72'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '74'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '75'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '76'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '77'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '78'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '79'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '80'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '81'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '82'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '83'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '89'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '90'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '97'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '107'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '10'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '21'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '32'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '33'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '37'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '51'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '4'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '6'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '8'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '9'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '11'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '14'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '15'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '16'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '17'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '18'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '19'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '20'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '22'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '23'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '24'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '25'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '45'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '47'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '48'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '50'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '57'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '58'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '59'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '61'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '63'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '71'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '73'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '84'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '85'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '86'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '87'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '88'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '91'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '92'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '93'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '94'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '95'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '96'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '98'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '99'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '100'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '101'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '102'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '103'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '104'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '105'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '106'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '108'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '109'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '110'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '111'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '112'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '113'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '114'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '115'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '116'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '117'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '118'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '119'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '120'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '121'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '122'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '123'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '124'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '125'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '126'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '127'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '128'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '129'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '130'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '131'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '132'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '133'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '134'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '135'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '136'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '137'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '138'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '139'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '140'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '141'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '142'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '143'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '144'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '145'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '146'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '147'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '148'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '149'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '150'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '151'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '152'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '153'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '154'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '155'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '156'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '157'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '158'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '159'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)
UNION ALL
(SELECT deals.deal_ID, deals.slug, deals.url, deals.previous_price, deals.title, deals.image, deals.price, deals.END, deals.purchases, deals.date_added,
deals_locations.location_ID, deals.hits
FROM deals
INNER JOIN deals_locations ON deals_locations.deal_ID = deals.deal_ID
AND deals_locations.location_ID = '160'
WHERE deals.STATUS = 'active'
AND deals_locations.deal_ID = deals.deal_ID
GROUP BY deals.deal_ID
LIMIT 5)