SELECT o.id_0, tipus_0, titol_0, localitat_0, desc_0, o.body_0, fecha_0, img_0, img_1, f_niv_int, f_promotor, f_any_const, f_superficie, f_presup, f_tecnics, f_pubs, f_any_con, f_emp_cons, f_premis,ot.ordre, ot.name_0 as ciutat FROM obres AS o INNER JOIN obres_ciutats as ot ON ot.id_0=localitat_0 WHERE actiu=1 AND o.lng_0=1 AND ot.lng_0=1 ORDER BY ot.ordre ASC, fecha_0 DESC 
