SELECT
data_items.*
FROM
(
SELECT
IF(ISNULL(last_version_per_actual_language.ID),last_version_per_hu.ID,last_version_per_actual_language.ID) as good_id
FROM
(SELECT
*
FROM
view_data_items_last_version_per_languages
WHERE
language_id=1 AND status_id=6) AS last_version_per_hu
LEFT JOIN
(SELECT
*
FROM
view_data_items_last_version_per_languages
WHERE
language_id=1 AND status_id=6) AS last_version_per_actual_language
ON last_version_per_hu.data_head_id=last_version_per_actual_language.data_head_id) AS last_version_good_id
LEFT JOIN data_items
ON last_version_good_id.good_id=data_items.ID
WHERE
data_head_id=ifs-falba-helyezheto-kotegelo-talp
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ifs' in 'where clause'CELO Termékek Webáruház
