1
|----------- SQL Statement ---------------|
1
|Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'typo3.tx_dam.date_cr' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by|
limit
select count(*)
local_table tx_dam
mm_table tx_dam_mm_cat
foreign_table tx_dam_cat
order_by date_cr
group_by file_name
where AND tx_dam.deleted=0 AND tx_dam.t3ver_state<=0 AND tx_dam.pid!=-1 AND tx_dam.hidden=0 AND tx_dam.starttime<=1627537080 AND (tx_dam.endtime=0 OR tx_dam.endtime>1627537080) AND (tx_dam.fe_group='' OR tx_dam.fe_group IS NULL OR tx_dam.fe_group='0' OR (tx_dam.fe_group LIKE '%,0,%' OR tx_dam.fe_group LIKE '0,%' OR tx_dam.fe_group LIKE '%,0' OR tx_dam.fe_group='0') OR (tx_dam.fe_group LIKE '%,-1,%' OR tx_dam.fe_group LIKE '-1,%' OR tx_dam.fe_group LIKE '%,-1' OR tx_dam.fe_group='-1')) AND tx_dam_cat.deleted=0 AND tx_dam_cat.t3ver_state<=0 AND tx_dam_cat.pid!=-1 AND tx_dam_cat.hidden=0 AND (tx_dam_cat.fe_group='' OR tx_dam_cat.fe_group IS NULL OR tx_dam_cat.fe_group='0' OR (tx_dam_cat.fe_group LIKE '%,0,%' OR tx_dam_cat.fe_group LIKE '0,%' OR tx_dam_cat.fe_group LIKE '%,0' OR tx_dam_cat.fe_group='0') OR (tx_dam_cat.fe_group LIKE '%,-1,%' OR tx_dam_cat.fe_group LIKE '-1,%' OR tx_dam_cat.fe_group LIKE '%,-1' OR tx_dam_cat.fe_group='-1')) AND tx_dam.sys_language_uid IN (0,-1) AND (tx_dam_cat.uid IN (27) )
1
|++++++++++++++++++++++++++++++++++++++++++|
Archiv Print - FRANZ DÜRHOLDT GmbH & Co. KG - Industriearmaturen - THE VALVE COMPANY