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