SELECT * FROM articles WHERE active!=0 AND lang_id IN (SELECT id FROM langs WHERE lang="en") ORDER BY date DESC LIMIT 0,6en/