|
|
Resource id #45SELECT 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 = '85'
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND a.cityid = 1803
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 = '85'
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND a.cityid = 1803
ORDER BY a.createdon DESC
LIMIT 0, 25
Trabajo y empleo
|
Lo sentimos! No hay anuncios que mostrar Si quieres ser el primero en poner aqui tu anuncio haz click
« Volver al inicio
|
|
|
|
61 usuarios online
