MySQL Error [1055] Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tts._4.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select 
	`_0`.id_type as 'меню.id_type' ,
	 `_0`.id_type as 'id_type' ,
	 `_0`.id_sample as 'меню.id_sample' ,
	 `_0`.id_sample as 'id_sample' ,
	 `_2`.pos as 'menu_item.pos' ,
	 `_2`.value as 'menu_item'  ,
	 `_4`.value as 'print_if'  ,
	 `_3`.value as 'menu_кратко'  ,
	 `_5`.value as 'menu_url'  ,
	 `_6`.value as 'menu_caption'  ,
	 `_7`.value as 'menu_menu'  
from 
	sample_tts as `_0` /* подключили меню[кратко] by StrictFilter */  

	LEFT JOIN /* подключаю массив !!!! */
					sample_tts as `_2` on
					`_2`.id_type   = 88    and
					`_2`.id_var    = 95    and
					`_2`.id_sample = `_0`.id_sample
				  
	LEFT JOIN /* добавляем поле меню->пункты[кратко] */
					sample_tts as `_3` on
						`_3`.id_type   = '87' /*  */ and
						`_3`.id_var    = '103'   /*  */ and
						`_3`.id_sample = `_2`.value
				  
	LEFT JOIN /* добавляем поле меню->пункты[print_if] */
					sample_tts as `_4` on
						`_4`.id_type   = '87' /*  */ and
						`_4`.id_var    = '266'   /*  */ and
						`_4`.id_sample = `_2`.value
				  
	LEFT JOIN /* добавляем поле меню->пункты[url] */
					sample_tts as `_5` on
						`_5`.id_type   = '87' /*  */ and
						`_5`.id_var    = '104'   /*  */ and
						`_5`.id_sample = `_2`.value
				  
	LEFT JOIN /* добавляем поле меню->пункты[caption] */
					sample_tts as `_6` on
						`_6`.id_type   = '87' /*  */ and
						`_6`.id_var    = '94'   /*  */ and
						`_6`.id_sample = `_2`.value
				  
	LEFT JOIN /* подключили составное поле меню->пункты[суб-меню] */
					sample_tts as `_7` on
						`_7`.id_type   = '87'  /*  */ and
						`_7`.id_var    = '90'    /*  */ and
						`_7`.id_sample = `_2`.value
				 
where 
	`_0`.id_type = '88' and 
	`_0`.id_var = '106' and 
	((`_0`.value = '.main')) 
group by 
	`_0`.id_sample , 
	`_2`.pos  
order by 
	`_3`.value  asc