SELECT node_revisions.title AS title, node_revisions.body AS body, field_cuadrohome_enlace_value AS enlace, field_cuadrohome_tit_enl_value as titenlace,field_foto_telefono_home_value as fototelefono, field_cuadrohomme_orden_value as orderhomme, field_foto_titulo_value as fototitulo FROM node LEFT JOIN node_revisions ON node.vid = node_revisions.vid LEFT JOIN `content_type_cuadro_home` ON `content_type_cuadro_home`.nid = `node`.nid WHERE TYPE = 'cuadro_home' AND language = 'it' order by orderhomme LIMIT 3