[SQL] SELECT i.*, u.name AS author_name, u.username AS author_username, u.avatar_url AS author_avatar FROM d_idea i left JOIN d_user u ON u.id = i.user_id WHERE i.id = ? AND i.is_draft = 0 | Params: [164532] [SQL] SELECT * FROM d_block WHERE idea_id = ? ORDER BY position ASC, id ASC | Params: [164532] [SQL] SELECT * FROM d_topic WHERE slug IN (?,?,?,?,?) ORDER BY name | Params: ["Money & Investments","Problem Solving","Business","Videos","Product & Design"] [SQL] SELECT i.*, u.name AS author_name, u.username AS author_username, u.avatar_url AS author_avatar FROM d_idea i left JOIN d_user u ON u.id = i.user_id WHERE i.is_draft = 0 AND i.id != ? AND i.hashtags LIKE CONCAT('%', ?, '%') ORDER BY i.total_reads DESC LIMIT ? | Params: [164532,"Money & Investments",3] [SQL] SELECT * FROM d_user WHERE id = ? | Params: [0] [SQL] UPDATE d_idea SET total_reads = total_reads + 1 WHERE id = ? | Params: [164532]
Follow me on Deepstash for great content about UX Design, Human Psycology, Freelancing, Money and much more. I will be posting multiple times daily!
It would mean the world to me if you could follow me on Twitter as well #roadto100followers