Ris

SELECT i.* FROM cars i
LEFT JOIN cars_param_bind AS p ON p.item_id = i.id
WHERE  i.id IN
(SELECT item_id FROM `cars_param_bind` WHERE VALUE = 3) AND i.id IN (SELECT item_id FROM `cars_param_bind` WHERE VALUE = 1)
ORDER BY i.date_pub DESC
LIMIT 0, 15

SELECT i.* FROM cars i
LEFT JOIN cars_param_bind AS p ON p.item_id = i.id
WHERE  i.id IN
(SELECT item_id FROM `cars_param_bind` WHERE VALUE = 3) AND i.id IN (SELECT item_id FROM `cars_param_bind` WHERE VALUE = 1)
GROUP BY i.id ORDER BY i.date_pub DESC
LIMIT 0, 15

UPDATE `cms_controllers` SET `is_backend` = 1 WHERE `cms_controllers`.`name` = 'api';