|
View Collection |
Viewing All Acme Archives Owned By batman3101 This user has a Wishlist. Click Here to view it.
Character Keys
1055: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'registry.designation.designationName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select user.contact,user.userID,model.modelName,model.manufacturer2ID,variation.variationName,manufacturer.manufacturerID,manufacturer.manufacturerName,designation.designationName,category.categoryName,movie.movieName,model_variation.modelEdition,model_variation.modelYear,model.modelID,variation.variationID,category.limited,model_variation.modelURL from user,model,variation,manufacturer,designation,category,movie,model_variation,item where item.itemID=19516 and item.modelID = model.modelID and variation.variationID = item.variationID and manufacturer.manufacturerID = model.manufacturerID and (designation.designationID = item.designationID or item.designationID=0) and category.categoryID = model.categoryID and movie.movieID = model.movieID and model_variation.modelID = item.modelID and model_variation.variationID = item.variationID and user.userID = item.userID group by item.itemID | |