|
|
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 = 113
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND ct.countryid = 118
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 = 113
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND ct.countryid = 118
ORDER BY a.createdon DESC
LIMIT 0, 25
Antiguedades y Arte
|
|
|
|
|
60 usuarios online
