Code: Select all
SELECT a.id, a.name, a.description, a.category_id, a.language_id, a.guid from quizzes a
inner join quiz_ratings b on a.id = b.quiz_id
where a.active = '1' and YEARWEEK(b.created_dt) = YEARWEEK(CURRENT_DATE - INTERVAL 7 DAY)
Any ideas? Thanks!