user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND t.type_id = 14 ORDER BY weight ASC, p.name LIMIT 0, 10' at line 7
query: SELECT p.product_id, p.featured, p.name, p.overview, p.specification, p.maintenance, p.summary, p.url_mapping,
b.name AS brand, b.url_mapping AS brand_mapping, b.manufacturer_id,
t.name AS category, t.url_mapping AS category_mapping
FROM catalog_product AS p
INNER JOIN catalog_manufacturer b ON (b.manufacturer_id = p.manufacturer_id)
INNER JOIN catalog_type t ON (t.type_id = p.type_id)
WHERE b.published = 1 AND ( ) AND t.type_id = 14 ORDER BY weight ASC, p.name LIMIT 0, 10 in /home/vhosts/alpha-digital.co.uk/httpdocs/sites/all/modules/custom/product_mgmt/ui/pages.inc on line 475.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND t.type_id = 14 ORDER BY weight ASC, p.name ) AS c' at line 7
query: SELECT COUNT(1) AS items FROM (SELECT p.product_id, p.featured, p.name, p.overview, p.specification, p.maintenance, p.summary, p.url_mapping,
b.name AS brand, b.url_mapping AS brand_mapping, b.manufacturer_id,
t.name AS category, t.url_mapping AS category_mapping
FROM catalog_product AS p
INNER JOIN catalog_manufacturer b ON (b.manufacturer_id = p.manufacturer_id)
INNER JOIN catalog_type t ON (t.type_id = p.type_id)
WHERE b.published = 1 AND ( ) AND t.type_id = 14 ORDER BY weight ASC, p.name ) AS c in /home/vhosts/alpha-digital.co.uk/httpdocs/sites/all/modules/custom/product_mgmt/ui/pages.inc on line 476.
