| 0.0001 |
SELECT * FROM (`tweetosphere_keyword`) WHERE `enabled` = '1'
|
| 0.0052 |
SELECT `tw`.`id`, `screen_name`, `name`, `description`, `avatar`, `author_id`, `content`, `published_at` FROM `authors` AS `au` JOIN ( SELECT * FROM `tweets` AS `tw` WHERE (1) ORDER BY `tw`.`published_at` desc LIMIT 300 ) `tw` ON `tw`.`author_id` = `au`.`id` WHERE MATCH (`tags`) AGAINST ('+#media' IN BOOLEAN MODE) AND (1)
|
| 0.0041 |
SELECT * FROM `authors` JOIN `tweets`ON `authors`.id = `tweets`.author_id WHERE `authors`.`screen_name` = 'touteleurope' LIMIT 1
|
| 0.0001 |
SELECT * FROM `authors` JOIN `tweets`ON `authors`.id = `tweets`.author_id WHERE `authors`.`screen_name` = 'jerzybuzek' LIMIT 1
|
| 0.0001 |
SELECT * FROM `authors` JOIN `tweets`ON `authors`.id = `tweets`.author_id WHERE `authors`.`screen_name` = 'EuropeanVoiceEV' LIMIT 1
|
| 0.0001 |
SELECT * FROM `authors` JOIN `tweets`ON `authors`.id = `tweets`.author_id WHERE `authors`.`screen_name` = 'jmdbarraso' LIMIT 1
|
| 0.0001 |
SELECT * FROM `authors` JOIN `tweets`ON `authors`.id = `tweets`.author_id WHERE `authors`.`screen_name` = 'quatremer' LIMIT 1
|
| 0.0005 |
SELECT screen_name, name, description, avatar, followers FROM `authors` WHERE ((`authors`.`tags` LIKE '%politicalgroup#%')) AND (1) ORDER BY `authors`.`followers` desc LIMIT 5;
|