Resource id #46SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp
FROM nctl_ads a
INNER JOIN nctl_featured feat ON a.adid = feat.adid AND feat.featuredtill >= NOW()
INNER JOIN nctl_cities ct ON a.cityid = ct.cityid
WHERE a.subcatid = 21
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND ct.countryid = 21
ORDER BY feat.timestamp DESCSELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp
FROM nctl_ads a
INNER JOIN nctl_cities ct ON a.cityid = ct.cityid
WHERE a.subcatid = 21
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND ct.countryid = 21
ORDER BY a.createdon DESC
LIMIT 25, 25
61 usuarios online
Salud y Belleza
