The Boundary (Oldham)

SELECT DISTINCT products.id, products.story, products.product_type, products.media_type, products.media_link_video, products.media_link_audio, products.format, products.date, products.year, products.account, products.image_ratio, accounts.username, accounts.id AS account_id FROM products LEFT JOIN accounts ON (accounts.id = products.account) LEFT JOIN product_keywords ON (product_keywords.product = products.id) WHERE products.status = 1 AND product_keywords.keyword = 6821 ORDER BY products.created DESC LIMIT 0,24