SELECT * FROM content_type_foto c JOIN files f ON c.field_immagine_fid=f.fid JOIN content_field_ordine z ON z.nid=c.nid JOIN node n ON n.nid=c.nid WHERE c.field_categoria_value='Congress' ORDER BY z.field_ordine_value, n.created DESC, c.field_cliente_value ASC LIMIT 0,18
