Vendo casa comercial en Barranquilla, área 280 MTS. con dos locales
apropiados para gimnasio, spa, salón de eventos, tienda, supermercado, panadería, veterinaria, odontologia, etc. Etc..
ES LA OPORTUNIDAD PARA SU NEGACIO !!
Ubicada en la carrera 46 con la 80. barrio Porvenir
Más información en cel. 3166037588
SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname,
COUNT(*) AS piccount, MIN(p.picfile) AS picfile,
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 xzclf_ads a
INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid
INNER JOIN xzclf_subcats scat ON a.subcatid = scat.subcatid
INNER JOIN xzclf_cats cat ON scat.catid = cat.catid
LEFT OUTER JOIN xzclf_adxfields axf ON a.adid = axf.adid
LEFT OUTER JOIN xzclf_adpics p ON a.adid = p.adid AND p.isevent = '0'
LEFT OUTER JOIN xzclf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A'
WHERE a.subcatid = 26
AND a.enabled = '1' AND a.verified = '1' AND a.expired = '0' AND a.paid <> '0'
AND (feat.adid IS NULL OR feat.featuredtill < NOW())
AND ct.countryid = 63
AND a.adid != 97772
GROUP BY a.adid
ORDER BY RAND()
LIMIT 0, 2Expression #35 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'occupons_avisoco.axf.f1' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
3166037588 