正在检查登录状态...

回复吉林手工模型：其中1/3为自制，尼娜、维多利亚、桨帆、胜利、光荣、独立

转发(1)|收藏|评论(1) 2013-2-14 12:16

还真不是咱们自吹自擂，我冷眼观察下来，绝大部分模友还真是好爷们，素质很高。

转发(1)|收藏|评论(1) 2013-2-6 16:4

向一船红砖

转发|收藏|评论 2013-2-5 20:23

1
SELECT * FROM users WHERE id = 12937
SELECT * FROM tweet_statistics WHERE userid = 12937
SELECT SQL_CALC_FOUND_ROWS t.*, s.userid AS s_userid, s.nickname AS s_nickname, s.msg AS s_msg, s.dateline AS s_dateline, s.image_id AS s_image_id, s.video_id AS s_video_id, s.count_forwards AS s_count_forwards, s.count_comments AS s_count_comments FROM tweets AS t LEFT JOIN tweets AS s ON t.source_id = s.id WHERE t.userid = 12937 ORDER BY t.dateline DESC LIMIT 0, 16
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS u.id,u.username,u.nickname,u.headimage FROM users AS u LEFT JOIN user_concerns AS c ON u.id = c.concern_userid WHERE c.userid = 12937 ORDER BY c.dateline DESC LIMIT 0, 3
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS u.id,u.username,u.nickname,u.headimage FROM users AS u LEFT JOIN user_concerns AS c ON u.id = c.concern_userid WHERE c.userid = 12937 ORDER BY c.dateline DESC LIMIT 0, 9
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS u.id,u.username,u.nickname,u.headimage FROM users AS u LEFT JOIN user_concerns AS c ON u.id = c.userid WHERE c.concern_userid = 12937 ORDER BY c.dateline DESC LIMIT 0, 9
SELECT FOUND_ROWS()