Site Menu
Home
Checklists
Reports
About The Registry
Forum
Registries Menu
Abrams
Acme Archives
Attakus
Code 3
eFX
Epic Ink
Fossil Watches
Gentle Giant
Hasbro
Hot Toys
Icons
ID-Wall
Illusive Concepts
Insight Editions
Kotobukiya
Master Replicas
Medicom
Noble Studio
Riddell
Scholastic
Sideshow
StarWarsShop.com
Super 7
Tamashii Nations
Treasure Craft
View User Collections
Login
Username

Password


Forgot your password?

No account yet?
Sign Up Now!
Privacy Policy
Collector Spotlight
Name : Andreas G.
Collectibles : 130
View Collection
Entertainment Earth
View Collection
Viewing All Owned By jkno



Collection Pictures








Acme Archives

Giclees - Paper

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=47173 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