Error!Catched error 40642000: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'GROUP BY en_product.id
                ORDER BY  `stock` DESC, `code` ASC, `pri' at line 33
	in /home/vpkpodsh/public_html/library/pdo.php on line 45.
	Query: 'select en_product.id,
                        en_product.img,
                        en_product.youtube,
                        en_product.url, 
                        en_product.name, 
                        en_product.price,
                        en_product.text, 
                        en_product.size, 
                        en_product.size2, 
                        en_product.height,
                        en_product.stock, 
                        en_product.kind,
                        en_product.characteristics,
                        en_catalog.name as catalog,
                        en_catalog.url as cat_url, 
                        en_catalog.name_one,
                        favorites.product_id as fav_id,
                        d.title as brend_name
                ,CASE price
                        WHEN 0 THEN 100000
                        ELSE price
                    END AS price_sort
                from en_product
                LEFT JOIN en_catalog ON en_catalog.id=en_product.cat_id
                LEFT JOIN favorites ON favorites.product_id = en_product.id AND favorites.session_id = '4dcccd9a58b1764ccbeb44ac25d12d9a'
                LEFT JOIN product_countries prod_c ON prod_c.product_id=en_product.id
                LEFT JOIN en_brend d ON d.id=en_product.brend_id
                WHERE 
                en_product.id!='0' and
                en_product.name!='' AND
                en_product.url!=''
                AND prod_c.countries_id =  
                GROUP BY en_product.id
                ORDER BY  `stock` DESC, `code` ASC, `price_sort` DESC, `name` asc, id desc'.