-- SELECT t.content, t.likes_cnt, t.retweet_cnt, t.image_url, DATE_FORMAT(t.created_at,'%e.%c.%Y') AS d, DATE_FORMAT(t.created_at,'%H:%i') AS tm, u.username, u.name, u.avatar_url, lp.image_url AS preview_img, lp.title AS preview_title, lp.url AS preview_url FROM tweets t LEFT JOIN users u ON u.id = t.user_id LEFT JOIN link_previews lp ON lp.tweet_id = t.id WHERE t.site = 'CZ' AND imp = 1 AND substring(t.meta, 1, 5) = 'tweet' ORDER BY t.id DESC LIMIT 21 OFFSET 6460 --