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 = 59
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND ct.countryid = 46
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 = 59
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND ct.countryid = 46
ORDER BY a.createdon DESC
LIMIT 0, 25
Reparacion
Viernes, 30 Julio, 2010
SM MASTER GROUP Pintura de Interiores. (Método Airless)
Pintura de Edificios. (Método Airless)
...
61 usuarios online
Reparacion
