Днес научих ново трик, наречен #Felidae ,което означава семейство от котки. И тъй като съм виждал да те тагват в много постове свързани с котки @disappointed +1
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00024
SELECT user_id FROM posts_reshares WHERE post_id="1446274" ORDER BY id DESC LIMIT 1
0.00032
SELECT * FROM posts_comments WHERE post_id="1446274" ORDER BY id ASC
0.00022
SELECT user_id FROM posts_mentioned WHERE post_id="1446274" LIMIT 1
0.00028
SELECT * FROM users_details WHERE user_id="17120" LIMIT 1
0.00036
SELECT * FROM users WHERE id="17120" LIMIT 1
1.02522
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%felidae%") AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15
0.44552
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%felidae%") AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00034
SELECT id FROM groups WHERE is_public=0
0.07564
SELECT post_id FROM posts_comments WHERE message LIKE "%felidae%"
0.00033
SELECT id FROM searches WHERE user_id="" AND search_key="96bcb3b513b0074eaadbd5e0b7363170" LIMIT 1
0.00028
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1
за всеки пост, в който съм тагната и е свързан с котки - по левче.
Mar 27 2013, 11:25