Fehler 1 in beim Aufruf von sql_query mit der Query
SELECT
t0.filename, t0.mimetype, t1.content AS image_title, t2.content AS image_description, t0.filename_original
FROM asset_file t0
LEFT JOIN asset_text t1 ON t1.id = t0.title_id
LEFT JOIN asset_text t2 ON t2.id = t0.description_id
WHERE
t0.reference_id = AND
t0.online = 1 AND
t0.module_id = 4
GROUP BY t0.id
ORDER BY t0.sorting ASC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND
t0.online = 1 AND
t0.module_id = 4
GR' at line 8
Fehler 1 in beim Aufruf von sql_query mit der Query
SELECT
t0.filename, t0.mimetype, t1.content AS image_title, t2.content AS image_description, t0.filename_original
FROM asset_file t0
LEFT JOIN asset_text t1 ON t1.id = t0.title_id
LEFT JOIN asset_text t2 ON t2.id = t0.description_id
WHERE
t0.reference_id = AND
t0.online = 1 AND
t0.module_id = 4
GROUP BY t0.id
ORDER BY t0.sorting ASC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND
t0.online = 1 AND
t0.module_id = 4
GR' at line 8
//
weniger
Fehler 1 in beim Aufruf von sql_query mit der Query
SELECT
t0.id AS entry_id,
t5.content AS title,
t6.content AS teaser_title,
t7.content AS text,
t8.content AS teaser_text,
t3.content AS category_realurl, t3.counter AS category_realurl_counter,
t4.content AS entry_realurl, t4.counter AS entry_realurl_counter,
t0.title_id,
t0.text_id,
t0.teaser_title_id,
t0.teaser_text_id,
t0.entry_date,
t0.allow_comments,
t0.teaser_link,
t0.teaser_link_target
FROM (SELECT * FROM newssystem_entry WHERE online = 1 AND id != ) AS t0
INNER JOIN `newssystem_entry-category` t1 ON (t1.entry_id = t0.id AND t1.category_id = 2)
INNER JOIN newssystem_category t2 ON (t2.id = t1.category_id AND t2.online = 1 AND t2.id = 2)
INNER JOIN realurl t3 ON t3.id = t2.realurl_id
INNER JOIN realurl t4 ON t4.id = t0.realurl_id
INNER JOIN asset_text t5 ON t5.id = t0.title_id
LEFT JOIN asset_text t6 ON t6.id = t0.teaser_title_id
INNER JOIN asset_text t7 ON t7.id = t0.text_id
LEFT JOIN asset_text t8 ON t8.id = t0.teaser_text_id
WHERE t0.highlight = 0 AND t1.highlight = 0
GROUP BY t0.id
ORDER BY t0.create_date DESC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS t0
INNER JOIN `newssystem_entry-category` t1 ON (t1.entry_id = t0.id AN' at line 19