[ SQL ERROR ]
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 ';= 0, 1, 0) AS `badge_danger`, cp.`position`, ( SELECT C...' at line 32

SELECT a.`id_product`, 
    b.`name` AS `name`, 
    a.`location` AS `location`, 
    sa.`active` AS `active`, 
    a.`note` AS `note`, 
    sa.`visibility` AS `visibility`, 
    a.`reference` AS `reference`, 
    sa.`price` AS `price`, 
    sa.`date_add` AS `date_add`, 
    sa.`available_for_order` AS `available_for_order`, 
    cp.`position` AS `position`, 
    shop.`name` AS `shopname`, 
    a.`id_shop_default`, 
    (
        SELECT `id_image` 
        FROM `tkzimage_shop` 
        WHERE `cover` = 1 
        AND COALESCE(`id_lang`, 0) IN (0, 1) 
        AND `id_shop` = a.`id_shop_default` 
        AND `id_product` = a.`id_product` 
        ORDER BY `id_lang` DESC 
        LIMIT 1
    ) as `id_image`, 
    cl.`name` AS `name_category`, 
    sa.`price`, 
    0 AS `price_final`, 
    if(pas.`id_product`, 1, 0) AS `scheduled`, 
    a.`is_virtual`, 
    pd.`nb_downloadable`, 
    sav.`quantity` AS `sav_quantity`, 
    sa.`active`, 
    IF(sav.`quantity` <= 0, 1, 0) AS `badge_danger`, 
    cp.`position`, 
    (
        SELECT COUNT(DISTINCT(pa.`id_product_attribute`)
            ) 
        FROM `tkzproduct_attribute` pa 
        INNER JOIN `tkzproduct_attribute_shop` product_attribute_shop 
            ON(product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute` 
                AND product_attribute_shop.`id_shop` = 1
            ) 
        WHERE pa.`id_product` = a.`id_product` 
        ORDER BY NULL
    ) as `nb_attributes` 
FROM `tkzproduct` a 
LEFT JOIN `tkzproduct_lang` b 
    ON(b.`id_product` = a.`id_product` 
        AND b.`id_lang` = 1 
        AND b.`id_shop` = 1
    ) 
LEFT JOIN `tkzstock_available` `sav` 
    ON(sav.`id_product` = a.`id_product` 
        AND sav.`id_product_attribute` = 0 
        AND sav.`id_shop` = 1 
        AND sav.`id_shop_group` = 0
    ) 
LEFT JOIN `tkzproduct_activation_schedule` `pas` 
    ON(pas.`id_product` = a.`id_product` 
        AND pas.`id_shop` IN (1)
    ) 
LEFT JOIN `tkzproduct_shop` `sa` 
    ON(a.`id_product` = sa.`id_product` 
        AND sa.`id_shop` = a.`id_shop_default`
    ) 
LEFT JOIN `tkzcategory_lang` `cl` 
    ON(sa.`id_category_default` = cl.`id_category` 
        AND cl.`id_lang` = 1 
        AND cl.`id_shop` = a.`id_shop_default`
    ) 
LEFT JOIN `tkzshop` `shop` 
    ON(shop.`id_shop` = a.`id_shop_default`) 
LEFT JOIN `tkzproduct_download` `pd` 
    ON(pd.`id_product` = a.`id_product` 
        AND pd.`id_product_attribute` = a.`cache_default_attribute` 
        AND pd.`active` = 1
    ) 
INNER JOIN `tkzcategory_product` `cp` 
    ON(cp.`id_product` = a.`id_product` 
        AND cp.`id_category` = 36
    ) 
WHERE 1 
ORDER BY cp.`position` ASC, 
    a.`id_product` ASC

    DbCore->displayError in /classes/db/Db.php:482
    DbCore->query in /classes/db/Db.php:723
    DbCore->executeS in /classes/RequestSql.php:222
    RequestSqlCore->validateSql in /classes/RequestSql.php:173
    RequestSqlCore->validateParser in /controllers/admin/AdminRequestSqlController.php:400
    AdminRequestSqlControllerCore->_childValidation in /classes/controller/AdminController.php:4575
    AdminControllerCore->validateRules in /classes/controller/AdminController.php:1429
    AdminControllerCore->processAdd in /classes/controller/AdminController.php:1413
    AdminControllerCore->processSave in /classes/controller/AdminController.php:1174
    AdminControllerCore->postProcess in /controllers/admin/AdminRequestSqlController.php:339
    AdminRequestSqlControllerCore->postProcess in /classes/controller/Controller.php:351
    ControllerCore->run in /classes/Dispatcher.php:435
    DispatcherCore->dispatch in //index.php:83