select t1.*, t2.*
from (select * from class_ads where class_ads.active=1) as t1
inner join (select * from class_slugs where class_slugs.`type`='listing') as t2 on t1.id = t2.object_id
SELECT t1.customer_id, MIN(t1.count)
FROM (
SELECT customer_id, status, count(*) as count
FROM requests
GROUP BY customer_id, status
HAVING status = "to work"
) AS t1
select
t1.name_goods,
t2.name_subcat,
t3.name_cat
from goods t1
left join subcategory t2 on t2.id_subcat = t1.id_subcat
left join category t3 on t3.id_cat = t1.id_cat