فلزیجات
مرتب سازی:
select id , (select active from admins where id = admins_id)as active from product where ( category in (74) and admins_id not in (4,5,7) and is_verified=1 and show_in!=1 and display=1 and num_mojud>0 and mojud=1 )
GROUP BY
CASE
WHEN prod_list_id = 0 THEN CONCAT(prod_list_id, id)
ELSE prod_list_id
END having active=1 order by name asc