SELECT p.ID, p.Price0, p.Price7, p.Name, p.LongDesc, p.BigPic,
p.HugePic, p.DontShow
FROM Products p
WHERE p.ID = 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 '' at line 4
SELECT p.ID, p.Name, p2p.Value
FROM Properties p
INNER JOIN Properties2Products p2p ON p2p.Property = p.ID
WHERE p2p.Product = AND p.PropertiesGroup = 1
ORDER BY p.Priority 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 p.PropertiesGroup = 1
ORDER BY p.Priority' at line 4
SELECT p.ID, p.Name, p2p.Value
FROM Properties p
INNER JOIN Properties2Products p2p ON p2p.Property = p.ID
WHERE p2p.Product = AND p.PropertiesGroup IS NULL
ORDER BY p.Priority 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 p.PropertiesGroup IS NULL
ORDER BY p.Priority' at line 4
SELECT IF(p2p.Product1 = , p2.Name, p1.Name),
IF(p2p.Product1 = , p2p.Link2, p2p.Link1)
FROM Products2Products p2p
INNER JOIN Products p1 ON p2p.Product1 = p1.ID
INNER JOIN Products p2 ON p2p.Product2 = p2.ID
WHERE (p2p.Product1 = ) OR (p2p.Product2 = ) 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 ' p2.Name, p1.Name),
IF(p2p.Product1 = , p2p.Link2, p2p.Link1)
FROM Products2Pro' at line 1 |
