Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.82 KB | None | 0 0
  1. 8   SELECT `Tag`.*, `Tagged`.`tag_id`, COUNT(*) AS occurrence FROM `wtdw_tagged` AS `Tagged` LEFT JOIN `wtdw_tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 GROUP BY `Tagged`.`tag_id` LIMIT 30 8   8   2
  2.  
  3. 9   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` = 'naročniÅ¡kega'  1   1   1
  4.  
  5. 10  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` = 'naročniÅ¡kega' LIMIT 20 4 4   1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement