SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp
FROM nctl_ads a
INNER JOIN nctl_cities ct ON a.cityid = ct.cityid
WHERE a.subcatid = 28
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.lang = 'es'
AND ct.countryid = 17
ORDER BY a.createdon DESC
LIMIT 0, 25
Motos
|
| | Miercoles, 30 Junio, 2010 | |
|
|
|
65 usuarios online
