| 0.0002 |
SELECT *
FROM (`metrics_keyword`)
WHERE `enabled` = '1'
|
| 0.1130 |
SELECT COUNT(*) AS occurences, DATE(published_at) as published_at
FROM tweets
WHERE
MATCH (`content`) AGAINST ('sarkozy' IN BOOLEAN MODE) AND
published_at > SUBDATE(NOW(), INTERVAL 10 DAY)
GROUP BY DATE(published_at)
ORDER BY published_at ASC
|
| 0.0573 |
SELECT COUNT(*) AS occurences, DATE(published_at) as published_at
FROM tweets
WHERE
MATCH (`content`) AGAINST ('Ashton' IN BOOLEAN MODE) AND
published_at > SUBDATE(NOW(), INTERVAL 10 DAY)
GROUP BY DATE(published_at)
ORDER BY published_at ASC
|
| 0.0370 |
SELECT COUNT(*) AS occurences, DATE(published_at) as published_at
FROM tweets
WHERE
MATCH (`content`) AGAINST ('Merkel' IN BOOLEAN MODE) AND
published_at > SUBDATE(NOW(), INTERVAL 10 DAY)
GROUP BY DATE(published_at)
ORDER BY published_at ASC
|
| 0.0475 |
SELECT COUNT(*) AS occurences, DATE(published_at) as published_at
FROM tweets
WHERE
MATCH (`content`) AGAINST ('rompuy' IN BOOLEAN MODE) AND
published_at > SUBDATE(NOW(), INTERVAL 10 DAY)
GROUP BY DATE(published_at)
ORDER BY published_at ASC
|
| 0.1031 |
SELECT COUNT(*) AS occurences, DATE(published_at) as published_at
FROM tweets
WHERE
MATCH (`content`) AGAINST ('obama' IN BOOLEAN MODE) AND
published_at > SUBDATE(NOW(), INTERVAL 10 DAY)
GROUP BY DATE(published_at)
ORDER BY published_at ASC
|
| 0.0005 |
SELECT screen_name, name, description, avatar, tweets_count FROM `authors`
WHERE
((`authors`.`tags` LIKE '%politicalgroup#%')) AND
(1)
ORDER BY `authors`.`tweets_count` desc LIMIT 3;
|
| 0.0004 |
SELECT screen_name, name, description, avatar, followers FROM `authors`
WHERE
((`authors`.`tags` LIKE '%politicalgroup#%')) AND
(1)
ORDER BY `authors`.`followers` desc LIMIT 3;
|
