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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 4 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 7 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 8 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 19 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 6 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 12 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 15 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 16 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 17 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 18 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 13 AND product_brand_id = ) ORDER BY product_type_id ASCYou 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 product_type_id ASC' at line 14
SELECT (
SELECT product_brand.product_brand_key
FROM product_brand
WHERE product_brand.product_brand_id = product.product_brand_id
) AS pbrand_key,(
SELECT product_type.product_type_parent_id
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS pparent_id, (
SELECT product_type.product_type_name
FROM product_type
WHERE product_type.product_type_id = product.product_type_id
) AS ptype, product.*
FROM product WHERE (product_type_id = 14 AND product_brand_id = ) ORDER BY product_type_id ASC