SELECT DISTINCT (
no.reg_id
)
FROM node n
LEFT JOIN node_ouvrage no ON n.nid = no.nid
LEFT JOIN n_regroupement nr ON nr.reg_id = no.reg_id
LEFT JOIN term_fields_collection nc ON nr.reg_id = nc.regroupement_id
INNER JOIN term_node tn_niv ON tn_niv.nid = n.nid
INNER JOIN term_node tn_mat ON tn_mat.nid = n.nid
WHERE n.status =1
AND n.type = 'ouvrage'
AND tn_niv.tid
IN ( 185, 186, 187, 189, 190, 191, 208, 209, 706 )
AND tn_mat.tid =224
AND no.reg_id !=0
AND nc.afficher =1
AND no.cat_id
IN ( 1, 2, 3, 4 )
ORDER BY nc.ordre
LIMIT 0 , 30