Advertisement
fahmi_auliya

MySQL - Yii TIMESTAMPDIFF

Oct 9th, 2013
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.19 KB | None | 0 0
  1. SELECT
  2.     `t`.`email` AS `t0_c7`, `t`.`block` AS `t0_c8`, `t`.`register_date` AS `t0_c9`, `t`.`id` AS `t0_c0`,
  3.     `co`.`confirm_date` AS `t1_c6`, `co`.`id` AS `t1_c0`, `g`.`name` AS `t2_c3`, `g`.`id` AS `t2_c0`,
  4.     `b`.`complete_name` AS `t3_c2`, `b`.`birth_place` AS `t3_c11`, `b`.`birth_date` AS `t3_c12`, `b`.`status` AS `t3_c24`,
  5.     TIMESTAMPDIFF(YEAR,b.birth_date,CURDATE()) AS age, `b`.`id` AS `t3_c0`, `op`.`name` AS `t5_c1`, `op`.`id` AS `t5_c0`, `oc`.`name` AS `t6_c2`,
  6.     `oc`.`id` AS `t6_c0`, `p`.`name` AS `t7_c1`, `p`.`id` AS `t7_c0`, `c`.`name` AS `t8_c2`, `c`.`id` AS `t8_c0`,
  7.     `e`.`thesis_title` AS `t4_c8`, `e`.`role_year` AS `t4_c16`, `e`.`finish_year` AS `t4_c19`, `e`.`ipk` AS `t4_c9`,
  8.     `e`.`id` AS `t4_c0`, `u`.`name` AS `t9_c1`, `u`.`id` AS `t9_c0`, `m`.`name` AS `t10_c3`, `m`.`id` AS `t10_c0`,
  9.     `x`.`position` AS `t11_c8`, `x`.`id` AS `t11_c0`, `i`.`name` AS `t12_c2`, `i`.`id` AS `t12_c0`, `f`.`name` AS `t13_c3`,
  10.     `f`.`id` AS `t13_c0`, `cp`.`job_position` AS `t14_c3`, `cp`.`id` AS `t14_c0`
  11. FROM `swt_users` `t`
  12. LEFT OUTER JOIN `ccn_finance_confirm` `co` ON (`co`.`swt_users_id`=`t`.`id`)
  13. LEFT OUTER JOIN `swt_users_group` `g` ON (`t`.`users_group_id`=`g`.`id`)
  14. LEFT OUTER JOIN `ccn_jobseeker_bio` `b` ON (`b`.`swt_users_id`=`t`.`id`)
  15. LEFT OUTER JOIN `zone_province` `op` ON (`b`.`origin_province_id`=`op`.`id`)
  16. LEFT OUTER JOIN `zone_city` `oc` ON (`b`.`origin_city_id`=`oc`.`id`)
  17. LEFT OUTER JOIN `zone_province` `p` ON (`b`.`province_id`=`p`.`id`)
  18. LEFT OUTER JOIN `zone_city` `c` ON (`b`.`city_id`=`c`.`id`)
  19. LEFT OUTER JOIN `ccn_jobseeker_edu` `e` ON (`e`.`swt_users_id`=`t`.`id`) AND (last_edu = 1)
  20. LEFT OUTER JOIN `ccn_edu_university` `u` ON (`e`.`univ_name_id`=`u`.`id`)
  21. LEFT OUTER JOIN `ccn_edu_major` `m` ON (`e`.`ccn_major_id`=`m`.`id`)
  22. LEFT OUTER JOIN `ccn_jobseeker_exp` `x` ON (`x`.`swt_users_id`=`t`.`id`) AND (last_exp = 1)
  23. LEFT OUTER JOIN `ccn_careerpedia_industry` `i` ON (`x`.`emp_industry_id`=`i`.`id`)
  24. LEFT OUTER JOIN `ccn_employer_vacancy_function` `f` ON (`x`.`vacancy_function_id`=`f`.`id`)
  25. LEFT OUTER JOIN `ccn_careerpedia_position` `cp` ON (`x`.`careerpedia_position_id`=`cp`.`id`)
  26. WHERE ((t.users_group_id IN (4, 5, 6, 7, 8)) AND (e.univ_name_id=2411)) ORDER BY t.register_date DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement