Categorii
    − ATV Linhai (5537)
    − ATV Polaris (1096)
    − ATV Yamaha (1384)
    − ATV Honda (430)
    − ATV Suzuki (1062)
    − ATV Kawasaki (615)
    − ATV Bombardier (2615)
    − ATV Cectek (343)
    − ATV Arctic Cat (1632)
    − ATV New Force (111)
    − ATV CF Moto (2186)
    − ATV Dinli (155)
    − Alte Modele ATV (24219)

Schimburi

(387)

SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, COUNT(*) AS piccount, p.picfile, ct.cityname, scat.subcatname, cat.catid, cat.catname , axf.f1, axf.f2, axf.f3, axf.f4, axf.f5, axf.f6, axf.f7, axf.f8, axf.f9, axf.f10 FROM clf_ads a INNER JOIN clf_cities ct ON a.cityid = ct.cityid INNER JOIN clf_subcats scat ON a.subcatid = scat.subcatid INNER JOIN clf_cats cat ON scat.catid = cat.catid LEFT OUTER JOIN clf_adxfields axf ON a.adid = axf.adid LEFT OUTER JOIN clf_adpics p ON a.adid = p.adid AND p.isevent = '0' LEFT OUTER JOIN clf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' WHERE a.subcatid = 47 AND a.fabyear >= 0 AND a.fabyear <= 10000 AND scat.subcatid = "47" AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND (feat.adid IS NULL OR feat.featuredtill < NOW()) GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 160, 20Out of resources when opening file '/var/tmp/#sql_390a_0.MAD' (Errcode: 24)