INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10365,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='070501020807'),(select CATENTRY_ID from catentry where PARTNUMBER='070501021750'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10366,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501020807'),(select CATENTRY_ID from catentry where PARTNUMBER='070501026601'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10367,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='070501020906'),(select CATENTRY_ID from catentry where PARTNUMBER='381371010288'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10368,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='070501021750'),(select CATENTRY_ID from catentry where PARTNUMBER='070501026601'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10369,'X-SELL',0,(select CATENTRY_ID from catentry where PARTNUMBER='070501021750'),(select CATENTRY_ID from catentry where PARTNUMBER='070501020807'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10370,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501026601'),(select CATENTRY_ID from catentry where PARTNUMBER='070501021750'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10371,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501026601'),(select CATENTRY_ID from catentry where PARTNUMBER='070501020807'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10372,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501026403'),(select CATENTRY_ID from catentry where PARTNUMBER='070501021751'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10373,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501026403'),(select CATENTRY_ID from catentry where PARTNUMBER='070501026601'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10374,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501026205'),(select CATENTRY_ID from catentry where PARTNUMBER='381371014132'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10375,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501026304'),(select CATENTRY_ID from catentry where PARTNUMBER='070501027301'),'COMES_WITH',1,10551); INSERT INTO massoccece (MASSOCCECE_ID,MASSOCTYPE_ID,RANK,CATENTRY_ID_FROM,CATENTRY_ID_TO,MASSOC_ID,QUANTITY,STORE_ID) VALUES (10376,'X-SELL',1,(select CATENTRY_ID from catentry where PARTNUMBER='070501027301'),(select CATENTRY_ID from catentry where PARTNUMBER='070501026304'),'COMES_WITH',1,10551);