вот данные по базе

agat 29.05.2007 12:33

результат Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	article	ALL	PRIMARY,group_id,dt_published,is_active	NULL	NULL	NULL	4684	Using where; Using temporary; Using filesort
1	SIMPLE	groups	eq_ref	PRIMARY	PRIMARY	4	qha.article.group_id	1	Using where
1	SIMPLE	article_translation	ref	article_id_2	article_id_2	5	qha.article.id,const	1	Using index

вот индексы для таблицы groups

Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
groups	0	PRIMARY	1	id	A	36	NULL	NULL		BTREE	
groups	1	parent_ix	1	parent_id	A	2	NULL	NULL		BTREE	
groups	1	type_is	1	type_is	A	9	NULL	NULL		BTREE	

для таблицы article

Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
article	0	PRIMARY	1	id	A	6245	NULL	NULL		BTREE	
article	1	group_id	1	group_id	A	12	NULL	NULL		BTREE	
article	1	region_id	1	region_id	A	2	NULL	NULL		BTREE	
article	1	dt_published	1	dt_published	A	6245	NULL	NULL		BTREE	
article	1	is_active	1	is_active	A	0	NULL	NULL		BTREE	
article	1	parent_id	1	parent_id	A	122	NULL	NULL		BTREE	

и для таблицы article_translation

Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
article_translation	0	PRIMARY	1	id	A	8800	NULL	NULL		BTREE	
article_translation	1	article_id_2	1	article_id	A	8800	NULL	NULL		BTREE	
article_translation	1	article_id_2	2	lang_id	A	8800	NULL	NULL		BTREE	
article_translation	1	title	1	title	NULL	8800	NULL	NULL	YES	FULLTEXT	
article_translation	1	body	1	body	NULL	8800	NULL	NULL	YES	FULLTEXT	

Разбить на два запроса..хмм. Попробую. И дополнительное поле можно попробовать.

---