Condividi

Function: _Search
Query: SELECT SQL_CALC_FOUND_ROWS c.*, CONCAT('/contenuti/',c.ID,'/',c.immagine) AS path, cat.nome AS categoriaNome FROM contenuti AS c LEFT JOIN configura_categoria AS cat ON (c.categoriaID = cat.ID) WHERE c.abilitato=1 AND c.categoriaID=22 AND c.ID< ORDER BY c.ID DESC LIMIT 0, 1
Array
(
    [] => 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 'ORDER BY c.ID DESC LIMIT 0, 1' at line 6
)
Function: _Search
Query: SELECT SQL_CALC_FOUND_ROWS c.*, CONCAT('/contenuti/',c.ID,'/',c.immagine) AS path, cat.nome AS categoriaNome FROM contenuti AS c LEFT JOIN configura_categoria AS cat ON (c.categoriaID = cat.ID) WHERE c.abilitato=1 AND c.categoriaID=22 AND c.ID> ORDER BY c.ID ASC LIMIT 0, 1
Array
(
    [] => 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 'ORDER BY c.ID DESC LIMIT 0, 1' at line 6
    [1] => 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 'ORDER BY c.ID ASC LIMIT 0, 1' at line 6
)

Case Studies

    Function: _Search
    Query: SELECT SQL_CALC_FOUND_ROWS c.*, CONCAT('/contenuti/',c.ID,'/',c.immagine) AS path, cat.nome AS categoriaNome FROM contenuti AS c LEFT JOIN configura_categoria AS cat ON (c.categoriaID = cat.ID) WHERE c.abilitato=1 AND c.ID!= ORDER BY c.data ASC
    Array
    (
        [] => 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 'ORDER BY c.ID DESC LIMIT 0, 1' at line 6
        [1] => 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 'ORDER BY c.ID ASC LIMIT 0, 1' at line 6
        [2] => 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 'ORDER BY c.data ASC' at line 6
    )