Skip to content

Instantly share code, notes, and snippets.

@zverok
Last active August 29, 2015 13:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zverok/9932210 to your computer and use it in GitHub Desktop.
Save zverok/9932210 to your computer and use it in GitHub Desktop.
SELECT * FROM `clients` WHERE (`id` = '395') LIMIT 1
DESCRIBE `mentions_client_395`
SELECT * FROM `mentions_client_395` WHERE (`id` = '431824') LIMIT 1
SELECT * FROM `platforms` WHERE `id` = 63225
SELECT * FROM `users` WHERE `id` = 32213390
SELECT * FROM `social_profiles` WHERE ((`subject_kind` = 'author') AND (`social_profiles`.`subject_id` = 32213390))
SELECT * FROM `social_metrics` WHERE ((`subject_kind` = 'author') AND (`social_metrics`.`subject_id` = 32213390))
SELECT * FROM `journals` WHERE `id` = 32050404
SELECT * FROM `social_profiles` WHERE ((`subject_kind` = 'journal') AND (`social_profiles`.`subject_id` = 32050404))
SELECT * FROM `social_metrics` WHERE ((`subject_kind` = 'journal') AND (`social_metrics`.`subject_id` = 32050404))
SELECT * FROM `mention_details` WHERE ((`client_id` = 395) AND (`mention_details`.`mention_id` = 431824))
SELECT * FROM `labels` WHERE `id` = 1387
SELECT * FROM `seeds` WHERE `id` = 2192
SELECT `labels`.* FROM `labels` INNER JOIN `seeds2labels` ON ((`seeds2labels`.`label_id` = `labels`.`id`) AND (`seeds2labels`.`seed_id` = 2192))
SELECT * FROM `fetches` WHERE `id` = 124251868
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment