Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.60 KB | None | 0 0
  1. 8   SELECT COUNT(DISTINCT Question.id) FROM `wtdw_tagged` AS `Tagged` LEFT JOIN `wtdw_tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) LEFT JOIN `wtdw_questions` AS `Question` ON (`Tagged`.`foreign_key` = `Question`.`id` AND `Tagged`.`model` = 'Question') WHERE `Tag`.`keyname` = 'narocniskega'      1   1   20
  2.  
  3. 9   SELECT DISTINCT `Question`.* FROM `wtdw_tagged` AS `Tagged` LEFT JOIN `wtdw_tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) LEFT JOIN `wtdw_questions` AS `Question` ON (`Tagged`.`foreign_key` = `Question`.`id` AND `Tagged`.`model` = 'Question') WHERE `Tag`.`keyname` = 'narocniskega' LIMIT 20       4   4   1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement