Query: SELECT * FROM `object_dealers_parts` WHERE `item_public` = 1 AND `item_id` IN (SELECT `item_it_parent` FROM `object_dealers_parts_ex` WHERE `item_tp` = 1 AND `item_val_id` = 1) AND `item_id` IN (SELECT `item_it_parent` FROM `object_dealers_parts_ex` WHERE `item_tp` = 2 AND `item_val_id` = 79)