SELECT objnameFr, COUNT(viewid) AS totallist , viewobjdefid FROM nuke_obj_index, nuke_obj_view LEFT JOIN nuke_meta_objdef ON (objdefid = viewobjdefid) WHERE viewid = nuke_obj_index.indexobjkey01 AND nuke_obj_index.indexobjdefid=17 AND indexinfoobjdefid=16 AND (nuke_obj_index.indexinfoobjkey01 = '100' ) GROUP BY viewobjdefid ORDER BY nuke_meta_objdef.objnameFr ASC