Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `t`.`id` AS `t0_c0`, `t`.`alias` AS `t0_c1`, `t`.`name` AS `t0_c2` FROM `company` `t` ORDER BY name DESC LIMIT 15
- SELECT `t`.`id` AS `t0_c0` FROM `company` `t` INNER JOIN `company_specialization` `specializations_specializations` ON (`t`.`id`=`specializations_specializations`.`company_id`) INNER JOIN `specialization` `specializations` ON (`specializations`.`id`=`specializations_specializations`.`spec_id`) WHERE (`t`.`id` IN (5, 3, 4, 1, 2, 6)) AND (specializations.alias IN ("spec1","spec2","spec3"))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement