Sql запрос

[System 20]

не получаеться залить в базу sql запрос

 

DELETE FROM `droplist` WHERE `itemId` NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6362,8627,8633,8723,8724,872
5,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,874
1
,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757
,
8758,8759,8760,8761,8762,959,955,951,947,729,960,956,952,948,730,6577,6575,6573,
6
571,6569,6578,6576,6574,6572,6570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8
1
67,8175,8160,8159,8158,8172,8171,8170,1419,6665,6666,6667,6668,6669,6670,6671,66
7
2,6661);

 

Ето удаляет все из дропа кроме того что я оставил вписал ид свои

Ошибка

 

 Query 111 start

	[ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,874' at line 2

	[ERR] DELETE FROM `droplist` WHERE `itemId` NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6362,8627,8633,8723,8724,872

	5,8726,8727,8728,8729,8730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8740,874

	1

	,8742,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8756,8757

	,

	8758,8759,8760,8761,8762,959,955,951,947,729,960,956,952,948,730,6577,6575,6573,

	6

	571,6569,6578,6576,6574,6572,6570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8

	1

	67,8175,8160,8159,8158,8172,8171,8170,1419,6665,6666,6667,6668,6669,6670,6671,66

	7

	2,6661);

	[SQL] Finished with error

 

Знаю что структура не та вроде поменять не могу что не пробивал не получаеться   

 

Вот  мое кое что   

 

DELETE FROM droplist WHERE itemId='57';
DELETE FROM droplist WHERE itemId='6662';
DELETE FROM droplist WHERE itemId='6656';
DELETE FROM droplist WHERE itemId='6660';
DELETE FROM droplist WHERE itemId='6659';
DELETE FROM droplist WHERE itemId='6658';
DELETE FROM droplist WHERE itemId='6657';
DELETE FROM droplist WHERE itemId='8191';
DELETE FROM droplist WHERE itemId='6360';
DELETE FROM droplist WHERE itemId='6361';
DELETE FROM droplist WHERE itemId='6362';
DELETE FROM droplist WHERE itemId='8627';
DELETE FROM droplist WHERE itemId='8633';
DELETE FROM droplist WHERE itemId='8732';
DELETE FROM droplist WHERE itemId='8742';
DELETE FROM droplist WHERE itemId='8752';
DELETE FROM droplist WHERE itemId='8762';
DELETE FROM droplist WHERE itemId='959';
DELETE FROM droplist WHERE itemId='955';
DELETE FROM droplist WHERE itemId='951';
DELETE FROM droplist WHERE itemId='947';
DELETE FROM droplist WHERE itemId='729';
DELETE FROM droplist WHERE itemId='960';
DELETE FROM droplist WHERE itemId='956';
DELETE FROM droplist WHERE itemId='952';
DELETE FROM droplist WHERE itemId='948';
DELETE FROM droplist WHERE itemId='730';
DELETE FROM droplist WHERE itemId='6577';
DELETE FROM droplist WHERE itemId='6575';
DELETE FROM droplist WHERE itemId='6573';
DELETE FROM droplist WHERE itemId='6571';
DELETE FROM droplist WHERE itemId='6569';
DELETE FROM droplist WHERE itemId='6578';
DELETE FROM droplist WHERE itemId='6576';
DELETE FROM droplist WHERE itemId='6574';
DELETE FROM droplist WHERE itemId='6572';
DELETE FROM droplist WHERE itemId='6570';
DELETE FROM droplist WHERE itemId='1419';
DELETE FROM droplist WHERE itemId='6665';
DELETE FROM droplist WHERE itemId='6666';
DELETE FROM droplist WHERE itemId='6667';
DELETE FROM droplist WHERE itemId='6668';
DELETE FROM droplist WHERE itemId='6669';
DELETE FROM droplist WHERE itemId='6670';
DELETE FROM droplist WHERE itemId='6671';
DELETE FROM droplist WHERE itemId='6672';
DELETE FROM droplist WHERE itemId='6661';
DELETE FROM droplist WHERE itemId='4037';
DELETE FROM droplist WHERE itemId='6673';
DELETE FROM droplist WHERE itemId='9555';
DELETE FROM droplist WHERE itemId='9556';
DELETE FROM droplist WHERE itemId='9557';
DELETE FROM droplist WHERE itemId='9558';
DELETE FROM droplist WHERE itemId='3470';
DELETE FROM droplist WHERE itemId='8638';
DELETE FROM droplist WHERE itemId='8639';
DELETE FROM droplist WHERE itemId='8626';
DELETE FROM droplist WHERE itemId='6622';
DELETE FROM droplist WHERE itemId='5799';
DELETE FROM droplist WHERE itemId='6721';

 

Ети Ид нада оставить в дропу что мне делать помогите

Сборка от капитошки!

[bublee 6]

Столбцы с базой не совпадают 

[System 20]

Разобрался сам уже

Вот кому то помогу

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'heavy' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'light' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'magic' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM armor WHERE armor_type= 'none' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigsword' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'blunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bow' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'dagger' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'dual' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'dualfist' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'etc' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'none' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'pole' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'sword' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'rod' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM weapon WHERE WeaponType= 'bigblunt' );

 

 

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'arrow' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'dye' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'herb' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'recipe' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'scroll' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'shot' );
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );