Advertisement
Guest User

yii active record result

a guest
Jan 10th, 2014
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.50 KB | None | 0 0
  1. 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
  2.  
  3. 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