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 'range
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
' at line 9
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
node.type AS node_type,
node.uid AS node_uid,
node_revisions.format AS node_revisions_format,
node.vid AS node_vid,
uc_products.model AS uc_products_model,
uc_products.nid AS uc_products_nid
FROM node node
LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 2010-range
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid
WHERE (node.status <> 0) AND (node.type IN ('product','chandelier')) AND (term_node_value_0.tid = 2010)
ORDER BY uc_products_model ASC
) count_alias in /usr/www/users/limelq/sites/all/modules/views/includes/view.inc on line 729.
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 'range
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
' at line 9
query: SELECT DISTINCT(node.nid) AS nid,
node.type AS node_type,
node.uid AS node_uid,
node_revisions.format AS node_revisions_format,
node.vid AS node_vid,
uc_products.model AS uc_products_model,
uc_products.nid AS uc_products_nid
FROM node node
LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 2010-range
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid
WHERE (node.status <> 0) AND (node.type IN ('product','chandelier')) AND (term_node_value_0.tid = 2010)
ORDER BY uc_products_model ASC
LIMIT 0, 50 in /usr/www/users/limelq/sites/all/modules/views/includes/view.inc on line 755.
You are here
Retail Catalogue
Retail Catalogue
Our Portfolio
This category is empty.
Enquiry List
Your Enquiry List is empty!
Browse our online Retail Catalogue to add products items of interest to your enquiry list.
Submit your Enquiry to us and one of our sales representatives will respond shortly.
