Discussion Forum: Thread 351809

 Author: M_R View Messages Posted By M_R
 Posted: Dec 22, 2023 13:02
 Subject: Way to find set with most parts in a color?
 Viewed: 72 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

M_R (4594)

Location:  Sweden, Södermanland
Member Since Contact Type Status
Sep 3, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Mike´s BrickVault
So the question is - Is there a search that can show which set has the most parts
in a certain color, for example Metallic Gold?

Regards / Mike
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Dec 22, 2023 13:27
 Subject: Re: Way to find set with most parts in a color?
 Viewed: 30 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52565)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
In Help, M_R writes:
  So the question is - Is there a search that can show which set has the most parts
in a certain color, for example Metallic Gold?

Regards / Mike

Sure - simply start with the Color guide:
https://www.bricklink.com/catalogColors.asp

Then, sorted part count DESC, for Metallic Gold:
https://www.bricklink.com/catalogList.asp?pg=1&colorInSet=65&sortBy=P&sortAsc=A&catType=S&v=2
 Author: M_R View Messages Posted By M_R
 Posted: Dec 22, 2023 14:16
 Subject: Re: Way to find set with most parts in a color?
 Viewed: 33 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

M_R (4594)

Location:  Sweden, Södermanland
Member Since Contact Type Status
Sep 3, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Mike´s BrickVault
In Help, 1001bricks writes:
  In Help, M_R writes:
  So the question is - Is there a search that can show which set has the most parts
in a certain color, for example Metallic Gold?

Regards / Mike

Sure - simply start with the Color guide:
https://www.bricklink.com/catalogColors.asp

Then, sorted part count DESC, for Metallic Gold:
https://www.bricklink.com/catalogList.asp?pg=1&colorInSet=65&sortBy=P&sortAsc=A&catType=S&v=2

Ok, but help me out here! If I go with your set-up Order Up the first searches
has none in that color, if I change it to Order Down 10316 Rivendell is the first
and it has two parts in that color. So please help me out more to understand!
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Dec 22, 2023 14:27
 Subject: Re: Way to find set with most parts in a color?
 Viewed: 28 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, M_R writes:
  […]
  Sure - simply start with the Color guide:
https://www.bricklink.com/catalogColors.asp

Then, sorted part count DESC, for Metallic Gold:
https://www.bricklink.com/catalogList.asp?pg=1&colorInSet=65&sortBy=P&sortAsc=A&catType=S&v=2

Ok, but help me out here! If I go with your set-up Order Up the first searches
has none in that color, if I change it to Order Down 10316 Rivendell is the first
and it has two parts in that color. So please help me out more to understand!

It sorts on the total number of parts in the sets, not on the number of parts
(or lots) in that colour.

Well, at least you “only” have 308 inventories to check
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Dec 22, 2023 14:36
 Subject: Re: Way to find set with most parts in a color?
 Viewed: 30 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52565)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
In Help, SylvainLS writes:
  In Help, M_R writes:
  […]
  Sure - simply start with the Color guide:
https://www.bricklink.com/catalogColors.asp

Then, sorted part count DESC, for Metallic Gold:
https://www.bricklink.com/catalogList.asp?pg=1&colorInSet=65&sortBy=P&sortAsc=A&catType=S&v=2

Ok, but help me out here! If I go with your set-up Order Up the first searches
has none in that color, if I change it to Order Down 10316 Rivendell is the first
and it has two parts in that color. So please help me out more to understand!

It sorts on the total number of parts in the sets, not on the number of parts
(or lots) in that colour.

Well, at least you “only” have 308 inventories to check

Ah yes. So I don't know, maybe it's possible - some here are specialists
on BrickLink weird Catalog queries, I'm not.
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Dec 22, 2023 14:30
 Subject: Re: Way to find set with most parts in a color?
 Viewed: 31 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52565)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
In Help, M_R writes:
  In Help, 1001bricks writes:
  In Help, M_R writes:
  So the question is - Is there a search that can show which set has the most parts
in a certain color, for example Metallic Gold?

Regards / Mike

Sure - simply start with the Color guide:
https://www.bricklink.com/catalogColors.asp

Then, sorted part count DESC, for Metallic Gold:
https://www.bricklink.com/catalogList.asp?pg=1&colorInSet=65&sortBy=P&sortAsc=A&catType=S&v=2

Ok, but help me out here! If I go with your set-up Order Up the first searches
has none in that color, if I change it to Order Down 10316 Rivendell is the first
and it has two parts in that color. So please help me out more to understand!

Maybe it's correct there are 2.
I tried randomly a few sets inventories, and there's no more than 2 parts
in Metallic Gold in all those Sets.

It's a rare color; try with White instead?
 Author: M_R View Messages Posted By M_R
 Posted: Dec 22, 2023 15:24
 Subject: Re: Way to find set with most parts in a color?
 Viewed: 30 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

M_R (4594)

Location:  Sweden, Södermanland
Member Since Contact Type Status
Sep 3, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Mike´s BrickVault
In Help, 1001bricks writes:
  In Help, M_R writes:
  In Help, 1001bricks writes:
  In Help, M_R writes:
  So the question is - Is there a search that can show which set has the most parts
in a certain color, for example Metallic Gold?

Regards / Mike

Sure - simply start with the Color guide:
https://www.bricklink.com/catalogColors.asp

Then, sorted part count DESC, for Metallic Gold:
https://www.bricklink.com/catalogList.asp?pg=1&colorInSet=65&sortBy=P&sortAsc=A&catType=S&v=2

Ok, but help me out here! If I go with your set-up Order Up the first searches
has none in that color, if I change it to Order Down 10316 Rivendell is the first
and it has two parts in that color. So please help me out more to understand!

Maybe it's correct there are 2.
I tried randomly a few sets inventories, and there's no more than 2 parts
in Metallic Gold in all those Sets.

It's a rare color; try with White instead?

 
Set No: 76191  Name: Infinity Gauntlet
* 
76191-1 (Inv) Infinity Gauntlet
590 Parts, 2021
Sets: Super Heroes: Sculptures: The Infinity Saga
😉!
 Author: wildchicken13 View Messages Posted By wildchicken13
 Posted: Dec 22, 2023 15:28
 Subject: (Cancelled)
 Viewed: 19 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

wildchicken13 (877)

Location:  USA, Illinois
Member Since Contact Type Status
Aug 11, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Wild Chicken
(Cancelled)