SQLException ERROR: 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 EavDateValue LEFT JOIN EavField ON fieldID = EavField.ID ' at line 1] [User Info: SELECT EavDateValue.*, NULL AS valueID, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavDateValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavStringValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavStringValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavNumericValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavNumericValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavItem.objectID, EavItem.fieldID, EavValue.value, EavValue.ID, EavValue.position, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* FROM EavItem LEFT JOIN EavValue ON EavItem.valueID = EavValue.ID LEFT JOIN EavField ON EavItem.fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition]
FILE TRACE:

0: "/home/grupotec/public_html/library/activerecord/ActiveRecord.php":1197 - MySQLConnection->executeQuery(" SELECT EavDateValue.*, NULL AS valueID, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavDateValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavStringValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavStringValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavNumericValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavNumericValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavItem.objectID, EavItem.fieldID, EavValue.value, EavValue.ID, EavValue.position, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* FROM EavItem LEFT JOIN EavValue ON EavItem.valueID = EavValue.ID LEFT JOIN EavField ON EavItem.fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
1: "/home/grupotec/public_html/application/model/eavcommon/EavSpecificationManagerCommon.php":725 - ActiveRecord::getDataBySQL(" SELECT EavDateValue.*, NULL AS valueID, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavDateValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavStringValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavStringValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavNumericValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavNumericValue LEFT JOIN EavField ON fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) UNION SELECT EavItem.objectID, EavItem.fieldID, EavValue.value, EavValue.ID, EavValue.position, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* FROM EavItem LEFT JOIN EavValue ON EavItem.valueID = EavValue.ID LEFT JOIN EavField ON EavItem.fieldID = EavField.ID LEFT JOIN EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID WHERE objectID IN (3, 14, 23) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
2: "/home/grupotec/public_html/application/model/eavcommon/EavSpecificationManagerCommon.php":735 - EavSpecificationManagerCommon::fetchRawSpecificationData("EavSpecificationManager", Array, true)
3: "/home/grupotec/public_html/application/model/eavcommon/EavSpecificationManagerCommon.php":588 - EavSpecificationManagerCommon::fetchSpecificationData("EavSpecificationManager", Array, true)
4: "/home/grupotec/public_html/application/model/eav/EavSpecificationManager.php":105 - EavSpecificationManagerCommon::loadSpecificationForRecordSetArray("EavSpecificationManager", Array, true)
5: "/home/grupotec/public_html/application/model/ActiveRecordModel.php":307 - EavSpecificationManager::loadSpecificationForRecordSetArray(Array, true)
6: "/home/grupotec/public_html/application/LiveCart.php":452 - ActiveRecordModel::loadEav()
7: "/home/grupotec/public_html/framework/Application.php":308 - LiveCart->postProcessResponse((object)ActionResponse, (object)ErrController)
8: "/home/grupotec/public_html/application/LiveCart.php":416 - Application->execute((object)ErrController, "redirect")
9: "/home/grupotec/public_html/framework/Application.php":197 - LiveCart->execute((object)ErrController, "redirect")
10: "/home/grupotec/public_html/public/index.php":70 - Application->run()
11: "/home/grupotec/public_html/public/index.php":147 - runApp((object)LiveCart)
12: "/home/grupotec/public_html/public/index.php":151 - runApp()