Database Error
Mensaje de error de regresar de la base de datos:
Could not execute query [Native Error: 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 'as valueID FROM SpecificationDateValue
LEFT JOIN
SpecField ON specFieldID ' at line 1] [User Info:
SELECT SpecificationDateValue.*, NULL AS valueID, NULL AS specFieldValuePosition, SpecFieldGroup.position AS SpecFieldGroupPosition, SpecFieldGroup.name AS SpecFieldGroupName, SpecField.* as valueID FROM SpecificationDateValue
LEFT JOIN
SpecField ON specFieldID = SpecField.ID
LEFT JOIN
SpecFieldGroup ON SpecField.specFieldGroupID = SpecFieldGroup.ID
WHERE
productID IN (45591, 45592, 45593, 45878, 45879, 40526, 44630, 44631, 44632, 44633, 44634, 44635, 44636, 44637, 44144) AND SpecField.isDisplayedInList = 1
UNION
SELECT SpecificationStringValue.*, NULL, NULL AS specFieldValuePosition, SpecFieldGroup.position AS SpecFieldGroupPosition, SpecFieldGroup.name AS SpecFieldGroupName, SpecField.* as valueID FROM SpecificationStringValue
LEFT JOIN
SpecField ON specFieldID = SpecField.ID
LEFT JOIN
SpecFieldGroup ON SpecField.specFieldGroupID = SpecFieldGroup.ID
WHERE
productID IN (45591, 45592, 45593, 45878, 45879, 40526, 44630, 44631, 44632, 44633, 44634, 44635, 44636, 44637, 44144) AND SpecField.isDisplayedInList = 1
UNION
SELECT SpecificationNumericValue.*, NULL, NULL AS specFieldValuePosition, SpecFieldGroup.position AS SpecFieldGroupPosition, SpecFieldGroup.name AS SpecFieldGroupName, SpecField.* as valueID FROM SpecificationNumericValue
LEFT JOIN
SpecField ON specFieldID = SpecField.ID
LEFT JOIN
SpecFieldGroup ON SpecField.specFieldGroupID = SpecFieldGroup.ID
WHERE
productID IN (45591, 45592, 45593, 45878, 45879, 40526, 44630, 44631, 44632, 44633, 44634, 44635, 44636, 44637, 44144) AND SpecField.isDisplayedInList = 1
UNION
SELECT SpecificationItem.productID, SpecificationItem.specFieldID, SpecFieldValue.value, SpecFieldValue.ID, SpecFieldValue.position, SpecFieldGroup.position AS SpecFieldGroupPosition, SpecFieldGroup.name AS SpecFieldGroupName, SpecField.*
FROM SpecificationItem
LEFT JOIN SpecFieldValue ON SpecificationItem.specFieldValueID = SpecFieldValue.ID
LEFT JOIN
SpecField ON SpecificationItem.specFieldID = SpecField.ID
LEFT JOIN
SpecFieldGroup ON SpecField.specFieldGroupID = SpecFieldGroup.ID
WHERE
productID IN (45591, 45592, 45593, 45878, 45879, 40526, 44630, 44631, 44632, 44633, 44634, 44635, 44636, 44637, 44144) AND SpecField.isDisplayedInList = 1 ORDER BY productID, SpecFieldGroupPosition, position, specFieldValuePosition]