WYJĄTEK

SELECT

SQL_CALC_FOUND_ROWS `e`.`id` AS totalRows,
`e`.`id`, `e`.`id_parent`, `e`.`locked`
, `ml`.`name`,
IF (`m`.`id_element` IN (22779, 22779, 22766), 1, 0) AS selected,
`img`.`filename` AS mainImageFilename,
`imgl`.`name` AS mainImageName
FROM `a_Element` AS e
INNER JOIN `a_CategoryModule` AS m ON (`m`.`id_element`=`e`.`id`)
INNER JOIN `a_CategoryModule_lang` AS ml ON (`ml`.`id_element`=`e`.`id` AND `ml`.`id_lang`='297')
LEFT JOIN `a_Position` AS p ON (`p`.`id_element`=`e`.`id` AND `p`.`id_parent` ='22810')

LEFT JOIN `a_RepositoryModule` AS img ON (`img`.`id_linked`=`m`.`id_element` AND `img`.`field`='imageList' AND `img`.`main`='1')
LEFT JOIN `a_RepositoryModule_lang` AS imgl ON (`imgl`.`id_element`=`img`.`id_element` AND `imgl`.`id_lang`=`ml`.`id_lang`)
WHERE `e`.`module` = 'CategoryModule'
AND `m`.`active` = '1' AND `m`.`deleted_at` IS NULL AND `e`.`id_parent` = '22810'
GROUP BY `e`.`id`

ORDER BY `ml`.`name` ASC


#1317 Query execution was interrupted