SELECT * FROM products AS p WHERE p.active=1 AND p.group_id IN (44,47,48,56,80,83) ORDER BY p.onka_no ASC