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 'AND
dd.name IS NOT NULL
AND
dd.db_document_type_id=2
ORDER BY dd' at line 14
SQL :
SELECT COUNT(*) as cnt FROM
(
SELECT
dd.content as Popis,
dd.id ,
dd.name as Name,
DATE_FORMAT(dd.date,'%d.%m.%Y') as Datum
FROM db_document dd
JOIN db_document dd_parent ON dd_parent.id = dd.db_document_id
WHERE
dd.db_database_component_id = 6
AND
dd_parent.id =
AND
dd.name IS NOT NULL
AND
dd.db_document_type_id=2
ORDER BY dd.date DESC,dd.id DESC
)SubT
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 'AND
dd.name IS NOT NULL
AND
dd.db_document_type_id=2
ORDER BY dd' at line 12
SQL : SELECT
dd.content as Popis,
dd.id ,
dd.name as Name,
DATE_FORMAT(dd.date,'%d.%m.%Y') as Datum
FROM db_document dd
JOIN db_document dd_parent ON dd_parent.id = dd.db_document_id
WHERE
dd.db_database_component_id = 6
AND
dd_parent.id =
AND
dd.name IS NOT NULL
AND
dd.db_document_type_id=2
ORDER BY dd.date DESC,dd.id DESC LIMIT 0, 3