<b>MySQL server error report:Array
(
    [0] => Array
        (
            [message] => MySQL Query Error
        )

    [1] => Array
        (
            [sql] => SELECT count(*) FROM `dscmall`.`dsc_goods` as g 
            LEFT JOIN (
                SELECT cp.goods_id
                FROM `dscmall`.`dsc_catalogue_product` cp
                INNER JOIN `dscmall`.`dsc_catalogue` c ON cp.catalogue_id = c.catalogue_id
                WHERE c.catalogue_type = 'public' AND c.catalogue_id = 1
            ) AS cat_goods ON cat_goods.goods_id = g.goods_id
         WHERE 1 AND g.review_status > 2  and g.user_id = '120'  AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.is_show = 1  
            LEFT JOIN (
                SELECT cp.goods_id
                FROM `dscmall`.`dsc_catalogue_product` cp
                INNER JOIN `dscmall`.`dsc_catalogue` c ON cp.catalogue_id = c.catalogue_id
                WHERE c.catalogue_type = 'public' AND c.catalogue_id = 1
            ) AS cat_goods ON cat_goods.goods_id = g.goods_id
        AND NOT EXISTS (
            SELECT 1 FROM `dscmall`.`dsc_product_visibility` 
            WHERE is_show = 0 
            AND company_id = 0
            AND (
                FIND_IN_SET(g.goods_id, product_id) > 0
                OR 
                FIND_IN_SET(g.cat_id, category_id) > 0
            )
        )OR EXISTS (
            SELECT 1 FROM `dscmall`.`dsc_product_visibility` 
            WHERE is_show = 1
            AND company_id = 0
            AND (
                FIND_IN_SET(g.goods_id, product_id) > 0
                OR 
                FIND_IN_SET(g.cat_id, category_id) > 0
            )
        ) AND cat_goods.goods_id IS NOT NULL  
        )

    [2] => Array
        (
            [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 'LEFT JOIN (\x0A                SELECT cp.goods_id\x0A                FROM `ds...' at line 9
        )

    [3] => Array
        (
            [errno] => 1064
        )

)