Postgres 9.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

create table items(
    item_id integer primary key,
    item_name varchar(250));                      
create table items_properties(
    item_property_id serial primary key,
    item_id integer,
    property_name varchar(250));                      
create table items_properties_values(
    item_property_value_id serial primary key,
    item_property_id integer,
    property_value varchar(250));
    
CREATE INDEX items_index ON items (item_id, item_name); 
CREATE INDEX properties_index ON items_properties (item_property_id, item_id, property_name);
CREATE INDEX values_index ON items_properties_values (item_property_value_id, item_property_id, property_value);

--insert dummy data
insert into items                        
SELECT generate_series(1,5000), md5(random()::text);    -- only 5k for demo !!

insert into items_properties (item_id,property_name)
SELECT item_id,md5(random()::text) from items, generate_series(1,3);

insert into items_properties_values (item_property_id,property_value)
select item_property_id, md5(random()::text) from items_properties, generate_series(1,2);

INSERT 0 30000


with cte_items as (
   select item_id,item_name from items  
   where item_id between 1000 and 1010
),cte_properties as (
   select ip.item_id,ip.item_property_id,ip.property_name
   from items_properties ip
   join cte_items i on i.item_id=ip.item_id
),cte_values as (
   select ipv.item_property_value_id,ipv.item_property_id,ipv.property_value
   from items_properties_values ipv
   join cte_properties p on ipv.item_property_id=p.item_property_id
)
select i.item_id,i.item_name,json_agg(json_build_object('item_property_id',prop.item_property_id,'property_name',prop.property_name,'values',prop.values))
from cte_items i
left join (
   select cp.item_id,cp.item_property_id,cp.property_name,json_agg(to_json(cv.property_value)) "values"
   from cte_properties cp
   left join ( select val.item_property_id,val.property_value
   from cte_values val) cv on cv.item_property_id=cp.item_property_id
   group by cp.item_id,cp.item_property_id,cp.property_name
) prop
on i.item_id=prop.item_id
group by i.item_id,i.item_name
ORDER BY 1;


item_id
item_name
json_agg


1000
ee2fe227e12655f44b66aceb5f3921b9
[{"item_property_id" : 11000, "property_name" : "436d8e69e44b1f5e79cc40f22aba32a8", "values" : ["933a21baebca5dcaba305a0e0f6904b5", "3747526dc87f33afa833f15126a2d231"]}, {"item_property_id" : 6000, "property_name" : "435b549012e46ae846fd1f7e0b937bdf", "values" : ["207d553a4deb9d70ac0ea3e5d879e46e", "8c60b13cd27fb4e1b10f57b30c889edb"]}, {"item_property_id" : 1000, "property_name" : "2f22ef9fabd52dd7e7ccb086a3db8387", "values" : ["ac0c73646a11ea9248a52b2a8bb59367", "744f596e97585711d9bd03771f117503"]}]

1001
b5025a155f4d3ce68984098988be6ed2
[{"item_property_id" : 11001, "property_name" : "40faaafaef1d4f35b7d5a58343608ab1", "values" : ["256d1afabfd00e25879bf491508d0917", "878d550e066de74bf6fe47b248d9e5f7"]}, {"item_property_id" : 6001, "property_name" : "0fd7c88127356b13f92a389f187b196a", "values" : ["2d667d8f6f609593e2e6114ab87aa784", "0ae9a6f43fe74f73ba4887cdcdd7b770"]}, {"item_property_id" : 1001, "property_name" : "c1845647aba1a844991ef10b8b7007e0", "values" : ["70393d6d50987b16d0453ae538ef0a3b", "0d76f29da61bfa88886159e3de0f7e1e"]}]

1002
421f555b7543341065a93e6b1377d8d2
[{"item_property_id" : 6002, "property_name" : "8f7eecf5fe5c37bd1810f9340c58326b", "values" : ["68d0a9a766c1407a5b31c1d2a8f4d2ff", "bbd6d566d86b444ba8c47802faccd9c0"]}, {"item_property_id" : 1002, "property_name" : "2dfe1a0392709fd335bbfc0b94bcba96", "values" : ["19062214738fb1734b4dc244cb7df21d", "76459c82c3f99e2caf9418bf84f4ddda"]}, {"item_property_id" : 11002, "property_name" : "7cd0014231a88088ebdfaaf1b95d7b4c", "values" : ["b4e80643b604f7888aee14bd7c6a6596", "7008956033f87403d86599464301fc2a"]}]

1003
eb88b012666395e14c3dad24b1807644
[{"item_property_id" : 1003, "property_name" : "6bde977d2f699ea622684c5c9722128b", "values" : ["e11f9548d15ba6e416cb0d816e93c7ba", "344a936c188a84e1446c6c3895bc98fb"]}, {"item_property_id" : 6003, "property_name" : "9e637c86d21cdae829126332720414d6", "values" : ["8c74c86f8cc639b947c0e1b371f19d2d", "eeb1c122ed53a037dde0c293798c6193"]}, {"item_property_id" : 11003, "property_name" : "c3aaeef31c79d47e912b074aa9dcb63d", "values" : ["5fe46e3aedbcb3e442b7a9166fcb90b8", "d26d4da73f033426572db41e56af2cbf"]}]

1004
ec129fea4f7e6185f02fe9167038f21c
[{"item_property_id" : 6004, "property_name" : "4aef8f3ad11784c0bc86ca4ef08e5b30", "values" : ["390106f4217ed2b365b3548bf8bc5966", "e7f7b625f3cdc632da3f09519853cdbe"]}, {"item_property_id" : 11004, "property_name" : "57c38c1dee214cd5d2a020ecf38661fc", "values" : ["50775acadd9b1d5154d22c2b7b3da674", "618b62a075ac4eea7f0d5f0887bb8658"]}, {"item_property_id" : 1004, "property_name" : "5ebaa93167d8b44077571b1dd002f3d9", "values" : ["e7464b14c3908a799e9afaadc1476cfe", "606dd9d54968738c291381b451bd60e4"]}]

1005
16e0743e1ddf64a95edd04031fb27ef3
[{"item_property_id" : 11005, "property_name" : "8e082ce0e851e51a5d2f39999ed6c69c", "values" : ["707f6540cd3832f90e8ac0092d59c154", "10b1d0e25b852560de321eed8d066e97"]}, {"item_property_id" : 1005, "property_name" : "acda0d76667974605c20390eaff68909", "values" : ["ba0f51cc8361f70503f4c799a8f79776", "ca964e1743b300624a796d57a553f869"]}, {"item_property_id" : 6005, "property_name" : "95443ea5b2d9bdeb3146e4512fc2292b", "values" : ["40fea5bd3e928f8e8031650f77cc98f3", "2e3cbbc8698754f2c8f309d1528963ba"]}]

1006
8ce04865d06239e32cc281f31c25f567
[{"item_property_id" : 1006, "property_name" : "57e56c0e007db77eba04d96b14dd4eb0", "values" : ["a7b4ca88118ab14a7d1e9555e1c55f57", "c4897e17886b807238e4f85ecbcbdf9d"]}, {"item_property_id" : 6006, "property_name" : "e09ca0cb4b677a8e42d58a3e427d2972", "values" : ["df1423e74d6ed45b5e51be433c9798d0", "f8637bf744d983a4a639dc33222bfd50"]}, {"item_property_id" : 11006, "property_name" : "970edc03b5fe37726ef860cc8e7ca39a", "values" : ["e589d78310dc11adcc1751d8948f5f6e", "12318ac0f089a4d5ce07e1a322fddd76"]}]

1007
2aff50b4c644ed9413476b5c23c067df
[{"item_property_id" : 1007, "property_name" : "5cc8a8c8a75bc9f454698ee9e343fcd8", "values" : ["b8053e1dd12df613e88169978804ddc3", "19f663bbe9e398b23d8503419833c1d0"]}, {"item_property_id" : 6007, "property_name" : "56c7da039aab77b439477bcb3d59688a", "values" : ["4d91de50f0413ce5e584a01fb40bdac6", "2cd287899a6e1f8e48a510620c370724"]}, {"item_property_id" : 11007, "property_name" : "188452fa9010834a92f0a21146fbb2af", "values" : ["433847b3bdbe6a9360b8ba1247d2fe98", "bc3319d59697a0a28d526d0cbb9b5483"]}]

1008
666c4e9b13fa96795f0c9a169bdee520
[{"item_property_id" : 11008, "property_name" : "ec8d8123c0377b42635c8b51caabf5e9", "values" : ["9f500e7998267709c78353f06aa68315", "591ca6718ca764d18216f57e8858f089"]}, {"item_property_id" : 1008, "property_name" : "cce4582f05d32182099ff4380058a42e", "values" : ["7fd3dbc76a2eeb013d03d6caacc1a210", "0c721901dec3ba1dac9c8f1798055ed6"]}, {"item_property_id" : 6008, "property_name" : "83cc2e2c28a82b94cb1a7ca8e21d4604", "values" : ["c3c6002abf488082b8bc984091963003", "fb712c877110e04a45f87f4c8aa6cca3"]}]

1009
fda3cffefed31c4572122a663329894e
[{"item_property_id" : 1009, "property_name" : "7ad87eb0fa2364783a48527c52514369", "values" : ["0ff0c921e7d1a28dd57df9fa158673fc", "1a3525898159395207c2bdfb80fadcf6"]}, {"item_property_id" : 6009, "property_name" : "a17ef0a53244dd62fce1de5cb22665e3", "values" : ["09aed95263b36ad6dd0a1c161ab84601", "cc7ba4d1d3a266fe8c7a03180af94510"]}, {"item_property_id" : 11009, "property_name" : "480ed18b3a7c7a8fecf4e526b5f2cf05", "values" : ["753d5e61462d584e5984a4663660d814", "2eafaeb80ae71d7b405aa6de6515acb8"]}]

1010
a7d9653993577ea53001cf8835d4f20e
[{"item_property_id" : 1010, "property_name" : "28e06c65a77979eb5a13fe47666fdd4b", "values" : ["af1406084446d4c2bc4945fbf21fd0bf", "c751bac93e1b1a6b0a202bf1c0a53393"]}, {"item_property_id" : 6010, "property_name" : "489597a447606fb78097d713b5f4de63", "values" : ["342790d78fcbcad8be77af2689af528b", "153fd29d8b09931ca82da9b2a31845da"]}, {"item_property_id" : 11010, "property_name" : "2d10faf9808d1f319b295222c2b3f006", "values" : ["52046cfddc8fea3d5a2d93bbe3f8f43f", "c7ed997317901f92367aa74c40569945"]}]



SELECT 11


SELECT i.item_id, i.item_name, js
FROM   items i
LEFT   JOIN (
   SELECT item_id, json_agg(json_build_object('item_property_id',item_property_id,'property_name',property_name,'values',values)) AS js
   FROM   items_properties
   LEFT   JOIN (
      SELECT item_property_id, json_agg(property_value) AS values
      FROM   items_properties_values
      GROUP  BY 1
      ) ipv USING (item_property_id)
   GROUP  BY 1
   ) ip USING (item_id)
WHERE  item_id BETWEEN 1000 AND 1010
ORDER  BY 1;


item_id
item_name
js


1000
ee2fe227e12655f44b66aceb5f3921b9
[{"item_property_id" : 6000, "property_name" : "435b549012e46ae846fd1f7e0b937bdf", "values" : ["207d553a4deb9d70ac0ea3e5d879e46e", "8c60b13cd27fb4e1b10f57b30c889edb"]}, {"item_property_id" : 11000, "property_name" : "436d8e69e44b1f5e79cc40f22aba32a8", "values" : ["933a21baebca5dcaba305a0e0f6904b5", "3747526dc87f33afa833f15126a2d231"]}, {"item_property_id" : 1000, "property_name" : "2f22ef9fabd52dd7e7ccb086a3db8387", "values" : ["ac0c73646a11ea9248a52b2a8bb59367", "744f596e97585711d9bd03771f117503"]}]

1001
b5025a155f4d3ce68984098988be6ed2
[{"item_property_id" : 1001, "property_name" : "c1845647aba1a844991ef10b8b7007e0", "values" : ["70393d6d50987b16d0453ae538ef0a3b", "0d76f29da61bfa88886159e3de0f7e1e"]}, {"item_property_id" : 6001, "property_name" : "0fd7c88127356b13f92a389f187b196a", "values" : ["2d667d8f6f609593e2e6114ab87aa784", "0ae9a6f43fe74f73ba4887cdcdd7b770"]}, {"item_property_id" : 11001, "property_name" : "40faaafaef1d4f35b7d5a58343608ab1", "values" : ["256d1afabfd00e25879bf491508d0917", "878d550e066de74bf6fe47b248d9e5f7"]}]

1002
421f555b7543341065a93e6b1377d8d2
[{"item_property_id" : 1002, "property_name" : "2dfe1a0392709fd335bbfc0b94bcba96", "values" : ["19062214738fb1734b4dc244cb7df21d", "76459c82c3f99e2caf9418bf84f4ddda"]}, {"item_property_id" : 11002, "property_name" : "7cd0014231a88088ebdfaaf1b95d7b4c", "values" : ["b4e80643b604f7888aee14bd7c6a6596", "7008956033f87403d86599464301fc2a"]}, {"item_property_id" : 6002, "property_name" : "8f7eecf5fe5c37bd1810f9340c58326b", "values" : ["68d0a9a766c1407a5b31c1d2a8f4d2ff", "bbd6d566d86b444ba8c47802faccd9c0"]}]

1003
eb88b012666395e14c3dad24b1807644
[{"item_property_id" : 1003, "property_name" : "6bde977d2f699ea622684c5c9722128b", "values" : ["e11f9548d15ba6e416cb0d816e93c7ba", "344a936c188a84e1446c6c3895bc98fb"]}, {"item_property_id" : 11003, "property_name" : "c3aaeef31c79d47e912b074aa9dcb63d", "values" : ["5fe46e3aedbcb3e442b7a9166fcb90b8", "d26d4da73f033426572db41e56af2cbf"]}, {"item_property_id" : 6003, "property_name" : "9e637c86d21cdae829126332720414d6", "values" : ["8c74c86f8cc639b947c0e1b371f19d2d", "eeb1c122ed53a037dde0c293798c6193"]}]

1004
ec129fea4f7e6185f02fe9167038f21c
[{"item_property_id" : 1004, "property_name" : "5ebaa93167d8b44077571b1dd002f3d9", "values" : ["e7464b14c3908a799e9afaadc1476cfe", "606dd9d54968738c291381b451bd60e4"]}, {"item_property_id" : 11004, "property_name" : "57c38c1dee214cd5d2a020ecf38661fc", "values" : ["50775acadd9b1d5154d22c2b7b3da674", "618b62a075ac4eea7f0d5f0887bb8658"]}, {"item_property_id" : 6004, "property_name" : "4aef8f3ad11784c0bc86ca4ef08e5b30", "values" : ["390106f4217ed2b365b3548bf8bc5966", "e7f7b625f3cdc632da3f09519853cdbe"]}]

1005
16e0743e1ddf64a95edd04031fb27ef3
[{"item_property_id" : 11005, "property_name" : "8e082ce0e851e51a5d2f39999ed6c69c", "values" : ["707f6540cd3832f90e8ac0092d59c154", "10b1d0e25b852560de321eed8d066e97"]}, {"item_property_id" : 1005, "property_name" : "acda0d76667974605c20390eaff68909", "values" : ["ba0f51cc8361f70503f4c799a8f79776", "ca964e1743b300624a796d57a553f869"]}, {"item_property_id" : 6005, "property_name" : "95443ea5b2d9bdeb3146e4512fc2292b", "values" : ["40fea5bd3e928f8e8031650f77cc98f3", "2e3cbbc8698754f2c8f309d1528963ba"]}]

1006
8ce04865d06239e32cc281f31c25f567
[{"item_property_id" : 11006, "property_name" : "970edc03b5fe37726ef860cc8e7ca39a", "values" : ["e589d78310dc11adcc1751d8948f5f6e", "12318ac0f089a4d5ce07e1a322fddd76"]}, {"item_property_id" : 6006, "property_name" : "e09ca0cb4b677a8e42d58a3e427d2972", "values" : ["df1423e74d6ed45b5e51be433c9798d0", "f8637bf744d983a4a639dc33222bfd50"]}, {"item_property_id" : 1006, "property_name" : "57e56c0e007db77eba04d96b14dd4eb0", "values" : ["a7b4ca88118ab14a7d1e9555e1c55f57", "c4897e17886b807238e4f85ecbcbdf9d"]}]

1007
2aff50b4c644ed9413476b5c23c067df
[{"item_property_id" : 1007, "property_name" : "5cc8a8c8a75bc9f454698ee9e343fcd8", "values" : ["b8053e1dd12df613e88169978804ddc3", "19f663bbe9e398b23d8503419833c1d0"]}, {"item_property_id" : 6007, "property_name" : "56c7da039aab77b439477bcb3d59688a", "values" : ["4d91de50f0413ce5e584a01fb40bdac6", "2cd287899a6e1f8e48a510620c370724"]}, {"item_property_id" : 11007, "property_name" : "188452fa9010834a92f0a21146fbb2af", "values" : ["433847b3bdbe6a9360b8ba1247d2fe98", "bc3319d59697a0a28d526d0cbb9b5483"]}]

1008
666c4e9b13fa96795f0c9a169bdee520
[{"item_property_id" : 1008, "property_name" : "cce4582f05d32182099ff4380058a42e", "values" : ["7fd3dbc76a2eeb013d03d6caacc1a210", "0c721901dec3ba1dac9c8f1798055ed6"]}, {"item_property_id" : 11008, "property_name" : "ec8d8123c0377b42635c8b51caabf5e9", "values" : ["9f500e7998267709c78353f06aa68315", "591ca6718ca764d18216f57e8858f089"]}, {"item_property_id" : 6008, "property_name" : "83cc2e2c28a82b94cb1a7ca8e21d4604", "values" : ["c3c6002abf488082b8bc984091963003", "fb712c877110e04a45f87f4c8aa6cca3"]}]

1009
fda3cffefed31c4572122a663329894e
[{"item_property_id" : 11009, "property_name" : "480ed18b3a7c7a8fecf4e526b5f2cf05", "values" : ["753d5e61462d584e5984a4663660d814", "2eafaeb80ae71d7b405aa6de6515acb8"]}, {"item_property_id" : 1009, "property_name" : "7ad87eb0fa2364783a48527c52514369", "values" : ["0ff0c921e7d1a28dd57df9fa158673fc", "1a3525898159395207c2bdfb80fadcf6"]}, {"item_property_id" : 6009, "property_name" : "a17ef0a53244dd62fce1de5cb22665e3", "values" : ["09aed95263b36ad6dd0a1c161ab84601", "cc7ba4d1d3a266fe8c7a03180af94510"]}]

1010
a7d9653993577ea53001cf8835d4f20e
[{"item_property_id" : 6010, "property_name" : "489597a447606fb78097d713b5f4de63", "values" : ["342790d78fcbcad8be77af2689af528b", "153fd29d8b09931ca82da9b2a31845da"]}, {"item_property_id" : 1010, "property_name" : "28e06c65a77979eb5a13fe47666fdd4b", "values" : ["af1406084446d4c2bc4945fbf21fd0bf", "c751bac93e1b1a6b0a202bf1c0a53393"]}, {"item_property_id" : 11010, "property_name" : "2d10faf9808d1f319b295222c2b3f006", "values" : ["52046cfddc8fea3d5a2d93bbe3f8f43f", "c7ed997317901f92367aa74c40569945"]}]



SELECT 11

item_id	item_name	json_agg
1000	ee2fe227e12655f44b66aceb5f3921b9	[{"item_property_id" : 11000, "property_name" : "436d8e69e44b1f5e79cc40f22aba32a8", "values" : ["933a21baebca5dcaba305a0e0f6904b5", "3747526dc87f33afa833f15126a2d231"]}, {"item_property_id" : 6000, "property_name" : "435b549012e46ae846fd1f7e0b937bdf", "values" : ["207d553a4deb9d70ac0ea3e5d879e46e", "8c60b13cd27fb4e1b10f57b30c889edb"]}, {"item_property_id" : 1000, "property_name" : "2f22ef9fabd52dd7e7ccb086a3db8387", "values" : ["ac0c73646a11ea9248a52b2a8bb59367", "744f596e97585711d9bd03771f117503"]}]
1001	b5025a155f4d3ce68984098988be6ed2	[{"item_property_id" : 11001, "property_name" : "40faaafaef1d4f35b7d5a58343608ab1", "values" : ["256d1afabfd00e25879bf491508d0917", "878d550e066de74bf6fe47b248d9e5f7"]}, {"item_property_id" : 6001, "property_name" : "0fd7c88127356b13f92a389f187b196a", "values" : ["2d667d8f6f609593e2e6114ab87aa784", "0ae9a6f43fe74f73ba4887cdcdd7b770"]}, {"item_property_id" : 1001, "property_name" : "c1845647aba1a844991ef10b8b7007e0", "values" : ["70393d6d50987b16d0453ae538ef0a3b", "0d76f29da61bfa88886159e3de0f7e1e"]}]
1002	421f555b7543341065a93e6b1377d8d2	[{"item_property_id" : 6002, "property_name" : "8f7eecf5fe5c37bd1810f9340c58326b", "values" : ["68d0a9a766c1407a5b31c1d2a8f4d2ff", "bbd6d566d86b444ba8c47802faccd9c0"]}, {"item_property_id" : 1002, "property_name" : "2dfe1a0392709fd335bbfc0b94bcba96", "values" : ["19062214738fb1734b4dc244cb7df21d", "76459c82c3f99e2caf9418bf84f4ddda"]}, {"item_property_id" : 11002, "property_name" : "7cd0014231a88088ebdfaaf1b95d7b4c", "values" : ["b4e80643b604f7888aee14bd7c6a6596", "7008956033f87403d86599464301fc2a"]}]
1003	eb88b012666395e14c3dad24b1807644	[{"item_property_id" : 1003, "property_name" : "6bde977d2f699ea622684c5c9722128b", "values" : ["e11f9548d15ba6e416cb0d816e93c7ba", "344a936c188a84e1446c6c3895bc98fb"]}, {"item_property_id" : 6003, "property_name" : "9e637c86d21cdae829126332720414d6", "values" : ["8c74c86f8cc639b947c0e1b371f19d2d", "eeb1c122ed53a037dde0c293798c6193"]}, {"item_property_id" : 11003, "property_name" : "c3aaeef31c79d47e912b074aa9dcb63d", "values" : ["5fe46e3aedbcb3e442b7a9166fcb90b8", "d26d4da73f033426572db41e56af2cbf"]}]
1004	ec129fea4f7e6185f02fe9167038f21c	[{"item_property_id" : 6004, "property_name" : "4aef8f3ad11784c0bc86ca4ef08e5b30", "values" : ["390106f4217ed2b365b3548bf8bc5966", "e7f7b625f3cdc632da3f09519853cdbe"]}, {"item_property_id" : 11004, "property_name" : "57c38c1dee214cd5d2a020ecf38661fc", "values" : ["50775acadd9b1d5154d22c2b7b3da674", "618b62a075ac4eea7f0d5f0887bb8658"]}, {"item_property_id" : 1004, "property_name" : "5ebaa93167d8b44077571b1dd002f3d9", "values" : ["e7464b14c3908a799e9afaadc1476cfe", "606dd9d54968738c291381b451bd60e4"]}]
1005	16e0743e1ddf64a95edd04031fb27ef3	[{"item_property_id" : 11005, "property_name" : "8e082ce0e851e51a5d2f39999ed6c69c", "values" : ["707f6540cd3832f90e8ac0092d59c154", "10b1d0e25b852560de321eed8d066e97"]}, {"item_property_id" : 1005, "property_name" : "acda0d76667974605c20390eaff68909", "values" : ["ba0f51cc8361f70503f4c799a8f79776", "ca964e1743b300624a796d57a553f869"]}, {"item_property_id" : 6005, "property_name" : "95443ea5b2d9bdeb3146e4512fc2292b", "values" : ["40fea5bd3e928f8e8031650f77cc98f3", "2e3cbbc8698754f2c8f309d1528963ba"]}]
1006	8ce04865d06239e32cc281f31c25f567	[{"item_property_id" : 1006, "property_name" : "57e56c0e007db77eba04d96b14dd4eb0", "values" : ["a7b4ca88118ab14a7d1e9555e1c55f57", "c4897e17886b807238e4f85ecbcbdf9d"]}, {"item_property_id" : 6006, "property_name" : "e09ca0cb4b677a8e42d58a3e427d2972", "values" : ["df1423e74d6ed45b5e51be433c9798d0", "f8637bf744d983a4a639dc33222bfd50"]}, {"item_property_id" : 11006, "property_name" : "970edc03b5fe37726ef860cc8e7ca39a", "values" : ["e589d78310dc11adcc1751d8948f5f6e", "12318ac0f089a4d5ce07e1a322fddd76"]}]
1007	2aff50b4c644ed9413476b5c23c067df	[{"item_property_id" : 1007, "property_name" : "5cc8a8c8a75bc9f454698ee9e343fcd8", "values" : ["b8053e1dd12df613e88169978804ddc3", "19f663bbe9e398b23d8503419833c1d0"]}, {"item_property_id" : 6007, "property_name" : "56c7da039aab77b439477bcb3d59688a", "values" : ["4d91de50f0413ce5e584a01fb40bdac6", "2cd287899a6e1f8e48a510620c370724"]}, {"item_property_id" : 11007, "property_name" : "188452fa9010834a92f0a21146fbb2af", "values" : ["433847b3bdbe6a9360b8ba1247d2fe98", "bc3319d59697a0a28d526d0cbb9b5483"]}]
1008	666c4e9b13fa96795f0c9a169bdee520	[{"item_property_id" : 11008, "property_name" : "ec8d8123c0377b42635c8b51caabf5e9", "values" : ["9f500e7998267709c78353f06aa68315", "591ca6718ca764d18216f57e8858f089"]}, {"item_property_id" : 1008, "property_name" : "cce4582f05d32182099ff4380058a42e", "values" : ["7fd3dbc76a2eeb013d03d6caacc1a210", "0c721901dec3ba1dac9c8f1798055ed6"]}, {"item_property_id" : 6008, "property_name" : "83cc2e2c28a82b94cb1a7ca8e21d4604", "values" : ["c3c6002abf488082b8bc984091963003", "fb712c877110e04a45f87f4c8aa6cca3"]}]
1009	fda3cffefed31c4572122a663329894e	[{"item_property_id" : 1009, "property_name" : "7ad87eb0fa2364783a48527c52514369", "values" : ["0ff0c921e7d1a28dd57df9fa158673fc", "1a3525898159395207c2bdfb80fadcf6"]}, {"item_property_id" : 6009, "property_name" : "a17ef0a53244dd62fce1de5cb22665e3", "values" : ["09aed95263b36ad6dd0a1c161ab84601", "cc7ba4d1d3a266fe8c7a03180af94510"]}, {"item_property_id" : 11009, "property_name" : "480ed18b3a7c7a8fecf4e526b5f2cf05", "values" : ["753d5e61462d584e5984a4663660d814", "2eafaeb80ae71d7b405aa6de6515acb8"]}]
1010	a7d9653993577ea53001cf8835d4f20e	[{"item_property_id" : 1010, "property_name" : "28e06c65a77979eb5a13fe47666fdd4b", "values" : ["af1406084446d4c2bc4945fbf21fd0bf", "c751bac93e1b1a6b0a202bf1c0a53393"]}, {"item_property_id" : 6010, "property_name" : "489597a447606fb78097d713b5f4de63", "values" : ["342790d78fcbcad8be77af2689af528b", "153fd29d8b09931ca82da9b2a31845da"]}, {"item_property_id" : 11010, "property_name" : "2d10faf9808d1f319b295222c2b3f006", "values" : ["52046cfddc8fea3d5a2d93bbe3f8f43f", "c7ed997317901f92367aa74c40569945"]}]

item_id	item_name	js
1000	ee2fe227e12655f44b66aceb5f3921b9	[{"item_property_id" : 6000, "property_name" : "435b549012e46ae846fd1f7e0b937bdf", "values" : ["207d553a4deb9d70ac0ea3e5d879e46e", "8c60b13cd27fb4e1b10f57b30c889edb"]}, {"item_property_id" : 11000, "property_name" : "436d8e69e44b1f5e79cc40f22aba32a8", "values" : ["933a21baebca5dcaba305a0e0f6904b5", "3747526dc87f33afa833f15126a2d231"]}, {"item_property_id" : 1000, "property_name" : "2f22ef9fabd52dd7e7ccb086a3db8387", "values" : ["ac0c73646a11ea9248a52b2a8bb59367", "744f596e97585711d9bd03771f117503"]}]
1001	b5025a155f4d3ce68984098988be6ed2	[{"item_property_id" : 1001, "property_name" : "c1845647aba1a844991ef10b8b7007e0", "values" : ["70393d6d50987b16d0453ae538ef0a3b", "0d76f29da61bfa88886159e3de0f7e1e"]}, {"item_property_id" : 6001, "property_name" : "0fd7c88127356b13f92a389f187b196a", "values" : ["2d667d8f6f609593e2e6114ab87aa784", "0ae9a6f43fe74f73ba4887cdcdd7b770"]}, {"item_property_id" : 11001, "property_name" : "40faaafaef1d4f35b7d5a58343608ab1", "values" : ["256d1afabfd00e25879bf491508d0917", "878d550e066de74bf6fe47b248d9e5f7"]}]
1002	421f555b7543341065a93e6b1377d8d2	[{"item_property_id" : 1002, "property_name" : "2dfe1a0392709fd335bbfc0b94bcba96", "values" : ["19062214738fb1734b4dc244cb7df21d", "76459c82c3f99e2caf9418bf84f4ddda"]}, {"item_property_id" : 11002, "property_name" : "7cd0014231a88088ebdfaaf1b95d7b4c", "values" : ["b4e80643b604f7888aee14bd7c6a6596", "7008956033f87403d86599464301fc2a"]}, {"item_property_id" : 6002, "property_name" : "8f7eecf5fe5c37bd1810f9340c58326b", "values" : ["68d0a9a766c1407a5b31c1d2a8f4d2ff", "bbd6d566d86b444ba8c47802faccd9c0"]}]
1003	eb88b012666395e14c3dad24b1807644	[{"item_property_id" : 1003, "property_name" : "6bde977d2f699ea622684c5c9722128b", "values" : ["e11f9548d15ba6e416cb0d816e93c7ba", "344a936c188a84e1446c6c3895bc98fb"]}, {"item_property_id" : 11003, "property_name" : "c3aaeef31c79d47e912b074aa9dcb63d", "values" : ["5fe46e3aedbcb3e442b7a9166fcb90b8", "d26d4da73f033426572db41e56af2cbf"]}, {"item_property_id" : 6003, "property_name" : "9e637c86d21cdae829126332720414d6", "values" : ["8c74c86f8cc639b947c0e1b371f19d2d", "eeb1c122ed53a037dde0c293798c6193"]}]
1004	ec129fea4f7e6185f02fe9167038f21c	[{"item_property_id" : 1004, "property_name" : "5ebaa93167d8b44077571b1dd002f3d9", "values" : ["e7464b14c3908a799e9afaadc1476cfe", "606dd9d54968738c291381b451bd60e4"]}, {"item_property_id" : 11004, "property_name" : "57c38c1dee214cd5d2a020ecf38661fc", "values" : ["50775acadd9b1d5154d22c2b7b3da674", "618b62a075ac4eea7f0d5f0887bb8658"]}, {"item_property_id" : 6004, "property_name" : "4aef8f3ad11784c0bc86ca4ef08e5b30", "values" : ["390106f4217ed2b365b3548bf8bc5966", "e7f7b625f3cdc632da3f09519853cdbe"]}]
1005	16e0743e1ddf64a95edd04031fb27ef3	[{"item_property_id" : 11005, "property_name" : "8e082ce0e851e51a5d2f39999ed6c69c", "values" : ["707f6540cd3832f90e8ac0092d59c154", "10b1d0e25b852560de321eed8d066e97"]}, {"item_property_id" : 1005, "property_name" : "acda0d76667974605c20390eaff68909", "values" : ["ba0f51cc8361f70503f4c799a8f79776", "ca964e1743b300624a796d57a553f869"]}, {"item_property_id" : 6005, "property_name" : "95443ea5b2d9bdeb3146e4512fc2292b", "values" : ["40fea5bd3e928f8e8031650f77cc98f3", "2e3cbbc8698754f2c8f309d1528963ba"]}]
1006	8ce04865d06239e32cc281f31c25f567	[{"item_property_id" : 11006, "property_name" : "970edc03b5fe37726ef860cc8e7ca39a", "values" : ["e589d78310dc11adcc1751d8948f5f6e", "12318ac0f089a4d5ce07e1a322fddd76"]}, {"item_property_id" : 6006, "property_name" : "e09ca0cb4b677a8e42d58a3e427d2972", "values" : ["df1423e74d6ed45b5e51be433c9798d0", "f8637bf744d983a4a639dc33222bfd50"]}, {"item_property_id" : 1006, "property_name" : "57e56c0e007db77eba04d96b14dd4eb0", "values" : ["a7b4ca88118ab14a7d1e9555e1c55f57", "c4897e17886b807238e4f85ecbcbdf9d"]}]
1007	2aff50b4c644ed9413476b5c23c067df	[{"item_property_id" : 1007, "property_name" : "5cc8a8c8a75bc9f454698ee9e343fcd8", "values" : ["b8053e1dd12df613e88169978804ddc3", "19f663bbe9e398b23d8503419833c1d0"]}, {"item_property_id" : 6007, "property_name" : "56c7da039aab77b439477bcb3d59688a", "values" : ["4d91de50f0413ce5e584a01fb40bdac6", "2cd287899a6e1f8e48a510620c370724"]}, {"item_property_id" : 11007, "property_name" : "188452fa9010834a92f0a21146fbb2af", "values" : ["433847b3bdbe6a9360b8ba1247d2fe98", "bc3319d59697a0a28d526d0cbb9b5483"]}]
1008	666c4e9b13fa96795f0c9a169bdee520	[{"item_property_id" : 1008, "property_name" : "cce4582f05d32182099ff4380058a42e", "values" : ["7fd3dbc76a2eeb013d03d6caacc1a210", "0c721901dec3ba1dac9c8f1798055ed6"]}, {"item_property_id" : 11008, "property_name" : "ec8d8123c0377b42635c8b51caabf5e9", "values" : ["9f500e7998267709c78353f06aa68315", "591ca6718ca764d18216f57e8858f089"]}, {"item_property_id" : 6008, "property_name" : "83cc2e2c28a82b94cb1a7ca8e21d4604", "values" : ["c3c6002abf488082b8bc984091963003", "fb712c877110e04a45f87f4c8aa6cca3"]}]
1009	fda3cffefed31c4572122a663329894e	[{"item_property_id" : 11009, "property_name" : "480ed18b3a7c7a8fecf4e526b5f2cf05", "values" : ["753d5e61462d584e5984a4663660d814", "2eafaeb80ae71d7b405aa6de6515acb8"]}, {"item_property_id" : 1009, "property_name" : "7ad87eb0fa2364783a48527c52514369", "values" : ["0ff0c921e7d1a28dd57df9fa158673fc", "1a3525898159395207c2bdfb80fadcf6"]}, {"item_property_id" : 6009, "property_name" : "a17ef0a53244dd62fce1de5cb22665e3", "values" : ["09aed95263b36ad6dd0a1c161ab84601", "cc7ba4d1d3a266fe8c7a03180af94510"]}]
1010	a7d9653993577ea53001cf8835d4f20e	[{"item_property_id" : 6010, "property_name" : "489597a447606fb78097d713b5f4de63", "values" : ["342790d78fcbcad8be77af2689af528b", "153fd29d8b09931ca82da9b2a31845da"]}, {"item_property_id" : 1010, "property_name" : "28e06c65a77979eb5a13fe47666fdd4b", "values" : ["af1406084446d4c2bc4945fbf21fd0bf", "c751bac93e1b1a6b0a202bf1c0a53393"]}, {"item_property_id" : 11010, "property_name" : "2d10faf9808d1f319b295222c2b3f006", "values" : ["52046cfddc8fea3d5a2d93bbe3f8f43f", "c7ed997317901f92367aa74c40569945"]}]