SDC_SampleData

adidas=# SELECT * FROM products where product_id = 2500002;
 product_id | adidas_id | product_name | collection_name | review_count | review_average 
------------+-----------+--------------+-----------------+--------------+----------------
    2500002 | PERF003   | NMD_R1 SHOES | ORIGINALS       |         1023 |           4.12


adidas=# select * from colors where product_id = 2500002;
 color_id | product_id |               color_name                |                          color_url                           | list_price | sale_price 
----------+------------+-----------------------------------------+--------------------------------------------------------------+------------+------------
  9275008 |    2500002 | GLORY BLUE / ORBIT GREY / GOLD METALLIC | https://www.adidas.com/us/matchbreak-super-shoes/EG2727.html |     130.00 |     110.00
  9275009 |    2500002 | CORE BLACK / CLOUD WHITE / CORE BLACK   | https://www.adidas.com/us/superstar-shoes/EG4958.html        |      80.00 |      60.00
  9275010 |    2500002 | CLOUD WHITE / POWER RED / CLOUD WHITE   | https://www.adidas.com/us/nmd_r1-shoes/FV7852.html           |     130.00 |     110.00
  9275011 |    2500002 | CLOUD WHITE / COLLEGIATE GREEN / ORANGE | https://www.adidas.com/us/nmd_r1-shoes/FV7852.html           |     130.00 |     110.00
  9275012 |    2500002 | CLOUD WHITE / COLLEGIATE GREEN / ORANGE | https://www.adidas.com/us/nmd_r1-shoes/FV7852.html           |     130.00 |     110.00
(5 rows)

adidas=# select * from photos where product_id = 2500002;
 photo_id | product_id | color_id |        photo_url        
----------+------------+----------+-------------------------
 55475049 |    2500002 |  9275007 | PERF002_color0_pic0.jpg
 55475050 |    2500002 |  9275007 | PERF002_color0_pic1.jpg
 55475051 |    2500002 |  9275007 | PERF002_color0_pic2.jpg
 55475052 |    2500002 |  9275007 | PERF002_color0_pic3.jpg
 55475053 |    2500002 |  9275007 | PERF002_color0_pic4.jpg
 55475054 |    2500002 |  9275007 | PERF002_color0_pic5.jpg
 55475055 |    2500002 |  9275007 | PERF002_color0_pic6.jpg
 55475056 |    2500002 |  9275008 | PERF002_color1_pic0.jpg
 55475057 |    2500002 |  9275008 | PERF002_color1_pic1.jpg
 55475058 |    2500002 |  9275008 | PERF002_color1_pic2.jpg
 55475059 |    2500002 |  9275008 | PERF002_color1_pic3.jpg
 55475060 |    2500002 |  9275008 | PERF002_color1_pic4.jpg
 55475061 |    2500002 |  9275008 | PERF002_color1_pic5.jpg
 55475062 |    2500002 |  9275009 | PERF002_color2_pic0.jpg
 55475063 |    2500002 |  9275009 | PERF002_color2_pic1.jpg
 55475064 |    2500002 |  9275009 | PERF002_color2_pic2.jpg
 55475065 |    2500002 |  9275009 | PERF002_color2_pic3.jpg
 55475066 |    2500002 |  9275009 | PERF002_color2_pic4.jpg
 55475067 |    2500002 |  9275009 | PERF002_color2_pic5.jpg
 55475068 |    2500002 |  9275010 | PERF002_color3_pic0.jpg
 55475069 |    2500002 |  9275010 | PERF002_color3_pic1.jpg
 55475070 |    2500002 |  9275010 | PERF002_color3_pic2.jpg
 55475071 |    2500002 |  9275010 | PERF002_color3_pic3.jpg
 55475072 |    2500002 |  9275010 | PERF002_color3_pic4.jpg
 55475073 |    2500002 |  9275010 | PERF002_color3_pic5.jpg
 55475074 |    2500002 |  9275010 | PERF002_color3_pic6.jpg
 55475075 |    2500002 |  9275010 | PERF002_color3_pic7.jpg
 55475076 |    2500002 |  9275011 | PERF002_color4_pic0.jpg
 55475077 |    2500002 |  9275011 | PERF002_color4_pic1.jpg
 55475078 |    2500002 |  9275011 | PERF002_color4_pic2.jpg
 55475079 |    2500002 |  9275011 | PERF002_color4_pic3.jpg
 55475080 |    2500002 |  9275011 | PERF002_color4_pic4.jpg
 55475081 |    2500002 |  9275011 | PERF002_color4_pic5.jpg
 55475082 |    2500002 |  9275011 | PERF002_color4_pic6.jpg
 55475083 |    2500002 |  9275011 | PERF002_color4_pic7.jpg
(35 rows)