לפלט הזה אתה מתכוון?
http://i.imgur.com/ZlkqyfC.png
וזו השאילתה שכתבתי:
קוד:
SELECT content.sid, content.time, categories.id
FROM content
JOIN urls ON content.sid = urls.id
JOIN associations ON urls.id = associations.sid
JOIN categories ON associations.catid = categories.id
WHERE categories.keywords = '$keyword' AND content.time > $timescale
ORDER BY content.views DESC
LIMIT 0,5
תודה.