# Проверочный запрос
SELECT spa.ID
     , spa2.ID
     , spa.avalaible
     , spa2.avalaible
     , IF(spa.avalaible <=> spa2.avalaible, 'Количество равно', 'Количество не равно')
FROM yii_doc.supplier_price_avalaible spa
LEFT JOIN yii_doc.supplier_price_avalaible spa2 ON spa2.hash = spa.hash
    AND spa2.storage_id = spa.storage_id
WHERE spa.storage_id = 53
    AND spa.hash IN (
        '00000084234HOCO24'
        ,'0242229699BOSCH24'
        ,'0252096117PDMEYLE24'
        ,'03110SOFT9924'
        ,'0450902161BOSCH24'
        ,'0450906508BOSCH24'
        ,'0451103276BOSCH24'
        ,'08466FEBI24'
        ,'087601REMSA24'
        ,'0882380112TOYOTA24'
        ,'0986357208BOSCH24'
        ,'0986495212BOSCH24'
        ,'1001150000MEYLE24'
        ,'1004120000MEYLE24'
        ,'1004980012MEYLE24'
        ,'101981JESTIC24'
        ,'1140401500JPGROUP24'
        ,'1227735STARLINE24'
        ,'1263700410JPGROUP24'
        ,'1457429194BOSCH24'
        ,'1457433969BOSCH24'
        ,'1457437003BOSCH24'
        ,'17635FEBI24'
        ,'1987429405BOSCH24'
        ,'1987432357BOSCH24'
        ,'21096FEBI24'
        ,'2262NGK24'
        ,'2306010SASIC24'
        ,'2825ULT02BOSRAM24'
        ,'4005278SASIC24'
        ,'414619PCORTECO24'
        ,'48871FEBI24'
        ,'530008910INA24'
        ,'601004384FUCHS24'
        ,'63563SIDEM24'
        ,'6421001BOSRAM24'
        ,'7044NGK24'
        ,'711305800REINZ24'
        ,'811753950REINZ24'
        ,'910059KAYABA24'
        ,'915400KAYABA24'
        ,'915708KAYABA24'
        ,'96463NGK24'
        ,'A1160PURFLUX24'
        ,'A1232PURFLUX24'
        ,'A1297PURFLUX24'
        ,'ADG02593BLUEPRINT24'
        ,'AGW051MTMAGNUMTECHNOLOGY24'
        ,'AGX061MTMAGNUMTECHNOLOGY24'
        ,'B25061PRJCPREMIUM24'
        ,'B42013CPRJCPREMIUM24'
        ,'B4G020CPRJCPREMIUM24'
        ,'C1A018ABEABE24'
        ,'C1A024ABEABE24'
        ,'C1W001ABEABE24'
        ,'C515PURFLUX24'
        ,'CEM14CTR24'
        ,'CT874CONTITECH24'
        ,'E998LCHENGSTFILTER24'
        ,'F026400182BOSCH24'
        ,'F026400376BOSCH24'
        ,'F026407073BOSCH24'
        ,'FCS752PURFLUX24'
        ,'GENESISARMORTECH5W404LLUKOIL24'
        ,'GML4LCOMMA24'
        ,'ITV16TTDENSO24'
        ,'JAR1030TRW24'
        ,'JAR971TRW24'
        ,'JTS370TRW24'
        ,'L460PURFLUX24'
        ,'LP1672DELPHI24'
        ,'LX1631MAHLE24'
        ,'M110376DENCKERMANN24'
        ,'M110532KDENCKERMANN24'
        ,'MZ320723MITSUBISHI24'
        ,'OC5933MAHLE24'
        ,'OC606MAHLE24'
        ,'P24061BREMBO24'
        ,'P54030BREMBO24'
        ,'RA1106RANGER24'
        ,'T738BTESLA24'
        ,'TH143987JCALORSTATBYVERNET24'
        ,'W9050MANN24'
        ,'WL7448WIXFILTERS24'
        ,'XB20178XADO24'
        ,'YT71581YATO24'
    )
    AND spa.ID < spa2.ID;

# Удаление
DELETE spa2.*
FROM yii_doc.supplier_price_avalaible spa
LEFT JOIN yii_doc.supplier_price_avalaible spa2 ON spa2.hash = spa.hash
    AND spa2.storage_id = spa.storage_id
WHERE spa.storage_id = 53
    AND spa.hash IN (
        '00000084234HOCO24'
        ,'0242229699BOSCH24'
        ,'0252096117PDMEYLE24'
        ,'03110SOFT9924'
        ,'0450902161BOSCH24'
        ,'0450906508BOSCH24'
        ,'0451103276BOSCH24'
        ,'08466FEBI24'
        ,'087601REMSA24'
        ,'0882380112TOYOTA24'
        ,'0986357208BOSCH24'
        ,'0986495212BOSCH24'
        ,'1001150000MEYLE24'
        ,'1004120000MEYLE24'
        ,'1004980012MEYLE24'
        ,'101981JESTIC24'
        ,'1140401500JPGROUP24'
        ,'1227735STARLINE24'
        ,'1263700410JPGROUP24'
        ,'1457429194BOSCH24'
        ,'1457433969BOSCH24'
        ,'1457437003BOSCH24'
        ,'17635FEBI24'
        ,'1987429405BOSCH24'
        ,'1987432357BOSCH24'
        ,'21096FEBI24'
        ,'2262NGK24'
        ,'2306010SASIC24'
        ,'2825ULT02BOSRAM24'
        ,'4005278SASIC24'
        ,'414619PCORTECO24'
        ,'48871FEBI24'
        ,'530008910INA24'
        ,'601004384FUCHS24'
        ,'63563SIDEM24'
        ,'6421001BOSRAM24'
        ,'7044NGK24'
        ,'711305800REINZ24'
        ,'811753950REINZ24'
        ,'910059KAYABA24'
        ,'915400KAYABA24'
        ,'915708KAYABA24'
        ,'96463NGK24'
        ,'A1160PURFLUX24'
        ,'A1232PURFLUX24'
        ,'A1297PURFLUX24'
        ,'ADG02593BLUEPRINT24'
        ,'AGW051MTMAGNUMTECHNOLOGY24'
        ,'AGX061MTMAGNUMTECHNOLOGY24'
        ,'B25061PRJCPREMIUM24'
        ,'B42013CPRJCPREMIUM24'
        ,'B4G020CPRJCPREMIUM24'
        ,'C1A018ABEABE24'
        ,'C1A024ABEABE24'
        ,'C1W001ABEABE24'
        ,'C515PURFLUX24'
        ,'CEM14CTR24'
        ,'CT874CONTITECH24'
        ,'E998LCHENGSTFILTER24'
        ,'F026400182BOSCH24'
        ,'F026400376BOSCH24'
        ,'F026407073BOSCH24'
        ,'FCS752PURFLUX24'
        ,'GENESISARMORTECH5W404LLUKOIL24'
        ,'GML4LCOMMA24'
        ,'ITV16TTDENSO24'
        ,'JAR1030TRW24'
        ,'JAR971TRW24'
        ,'JTS370TRW24'
        ,'L460PURFLUX24'
        ,'LP1672DELPHI24'
        ,'LX1631MAHLE24'
        ,'M110376DENCKERMANN24'
        ,'M110532KDENCKERMANN24'
        ,'MZ320723MITSUBISHI24'
        ,'OC5933MAHLE24'
        ,'OC606MAHLE24'
        ,'P24061BREMBO24'
        ,'P54030BREMBO24'
        ,'RA1106RANGER24'
        ,'T738BTESLA24'
        ,'TH143987JCALORSTATBYVERNET24'
        ,'W9050MANN24'
        ,'WL7448WIXFILTERS24'
        ,'XB20178XADO24'
        ,'YT71581YATO24'
    )
    AND spa.ID < spa2.ID;