Форум пользователей MySQL

SELECT v.city_id, v2c.category_id, c.parent_id AS parent_category_id, v.id, count(*) as count
FROM product v
JOIN product_to_category v2c ON v.id = v2c.product_id
JOIN category c ON v2c.category_id = c.id
WHERE v.publish =1 AND  v.id
IN ( SELECT product_id FROM product_to_category WHERE category_id IN ( SELECT id FROM category WHERE parent_id = c.parent_id) )
GROUP BY v.city_id, c.parent_id

SELECT v.city_id, v2c.category_id, c.parent_id AS parent_category_id, v.id
FROM product v
JOIN product_to_category v2c ON v.id = v2c.product_id
JOIN category c ON v2c.category_id = c.id
JOIN city city ON v.city_id = city.id
WHERE v.publish =1 AND v.city_id =501 AND c.parent_id =10 AND v.id
IN ( SELECT product_id FROM product_to_category WHERE category_id IN ( SELECT id FROM category WHERE parent_id = c.parent_id) )

SELECT v.city_id, v2c.category_id, c.parent_id AS parent_category_id, count(*) as count
FROM product v
JOIN product_to_category v2c ON v.id = v2c.product_id
JOIN category c ON v2c.category_id = c.id
JOIN city city ON v.city_id = city.id
WHERE v.publish =1 AND v.city_id =501 AND c.parent_id =10 AND v.id
IN ( SELECT product_id FROM product_to_category WHERE category_id IN ( SELECT id FROM category WHERE parent_id = c.parent_id) )
GROUP BY v.city_id, c.parent_id

SELECT `product`.`id`, `product`.`name`, `product`.`condition`, `product`.`city_id`,  `product`.`price`,`user`.`name`  AS `user_name`, `city`.`name` AS `city_name`
FROM `product_to_category` `p2c`
JOIN `product` `product` ON product.id = p2c.product_id

JOIN product_to_city ptc ON product.id = ptc.product_id 
JOIN city c ON c.id = ptc.city_id

LEFT JOIN `city` `city` ON city.id=product.city_id
LEFT JOIN `user` ON user.id=product.user_id
WHERE (
((`product`.`id` in (
                    select product_id from product_to_city
                    join city on (city.id = product_to_city.city_id)
                    where city.id = 1 or city.parent_id = 1
                ))) AND

( (`product`.`zombie` = 0)) AND (`product`.`publish` = 1 AND `product`.`archive` = 0 AND (`product`.`delete` = 0 OR `product`.`delete` is null)))
GROUP BY `product`.`id`
HAVING COUNT(1) > 1
ORDER BY `product`.`timestamp_update` DESC