INVALID SQL: 1054 : Unknown column 'c.cdseo_url' in 'field list' SQL QUERY FAILURE:
SELECT
c.cdseo_url,
c.categoryid,
c.category
FROM
xcart_categories AS c
LEFT JOIN xcart_category_memberships AS cm ON cm.categoryid = c.categoryid
WHERE
c.avail = 'Y' AND
c.parentid = '0' AND
(cm.membershipid = 0 OR cm.membershipid IS NULL)
ORDER BY
c.order_by asc
INVALID SQL: 1054 : Unknown column 'c.cdseo_url' in 'field list' SQL QUERY FAILURE:
SELECT
c.cdseo_url,
c.category,
c.categoryid
FROM
xcart_categories AS c
LEFT JOIN xcart_category_memberships AS cm ON cm.categoryid = c.categoryid
WHERE
c.parentid = '' AND
c.avail = 'Y' AND
(cm.membershipid = 0 OR cm.membershipid IS NULL)
ORDER BY
c.order_by asc
INVALID SQL: 1064 : 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 'JOIN xcart_product_memberships AS pm ON pc.productid = pm.productid
WHERE
' at line 10 SQL QUERY FAILURE:
SELECT DISTINCT
p.cdseo_url,
p.productid,
p.descr,
p.product
FROM
xcart_products_categories AS pc
LEFT JOIN xcart_products AS p ON pc.productid = p.productid AND pc.categoryid =
LEFT JOIN xcart_product_memberships AS pm ON pc.productid = pm.productid
WHERE
p.forsale = 'Y' AND
(pm.membershipid = 0 OR pm.membershipid IS NULL)
ORDER BY
p.product asc
LIMIT 0, 4
Site Map | The Moorland Rug Company Ltd - Bespoke Designer Rugs
