No quote(s) found. Enjoy reading the query:
SELECT q.id, q.text, q.when_said, q.added_when, u.pn_uname, YEAR(q.when_said) AS when_said_year, LPAD(MONTH(q.when_said), 2, '0') AS when_said_month, LPAD(DAYOFMONTH(q.when_said), 2, '0') AS when_said_day, SUM(v.vote) AS rating, COUNT(v.vote) AS num_votes, m.vote IS NOT NULL AS voted FROM irc_quotes q LEFT JOIN nuke_users u ON q.added_by = u.pn_uid LEFT JOIN irc_quotes_votes v ON q.id = v.quote_id LEFT JOIN irc_quotes_votes m ON q.id = m.quote_idWHERE text like '%Candover%' GROUP BY q.id, m.vote ORDER BY rating DESC, num_votes DESC LIMIT 50
Don't Click