linccce

Need optimisation

Feb 19th, 2015
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.87 KB | None | 0 0
  1. SELECT
  2. *
  3. FROM `tvs_languages`
  4. LEFT OUTER JOIN `tvs_languages_vals` ON `tvs_languages`.`id` = `tvs_languages_vals`.`lang`
  5. LEFT OUTER JOIN `tvs_elements` ON `tvs_languages`.`id` = `tvs_elements`.`lang`
  6. LEFT OUTER JOIN `tvs_boxes` ON `tvs_elements`.`id` = `tvs_boxes`.`element`
  7. LEFT OUTER JOIN `tvs_boxes_vals` ON `tvs_elements`.`id` = `tvs_boxes_vals`.`element`
  8. LEFT OUTER JOIN `tvs_slides` ON `tvs_languages`.`id` = `tvs_slides`.`lang`
  9. LEFT OUTER JOIN `tvs_slides_vals` ON `tvs_slides`.`id` = `tvs_slides_vals`.`slide`
  10. LEFT OUTER JOIN `tvs_padaliniai` ON `tvs_languages`.`id` = `tvs_padaliniai`.`lang`
  11. LEFT OUTER JOIN `tvs_voting` ON `tvs_languages`.`id` = `tvs_voting`.`lang`
  12. LEFT OUTER JOIN `tvs_voting_vals` ON `tvs_elements`.`id` = `tvs_boxes_vals`.`element`
  13. LEFT OUTER JOIN `tvs_klausimai` ON `tvs_padaliniai`.`id` = `tvs_klausimai`.`tipas`
  14. WHERE `tvs_languages`.`id` = 1
Advertisement
Add Comment
Please, Sign In to add comment