Sql query failed (2): ' SELECT
bild.id_media,
bild.url,
media_x_bild.position_slave,
CASE WHEN bild.title = '' THEN media_text_ml.text_value ELSE bild.title END AS title,
bild.sub_title,
descr.text_value AS descr,
tmedia.filesystem_file,
tmedia.filesystem_path,
tmedia.width,
tmedia.height,
bild.artist0
FROM
cb_mdb.tmedia as bild
LEFT JOIN cb_mdb.media_x_media AS media_x_bild
ON bild.id_media=cb_mdb.media_x_bild.id_media_slave
AND media_x_bild.id_relation=2
LEFT JOIN cb_mdb.media_x_media AS media_x_file
ON cb_mdb.media_x_bild.id_media_slave=cb_mdb.media_x_file.id_media_master
AND media_x_file.id_relation=1
LEFT JOIN cb_mdb.tmedia
ON tmedia.id_media=cb_mdb.media_x_file.id_media_slave
LEFT JOIN cb_mdb.media_x_media AS media_x_title
ON bild.id_media=cb_mdb.media_x_title.id_media_master
AND media_x_title.id_relation=3
LEFT JOIN cb_mdb.media_text_ml
ON media_x_title.id_media_slave = media_text_ml.id_media_text
LEFT JOIN cb_mdb.media_x_media AS media_x_descr
ON bild.id_media=cb_mdb.media_x_descr.id_media_master
AND media_x_descr.id_relation=7
LEFT JOIN cb_mdb.media_text_ml AS descr
ON media_x_descr.id_media_slave = descr.id_media_text
AND descr.id_language =
WHERE
media_x_bild.id_media_master in (6549236)
GROUP BY bild.id_media ORDER BY position_slave '. -- MySQL Error: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE
media_x_bild.id_media_master in (6549236)
GROUP BY bi' at line 35