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