Answers.Body: <p>I believe that the <code>part_relationships</code> table in the <a href="https://rebrickable.com/downloads/" rel="nofollow noreferrer">Rebrickable database</a> can do this for you.</p>
  <p><a href="https://i.sstatic.net/nhIhQ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/nhIhQ.png" alt="Database diagram" /></a></p>
  <p>The <code>part_relationships</code> table maps parts to other parts. It tracks relationships such as parts that are prints of other parts, parts that are mold variations of one another, and parts that are alternates for one another. I believe that for your use case, you are interested in mold variations. These are indicated by a <code>M</code> in the <code>rel_type</code> field of the <code>part_relationships</code> table.</p>
  <p>You can access the Rebrickable database either using the <a href="https://rebrickable.com/api/" rel="nofollow noreferrer">API</a> or the <a href="https://rebrickable.com/downloads/" rel="nofollow noreferrer">CSV table dumps</a>. If it saves time, I do maintain a set of scripts to <a href="https://github.com/jncraton/rebrickable-sqlite" rel="nofollow noreferrer">build an SQLite database from the CSV dumps</a>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-05T01:37:23.363Z
Answers.LastActivityDate: 2021-01-05T01:37:23.363Z
Answers.UserDisplayName: jncraton
Answers.Body: <p>What you are asking here is to have all possible part numbers for similarly looking elements. However, while both elements could look to be the same for you they may have significantly different properties.</p>
  <p>Both <a href="https://www.bricklink.com/v2/main.page" rel="nofollow noreferrer">Bricklink</a> and <a href="https://rebrickable.com/home/" rel="nofollow noreferrer">Rebrickable</a> have alternative numbers for the same mould, which is the case with the element in first URL. However, last two items are different elements - one has <strong>Thin</strong> support and the other comes with <strong>Thick</strong> support - which is why they are separated. It may be negligible for you, but someone else may find such difference essential.</p>
  <p>Another approach would be to lookup by name - searching for &quot;Arm Mechanical, Exo-Force&quot; results in finding both elements, no matter if it is thin or thick version. Looking up by main properties (mainly size) can give you other, alternative elements as well. A good example here would be &quot;Brick 2 x 4&quot; - there is a classic 2x4 brick as well as some modified ones, that would all work fine when building, say a wall. But classic brick may not work if model utilize special properties of that particular modified version of 2x4 brick.</p>
  <p>If your issue is with building MOCs that you found on Rebricklable you can adjust your building options. You can apply this permanently across the website in your setting page: <strong>Account &gt; Settings &gt; Building Sets/MOCs &gt; Ignore mold variations in parts</strong>.</p>
  <p><a href="https://i.sstatic.net/OXJPM.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/OXJPM.png" alt="enter image description here" /></a></p>
  <p>Or you can apply this setting for particular Set/MOC: <strong>Build this MOC &gt; Change Build Options &gt; Ignore mold variations in parts</strong></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-04T10:03:03.260Z
Answers.Text: Thanks, especially for the Rebricklable hint. As I am doing all the checking on my own computer using python and CSVs, I hope to have a list of all the alternate numbers of all parts that I have. I am thinking whether such a list exists or not, otherwise this is probably more a question of web scraping and python.
Answers.UserDisplayName: Walter
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-01-04T06:23:31.637Z
Answers.LastActivityDate: 2021-01-04T08:26:14.747Z
Answers.LastEditDate: 2021-01-04T08:26:14.747Z
Answers.UserDisplayName: Alex
Body: <p>I am ordering parts for some MOC I found online. As I compare the parts needed against my inventory, I find that I already have some of them but under different part numbers. For example, I have <a href="https://www.bricklink.com/v2/catalog/catalogitem.page?P=30526#T=C" rel="nofollow noreferrer">part 30526 under 53540</a> in my inventory from the sets we have collected. It gets even more complicated for some parts like this one <a href="https://www.bricklink.com/v2/catalog/catalogitem.page?P=98313" rel="nofollow noreferrer">here</a> and <a href="https://www.bricklink.com/v2/catalog/catalogitem.page?P=53989" rel="nofollow noreferrer">here</a>, under five different numbers.</p>
  <p>Is there anyway to retrieve  all the parts with alternate numbers?</p>
  
Tags: <part-database>
Title: Database of parts with alternate numbers
UserDisplayName: Walter
ThreadText: # Database of parts with alternate numbers
  
  (Asked by: username_0 on 2021-01-04)
  
  I am ordering parts for some MOC I found online. As I compare the parts needed against my inventory, I find that I already have some of them but under different part numbers. For example, I have [part 30526 under 53540](https://www.bricklink.com/v2/catalog/catalogitem.page?P=30526#T=C) in my inventory from the sets we have collected. It gets even more complicated for some parts like this one [here](https://www.bricklink.com/v2/catalog/catalogitem.page?P=98313) and [here](https://www.bricklink.com/v2/catalog/catalogitem.page?P=53989), under five different numbers.
  
  Is there anyway to retrieve all the parts with alternate numbers?
  
  **Tags:** part-database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-01-05. Score: 3 | Accepted answer
  
  I believe that the `part_relationships` table in the [Rebrickable database](https://rebrickable.com/downloads/) can do this for you.
  
  [![Database diagram](https://i.sstatic.net/nhIhQ.png)](https://i.sstatic.net/nhIhQ.png)
  
  The `part_relationships` table maps parts to other parts. It tracks relationships such as parts that are prints of other parts, parts that are mold variations of one another, and parts that are alternates for one another. I believe that for your use case, you are interested in mold variations. These are indicated by a `M` in the `rel_type` field of the `part_relationships` table.
  
  You can access the Rebrickable database either using the [API](https://rebrickable.com/api/) or the [CSV table dumps](https://rebrickable.com/downloads/). If it saves time, I do maintain a set of scripts to [build an SQLite database from the CSV dumps](https://github.com/username_1/rebrickable-sqlite).
  
  
  ---
  
  ### Answer by username_2 on 2021-01-04. Score: 3
  
  What you are asking here is to have all possible part numbers for similarly looking elements. However, while both elements could look to be the same for you they may have significantly different properties.
  
  Both [Bricklink](https://www.bricklink.com/v2/main.page) and [Rebrickable](https://rebrickable.com/home/) have alternative numbers for the same mould, which is the case with the element in first URL. However, last two items are different elements - one has **Thin** support and the other comes with **Thick** support - which is why they are separated. It may be negligible for you, but someone else may find such difference essential.
  
  Another approach would be to lookup by name - searching for "Arm Mechanical, Exo-Force" results in finding both elements, no matter if it is thin or thick version. Looking up by main properties (mainly size) can give you other, alternative elements as well. A good example here would be "Brick 2 x 4" - there is a classic 2x4 brick as well as some modified ones, that would all work fine when building, say a wall. But classic brick may not work if model utilize special properties of that particular modified version of 2x4 brick.
  
  If your issue is with building MOCs that you found on Rebricklable you can adjust your building options. You can apply this permanently across the website in your setting page: **Account > Settings > Building Sets/MOCs > Ignore mold variations in parts**.
  
  [![enter image description here](https://i.sstatic.net/OXJPM.png)](https://i.sstatic.net/OXJPM.png)
  
  Or you can apply this setting for particular Set/MOC: **Build this MOC > Change Build Options > Ignore mold variations in parts**
  
  > **Comments:**
  > **username_0**: Thanks, especially for the Rebricklable hint. As I am doing all the checking on my own computer using python and CSVs, I hope to have a list of all the alternate numbers of all parts that I have. I am thinking whether such a list exists or not, otherwise this is probably more a question of web scraping and python.  
  
  ---
  
  