Advertisement
Guest User

Untitled

a guest
Apr 12th, 2015
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.10 KB | None | 0 0
  1. select DISTINCT ct1.entry, ct1.name from creature as c1
  2. JOIN creature_template as ct1 on ct1.entry=c1.id
  3. where c1.id in(2388,5123,5178,6169,7937,7950,7944,14724,15763,5122,4081,5174,5175,5158,5124,15187,5570,5140,5605,2695,10090,7976,5121,5119,903,931,5117,5114,5120,5116,13084,11865,5126,5125,5129,5138,5100,5101,2790,5132,5049,6175,5102,5103,13843,5109,3982,2437,1070,376,620,14183,5111,5110,5112,7292,5107,5106,8879,5108,5151,5133,5152,8507,7978,5148,5142,5143,5144,7312,6179,6178,11406,5147,5145,5141,5149,5146,5163,5170,5162,5161,8681,5154,6826,5155,5156,2786,5173,5171,5166,5172,5167,5165,4254,4256,6382,23127,9099,14723,26123,7936,5387,8256,5637,3842,5160,5159,1356,6294,3979,2916,2918,9616,1573,11145,4259,5150,10877,6114,5113,5115,8517,2092,16013,11146,5164,6031,15764,3133,5128,1274,2784,576,960,2409,6790,2668,1673,228,227,17104,276,374,275,265,264,273,272,274,271,270,268,267,263,5464,661,664,663,633,11040,2669,225,3138,1672,226,3135,656,3541,26113,3621,12577,11548,7826,3546,8609,5508,8178,8022,5393,5385,9540,23466,5405,738,928,23434,25039,15351,5081,12920,4079,14983,2810,2789,2788,2812,14984,1471,2808,2814,2700,2816,1212,1284,1348,1351,1416,2703,6574,2706,3555,3554,7489,3552,15124,2835,1440,16288,2226,3557,2140,3553,3556,9553,5886,1938,1952,6389,2121,6739,2792,4954,9555,2851,770,733,739,1422,1747,29611,2230,2364,2438,2380,2277,17106,17100,4267,17310,3996,22935,17303,17291,17287,3970,11137,3969,3967,3962,3961,3959,3958,3954,3953,3952,3691,3543,2357,2094,2439,2504,1459,3178,1463,1461,1460,1454,1450,1242,1462,1452,1441,1453,3179,1571,5082,1239,2096,2097,2111,6738,3291,167,1105,1340,1139,1681,12867,12862,3901,1469,372,1572,6241,1474,1470,3894,3892,11820,3880,3848,3845,17412,4084,27102,3994,4188,16458,4407,8150,12960,1182,13698,5752,11103,3230,6706,1322,5396,5642,5638,3050,3027,3026,3025,3022,3017,3016,3015,3014,3013,3012,3010,3009,3007,3005,3003,2995,7089,8361,8360,8359,8358,2215,17092,3978,14728,14442,14441,3095,3093,3092,3083,10977,2770,3000,9117,2418,3544,2278,2419,2401,2394,3539,9274,9273,9272,9271,9270,8737,9998,9997,7408,23905,4895,5388,4893,6272,4894,4794,4921,5091,8140,23896,4967,23951,4965,7407,23950,23949,4885,4897,4892,4900,4886,4973,4888,4899,4898,16712,11758,11756,14567,734,5594,8661,7876,8131,8129,8128,8126,8125,6568,7824,7823,7564,7804,4708,4960,23570,23571,23995,23579,23573,23572,23566,23892,23835,4982,4941,4896,5384,5413,7724,5411,16417,8736,6576,10645,4722,11116,4126,4877,4876,4875,7166,7161,3572,23535,5871,23534,11052,3292,5489,5491,5492,5509,5510,5512,5514,5515,5516,5517,5518,5519,2382,4321,6171,6173,3499,6579,20102,2519,2464,3540,2383,3498,3497,3495,3494,3493,3492,3491,3490,3489,3488,3487,3486,3485,3484,3483,3482,3481,3480,3479,3478,3477,1147,5814,2699,1381,3464,22940,6791,3453,6266,3449,3448,3446,3442,6254,6252,6251,3432,3431,3429,3428,2664,2846,2848,18927,2858,2840,2497,7766,19175,7798,3934,7917,3665,3658,2941,3305,14624,14628,14627,14625,14626,14634,8666,1149,7485,3391,2847,2670,2685,2845,2859,2842,2849,3390,8496,23452,8738,16418,3615,3339,2616,4968,2495,2502,23263,23270,23272,23858,2501,2500,2498,2494,2493,2491,2490,2488,2487,2486,2465,6807,737,469,3356,3406,3353,11017,3413,19178,3364,3316,3409,3410,3352,5812,3362,3360,4043,3354,3323,2263,2352,2432,2711,2365,3400,3365,3363,3369,3404,3315,7088,3405,3407,7231,3361,3359,3408,11871,10088,3321,3313,3314,3310,3319,3309,3373,3326,3402,3401,3328,12336,9836,2381,2430,9544,9536,773,2594,2496,7406,7794,3945,2705,3980,3542,2366,9562,9177,1296,2299,3298,10267,10260,14451,17098,15350,15188,14392,3189,13445,2228,2216,2410,2389,1387,1148,1146,3144,4949,6987,6986,17076,22899,4485,14843,15078,15079,2391,15116,2393,3348,3399,3368,3367,3366,3346,4752,3333,3332,3412,3357,3355,3358,3351,3350,3403,13417,3344,3342,6929,5188,3312,3322,5817,3317,7311,2229,2429,5958,5883,5994,8404,16577,16584,16585,16587,16602,16632,16706,16708,16713,16714,16715,16716,16718,16722,16732,16738,16748,16750,16753,16757,16761,16762,16767,16768,16789,16790,16791,16792,16793,16794,16796,16797,16798,16799,16819,16822,16823,16825,16826,16829,16830,16832,16833,16834,16839,16858,17006,3349,5885,17219,17226,17277,17479,17493,17505,17509,17512,17513,17514,17519,17520,17557,17584,17585,17636,17657,17658,17663,17667,17676,17684,17703,17807,17825,17843,17844,17923,18024,18097,18098,18166,18222,18223,18224,18234,18243,18252,18266,18267,18335,18353,18387,18389,18390,18408,18416,18427,18459,18481,18484,18530,18531,18537,18538,18584,18594,18596,18597,18653,6014,18704,18713,18745,18749,18751,18752,18754,18756,18771,18772,18773,18774,18775,18785,18788,18789,18802,18804,18809,18905,18906,18908,18914,18930,18931,18939,18940,18987,18988,18990,18991,18997,18998,19001,19004,19012,19014,19017,19021,19042,19047,19049,19050,19052,19053,19056,19074,19137,25140,19475,19182,19186,19194,19195,19196,19197,19213,19217,19223,4500,19227,19229,19234,19235,19236,19238,19239,19240,19243,19244,19245,19253,19255,19296,19308,19321,19330,19331,19332,19202,19339,19342,19351,19352,19363,19370,19371,19372,19373,19374,19435,19436,19451,19452,6018,5882,7793,7792,7790,7010,3324,19466,19467,19468,19469,19485,19495,19497,19498,19499,19517,19518,19520,19521,19526,19528,19530,19531,19532,19533,19534,19535,19536,19537,19538,19539,19540,19558,19559,19560,19561,19562,19570,19572,19573,19574,19575,19617,19625,19634,19645,19649,19661,19662,19663,19664,19678,19682,19683,19684,19709,19715,19722,19736,19772,19773,19836,19880,20028,20067,20068,20084,20096,20097,20121,20162,20205,20206,5816,3329,3334,3335,20240,20241,20242,20249,20250,27667,33941,20389,20470,20471,20510,20511,33602,30372,30359,30370,30369,30357,30363,30373,30358,26371,26375,20613,20616,20722,20762,26309,20807,20808,20811,20871,20914,20915,20916,20917,20980,20981,20989,21019,21066,21082,21083,21084,21086,21088,30723,21107,21110,21111,21112,21113,21151,21158,21175,21197,21256,21279,21283,21330,21357,21402,21411,21460,21469,21496,21655,21691,27722,21744,21746,21755,21773,21774,21775,21777,21782,21822,21824,21860,21895,21896,21906,30733,30732,21937,21938,21953,21954,21955,21983,22004,22007,22020,22042,22043,22053,22107,22133,22149,22150,15561,22208,22211,22212,22213,22214,22225,22227,22231,22292,22312,20231,20232,20234,20235,22373,22427,22430,22431,22479,22485,22491,23273,23449,23483,5815,3330,3327,3325,3331,14721,352,1303,1302,4981,483,482,1286,1285,466,6174,1257,279,5193,1275,1432,1287,1289,1294,1291,1427,1295,3518,1321,5565,1319,1320,1339,4961,1333,2285,1439,6090,340,5483,1646,10782,2198,1721,1323,1341,6089,1324,1328,5480,5479,7207,6946,1326,332,13283,918,3520,1298,1299,1297,1428,1349,14450,1350,1444,4078,14722,1314,1347,5566,1315,1313,5503,5494,277,1301,1431,6740,14394,17804,2397,16205,16528,16199,16200,16198,16739,16766,21950,16719,17538,16709,18183,18233,30735,17120,16771,20604,16735,16657,16765,16751,16747,17511,16756,17468,16705,19177,16183,16196,9299,24393,23484,4631,15310,1365,13444,15354,14480,9317,14727,14726,5910,5909,5892,3216,14481,4047,10540,15708,37675,19556,19169,20159,12580,2542,2663,22924,30729,27489,24501,6446,2844,2622,2832,2482,2626,2839,2838,2499,7853,2843,28401,9563,9561,9565,9560,10880,32407,981,984,8176,980,983,5416,24366,1670,491,843,1668,820,878,821,234,8934,8931,523,297,331,338,1141,1304,1305,1307,1308,1309,1310,1311,1312,1316,1318,1429,1435,1719,2708,5386,5495,5496,5497,5498,5694,15576,19176,15895,15898,15891,15564,15579,15892,15562,15871,37674,37172,15566,23559,33933,12943,11057,11194,10856,10839,10837,11055,11835,36273,14729,11615,17099,11022,5639,10857,11053,10838,10840,11056,12942,17238,11023,12425,12596,11616,11609,17069,17072,12941,12617,12636,11063,11036,16131,16134,16132,16376,16135,16256,16133,16116,16114,11038,11039,16112,16115,16212,16283,16113,11536,11033,11034,11035,5635,5636,11810,11812,11813,14739,7865,8018,17223,5640,5611,23948,25950,25163,25043,25036,24975,26753,26752,26748,26755,26757,26759,26751,26756,26758,26754,26765,26749,26747,26739,26740,26741,26738,26742,26724,26743,26744,26745,25167,18525,24932,21432,18893,22497,23271,24727,24885,37915,24851,24866,15605,15558,15574,15582,15588,15597,15599,15586,15584,15585,15577,23280,8659,23268,23761,23724,27666,5875,10361,8576,8586,8587,8610,14301,3841,11037,24370,24369,8997,3644,3649,6737,3666,4182,4183,4186,4187,4190,4191,4192,2913,4200,2930,3702,6297,6298,6299,6300,6301,6086,10216,3583,2803,15315,12578,11019,11180,9996,9116,10920,10922,10921,10923,10924,22931,11554,9465,5501,16416,10303,10305,10307,11629,11138,11139,10637,11182,11183,11184,11185,11186,11187,11188,11189,11191,10431,10468,11753,11754,11755,11757,11957,11956,15419,15174,15175,15176,15177,15178,15179,15180,15181,15182,15183,15189,15190,15191,15498,15499,15500,16543,15270,15282,15540,17081,17082,15306,16091,15614,3607,10118,7907,7916,3838,7941,7942,7946,7947,7948,14374,11818,11824,11825,11826,10293,7736,7737,9548,8019,7764,8020,8021,7776,7777,3700,1695,7852,3500,7870,4544,11717,7878,7879,7880,8142,8143,4048,8146,8147,7900,8157,8158,4319,28126,26401,25896,25910,25916,25921,25962,26221,25975,25994,26520,16817,16818,28160,26880,26881,27137,25602,27138,28674,27139,27140,32773,27141,26374,27142,31238,27143,27144,29961,27145,26377,29962,27146,29963,27147,26379,29964,25356,27148,27149,26382,27151,28175,31247,28176,29968,28177,29969,23482,28178,29970,29971,26388,26901,23831,24343,26649,29721,24347,26652,24349,25374,30239,29727,29473,30241,26915,28195,24356,29732,27172,30244,28196,24357,29733,28197,27174,24359,27176,26666,24362,26155,28204,27181,30253,26158,27182,30254,29743,26415,30255,29744,27184,30256,26673,27185,30257,27186,25395,23859,27187,27188,32564,29750,27190,23862,26936,26680,24376,27193,26939,27195,24123,29244,24125,30269,24126,28479,30271,24127,26944,28480,24129,29762,24131,28484,26950,24390,24135,27719,26440,27720,26697,26441,26953,28746,26443,24139,24141,26959,26960,28497,27986,26194,26707,24147,28244,24148,27221,26709,24149,24152,33865,30360,27227,26459,24155,26973,24157,26718,26720,23908,25702,28518,26471,26984,31081,29801,30569,28266,27243,30572,26989,31085,28527,27248,24176,26226,26995,26228,28532,26997,26229,26485,28791,28792,27001,28794,24188,28796,28797,25982,24702,27262,28798,25983,24703,28031,24191,28799,28800,28032,28033,24706,27266,23938,27267,27011,27012,24709,25477,26245,28806,28038,28039,28807,25736,28040,26504,25480,26505,28809,25737,26506,28810,27019,28811,28812,27277,27021,28813,28046,27022,29583,27025,27026,25747,27027,25235,27028,28309,27030,27031,27032,28568,29593,24730,24218,28059,27291,28828,27804,24733,27037,28829,25245,28062,28574,28830,27295,28831,28832,25248,25249,25250,25251,23975,23976,28328,25257,23978,24234,27051,27052,31916,27053,30381,25262,27054,24494,27055,23728,27057,27058,24755,27060,25780,23733,27062,23734,28855,23735,27063,27320,23736,25785,27066,26810,23738,24251,27067,24252,27582,27069,27070,27071,24768,24256,28866,28867,26564,28868,28869,25285,26566,28870,26567,28871,28615,30152,26568,28872,27337,26569,28618,25291,26574,30671,28623,28624,27088,29904,27344,29905,29137,27089,29650,25298,25299,29907,30676,26580,29908,26581,26837,29909,25301,25302,26584,25816,23770,24795,25307,24028,26844,26845,23773,26847,26848,24032,24033,26850,25826,29922,26595,29923,33866,33644,26852,23780,26596,29157,26853,29925,29158,26854,29926,26598,29159,26599,29160,26600,29161,29162,24810,26602,26860,25326,29169,29428,27125,25590,29431,29687,26104,25849,26361,24313,26618,23546,26362,29690,25339,26875,32763,27388,27132,23548,26876,27133,23549,24061,29950,27134,26879,27391,30730,12785,34081,12784,26117,31240,30216,31241,30218,29456,32538,30002,28827,31044,31069,30306,30307,30309,31078,30310,30311,30314,30067,30069,30070,30074,23895,30734,30336,31115,29343,29344,27046,29396,29405,30431,30433,30946,30434,25314,30436,30437,30438,30439,26110,25394,32565,26938,26941,26945,26968,26969,26972,26977,26982,25978,25237,34094,25247,25256,25272,25273,25274,25278,25279,25280,25288,25289,29155,25327,12788,12794,34060,12793,34063,34043,34038,12796,12795,34078,34075,12778,12781,12783,34084,29203,29205,29207,29208,27928,29480,28500,29587,22819,31084,32533,27935,27938,27940,26917,27943,27950,26949,27990,26983,27765,27785,27803,38017,27575,27856,26851,27136,27155,27156,27158,27159,27314,27316,27317,27577,26878,26212,27784,27544,27038,27039,27041,27042,27043,27044,27045,27318,27872,26877,23547,33762,37888,33598,33597,33853,33596,33595,33594,33849,17103,24729,33769,33770,35073,35573,35574,35575,35576,35577,35578,35579,35580,35131,35132,33025,24330,32477,32478,29951,34093,20278,33939,33935,33934,30252,29757,35068,33640,33637,15309,28037,33871,33872,33940,35101,33868,33869,30223,25931,30472,29651,29937,29944,29945,29947,30247,24052,24053,24054,24057,24282,24328,23749,23888,24038,35099,15077,28179,30657,30224,30226,30227,30677,32594,32571,32540,30294,30127,30105,33924,33931,34090,34091,33928,33915,33918,34088,34089,33916,33920,33917,33919,38042,38044,38045,38295,38328,15119,32405,32385,32832,32383,32834,32380,32381,29804,29346,37887,38040,38041,38066,38325,38293,30869,31036,31051,31052,31054,31108,31109,31153,30870,31053,31091,31101,31102,31106,31107,31151,36517,34483,34476,34382,34480,15199,34653,34783,35340,34714,34654,35343,34684,34678,34712,34768,34683,34677,35341,34787,35342,32809,32806,25918,23510,28347,27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820,27478,24545,33630,33639,33645)
  4. AND (c1.id IN (select entryorguid from smart_scripts) OR c1.guid IN (select entryorguid from smart_scripts))
  5.  
  6.  
  7.  
  8. select DISTINCT ct1.entry, ct1.name from creature as c1
  9. JOIN creature_template as ct1 on ct1.entry=c1.id
  10. where c1.id in(2388,5123,5178,6169,7937,7950,7944,14724,15763,5122,4081,5174,5175,5158,5124,15187,5570,5140,5605,2695,10090,7976,5121,5119,903,931,5117,5114,5120,5116,13084,11865,5126,5125,5129,5138,5100,5101,2790,5132,5049,6175,5102,5103,13843,5109,3982,2437,1070,376,620,14183,5111,5110,5112,7292,5107,5106,8879,5108,5151,5133,5152,8507,7978,5148,5142,5143,5144,7312,6179,6178,11406,5147,5145,5141,5149,5146,5163,5170,5162,5161,8681,5154,6826,5155,5156,2786,5173,5171,5166,5172,5167,5165,4254,4256,6382,23127,9099,14723,26123,7936,5387,8256,5637,3842,5160,5159,1356,6294,3979,2916,2918,9616,1573,11145,4259,5150,10877,6114,5113,5115,8517,2092,16013,11146,5164,6031,15764,3133,5128,1274,2784,576,960,2409,6790,2668,1673,228,227,17104,276,374,275,265,264,273,272,274,271,270,268,267,263,5464,661,664,663,633,11040,2669,225,3138,1672,226,3135,656,3541,26113,3621,12577,11548,7826,3546,8609,5508,8178,8022,5393,5385,9540,23466,5405,738,928,23434,25039,15351,5081,12920,4079,14983,2810,2789,2788,2812,14984,1471,2808,2814,2700,2816,1212,1284,1348,1351,1416,2703,6574,2706,3555,3554,7489,3552,15124,2835,1440,16288,2226,3557,2140,3553,3556,9553,5886,1938,1952,6389,2121,6739,2792,4954,9555,2851,770,733,739,1422,1747,29611,2230,2364,2438,2380,2277,17106,17100,4267,17310,3996,22935,17303,17291,17287,3970,11137,3969,3967,3962,3961,3959,3958,3954,3953,3952,3691,3543,2357,2094,2439,2504,1459,3178,1463,1461,1460,1454,1450,1242,1462,1452,1441,1453,3179,1571,5082,1239,2096,2097,2111,6738,3291,167,1105,1340,1139,1681,12867,12862,3901,1469,372,1572,6241,1474,1470,3894,3892,11820,3880,3848,3845,17412,4084,27102,3994,4188,16458,4407,8150,12960,1182,13698,5752,11103,3230,6706,1322,5396,5642,5638,3050,3027,3026,3025,3022,3017,3016,3015,3014,3013,3012,3010,3009,3007,3005,3003,2995,7089,8361,8360,8359,8358,2215,17092,3978,14728,14442,14441,3095,3093,3092,3083,10977,2770,3000,9117,2418,3544,2278,2419,2401,2394,3539,9274,9273,9272,9271,9270,8737,9998,9997,7408,23905,4895,5388,4893,6272,4894,4794,4921,5091,8140,23896,4967,23951,4965,7407,23950,23949,4885,4897,4892,4900,4886,4973,4888,4899,4898,16712,11758,11756,14567,734,5594,8661,7876,8131,8129,8128,8126,8125,6568,7824,7823,7564,7804,4708,4960,23570,23571,23995,23579,23573,23572,23566,23892,23835,4982,4941,4896,5384,5413,7724,5411,16417,8736,6576,10645,4722,11116,4126,4877,4876,4875,7166,7161,3572,23535,5871,23534,11052,3292,5489,5491,5492,5509,5510,5512,5514,5515,5516,5517,5518,5519,2382,4321,6171,6173,3499,6579,20102,2519,2464,3540,2383,3498,3497,3495,3494,3493,3492,3491,3490,3489,3488,3487,3486,3485,3484,3483,3482,3481,3480,3479,3478,3477,1147,5814,2699,1381,3464,22940,6791,3453,6266,3449,3448,3446,3442,6254,6252,6251,3432,3431,3429,3428,2664,2846,2848,18927,2858,2840,2497,7766,19175,7798,3934,7917,3665,3658,2941,3305,14624,14628,14627,14625,14626,14634,8666,1149,7485,3391,2847,2670,2685,2845,2859,2842,2849,3390,8496,23452,8738,16418,3615,3339,2616,4968,2495,2502,23263,23270,23272,23858,2501,2500,2498,2494,2493,2491,2490,2488,2487,2486,2465,6807,737,469,3356,3406,3353,11017,3413,19178,3364,3316,3409,3410,3352,5812,3362,3360,4043,3354,3323,2263,2352,2432,2711,2365,3400,3365,3363,3369,3404,3315,7088,3405,3407,7231,3361,3359,3408,11871,10088,3321,3313,3314,3310,3319,3309,3373,3326,3402,3401,3328,12336,9836,2381,2430,9544,9536,773,2594,2496,7406,7794,3945,2705,3980,3542,2366,9562,9177,1296,2299,3298,10267,10260,14451,17098,15350,15188,14392,3189,13445,2228,2216,2410,2389,1387,1148,1146,3144,4949,6987,6986,17076,22899,4485,14843,15078,15079,2391,15116,2393,3348,3399,3368,3367,3366,3346,4752,3333,3332,3412,3357,3355,3358,3351,3350,3403,13417,3344,3342,6929,5188,3312,3322,5817,3317,7311,2229,2429,5958,5883,5994,8404,16577,16584,16585,16587,16602,16632,16706,16708,16713,16714,16715,16716,16718,16722,16732,16738,16748,16750,16753,16757,16761,16762,16767,16768,16789,16790,16791,16792,16793,16794,16796,16797,16798,16799,16819,16822,16823,16825,16826,16829,16830,16832,16833,16834,16839,16858,17006,3349,5885,17219,17226,17277,17479,17493,17505,17509,17512,17513,17514,17519,17520,17557,17584,17585,17636,17657,17658,17663,17667,17676,17684,17703,17807,17825,17843,17844,17923,18024,18097,18098,18166,18222,18223,18224,18234,18243,18252,18266,18267,18335,18353,18387,18389,18390,18408,18416,18427,18459,18481,18484,18530,18531,18537,18538,18584,18594,18596,18597,18653,6014,18704,18713,18745,18749,18751,18752,18754,18756,18771,18772,18773,18774,18775,18785,18788,18789,18802,18804,18809,18905,18906,18908,18914,18930,18931,18939,18940,18987,18988,18990,18991,18997,18998,19001,19004,19012,19014,19017,19021,19042,19047,19049,19050,19052,19053,19056,19074,19137,25140,19475,19182,19186,19194,19195,19196,19197,19213,19217,19223,4500,19227,19229,19234,19235,19236,19238,19239,19240,19243,19244,19245,19253,19255,19296,19308,19321,19330,19331,19332,19202,19339,19342,19351,19352,19363,19370,19371,19372,19373,19374,19435,19436,19451,19452,6018,5882,7793,7792,7790,7010,3324,19466,19467,19468,19469,19485,19495,19497,19498,19499,19517,19518,19520,19521,19526,19528,19530,19531,19532,19533,19534,19535,19536,19537,19538,19539,19540,19558,19559,19560,19561,19562,19570,19572,19573,19574,19575,19617,19625,19634,19645,19649,19661,19662,19663,19664,19678,19682,19683,19684,19709,19715,19722,19736,19772,19773,19836,19880,20028,20067,20068,20084,20096,20097,20121,20162,20205,20206,5816,3329,3334,3335,20240,20241,20242,20249,20250,27667,33941,20389,20470,20471,20510,20511,33602,30372,30359,30370,30369,30357,30363,30373,30358,26371,26375,20613,20616,20722,20762,26309,20807,20808,20811,20871,20914,20915,20916,20917,20980,20981,20989,21019,21066,21082,21083,21084,21086,21088,30723,21107,21110,21111,21112,21113,21151,21158,21175,21197,21256,21279,21283,21330,21357,21402,21411,21460,21469,21496,21655,21691,27722,21744,21746,21755,21773,21774,21775,21777,21782,21822,21824,21860,21895,21896,21906,30733,30732,21937,21938,21953,21954,21955,21983,22004,22007,22020,22042,22043,22053,22107,22133,22149,22150,15561,22208,22211,22212,22213,22214,22225,22227,22231,22292,22312,20231,20232,20234,20235,22373,22427,22430,22431,22479,22485,22491,23273,23449,23483,5815,3330,3327,3325,3331,14721,352,1303,1302,4981,483,482,1286,1285,466,6174,1257,279,5193,1275,1432,1287,1289,1294,1291,1427,1295,3518,1321,5565,1319,1320,1339,4961,1333,2285,1439,6090,340,5483,1646,10782,2198,1721,1323,1341,6089,1324,1328,5480,5479,7207,6946,1326,332,13283,918,3520,1298,1299,1297,1428,1349,14450,1350,1444,4078,14722,1314,1347,5566,1315,1313,5503,5494,277,1301,1431,6740,14394,17804,2397,16205,16528,16199,16200,16198,16739,16766,21950,16719,17538,16709,18183,18233,30735,17120,16771,20604,16735,16657,16765,16751,16747,17511,16756,17468,16705,19177,16183,16196,9299,24393,23484,4631,15310,1365,13444,15354,14480,9317,14727,14726,5910,5909,5892,3216,14481,4047,10540,15708,37675,19556,19169,20159,12580,2542,2663,22924,30729,27489,24501,6446,2844,2622,2832,2482,2626,2839,2838,2499,7853,2843,28401,9563,9561,9565,9560,10880,32407,981,984,8176,980,983,5416,24366,1670,491,843,1668,820,878,821,234,8934,8931,523,297,331,338,1141,1304,1305,1307,1308,1309,1310,1311,1312,1316,1318,1429,1435,1719,2708,5386,5495,5496,5497,5498,5694,15576,19176,15895,15898,15891,15564,15579,15892,15562,15871,37674,37172,15566,23559,33933,12943,11057,11194,10856,10839,10837,11055,11835,36273,14729,11615,17099,11022,5639,10857,11053,10838,10840,11056,12942,17238,11023,12425,12596,11616,11609,17069,17072,12941,12617,12636,11063,11036,16131,16134,16132,16376,16135,16256,16133,16116,16114,11038,11039,16112,16115,16212,16283,16113,11536,11033,11034,11035,5635,5636,11810,11812,11813,14739,7865,8018,17223,5640,5611,23948,25950,25163,25043,25036,24975,26753,26752,26748,26755,26757,26759,26751,26756,26758,26754,26765,26749,26747,26739,26740,26741,26738,26742,26724,26743,26744,26745,25167,18525,24932,21432,18893,22497,23271,24727,24885,37915,24851,24866,15605,15558,15574,15582,15588,15597,15599,15586,15584,15585,15577,23280,8659,23268,23761,23724,27666,5875,10361,8576,8586,8587,8610,14301,3841,11037,24370,24369,8997,3644,3649,6737,3666,4182,4183,4186,4187,4190,4191,4192,2913,4200,2930,3702,6297,6298,6299,6300,6301,6086,10216,3583,2803,15315,12578,11019,11180,9996,9116,10920,10922,10921,10923,10924,22931,11554,9465,5501,16416,10303,10305,10307,11629,11138,11139,10637,11182,11183,11184,11185,11186,11187,11188,11189,11191,10431,10468,11753,11754,11755,11757,11957,11956,15419,15174,15175,15176,15177,15178,15179,15180,15181,15182,15183,15189,15190,15191,15498,15499,15500,16543,15270,15282,15540,17081,17082,15306,16091,15614,3607,10118,7907,7916,3838,7941,7942,7946,7947,7948,14374,11818,11824,11825,11826,10293,7736,7737,9548,8019,7764,8020,8021,7776,7777,3700,1695,7852,3500,7870,4544,11717,7878,7879,7880,8142,8143,4048,8146,8147,7900,8157,8158,4319,28126,26401,25896,25910,25916,25921,25962,26221,25975,25994,26520,16817,16818,28160,26880,26881,27137,25602,27138,28674,27139,27140,32773,27141,26374,27142,31238,27143,27144,29961,27145,26377,29962,27146,29963,27147,26379,29964,25356,27148,27149,26382,27151,28175,31247,28176,29968,28177,29969,23482,28178,29970,29971,26388,26901,23831,24343,26649,29721,24347,26652,24349,25374,30239,29727,29473,30241,26915,28195,24356,29732,27172,30244,28196,24357,29733,28197,27174,24359,27176,26666,24362,26155,28204,27181,30253,26158,27182,30254,29743,26415,30255,29744,27184,30256,26673,27185,30257,27186,25395,23859,27187,27188,32564,29750,27190,23862,26936,26680,24376,27193,26939,27195,24123,29244,24125,30269,24126,28479,30271,24127,26944,28480,24129,29762,24131,28484,26950,24390,24135,27719,26440,27720,26697,26441,26953,28746,26443,24139,24141,26959,26960,28497,27986,26194,26707,24147,28244,24148,27221,26709,24149,24152,33865,30360,27227,26459,24155,26973,24157,26718,26720,23908,25702,28518,26471,26984,31081,29801,30569,28266,27243,30572,26989,31085,28527,27248,24176,26226,26995,26228,28532,26997,26229,26485,28791,28792,27001,28794,24188,28796,28797,25982,24702,27262,28798,25983,24703,28031,24191,28799,28800,28032,28033,24706,27266,23938,27267,27011,27012,24709,25477,26245,28806,28038,28039,28807,25736,28040,26504,25480,26505,28809,25737,26506,28810,27019,28811,28812,27277,27021,28813,28046,27022,29583,27025,27026,25747,27027,25235,27028,28309,27030,27031,27032,28568,29593,24730,24218,28059,27291,28828,27804,24733,27037,28829,25245,28062,28574,28830,27295,28831,28832,25248,25249,25250,25251,23975,23976,28328,25257,23978,24234,27051,27052,31916,27053,30381,25262,27054,24494,27055,23728,27057,27058,24755,27060,25780,23733,27062,23734,28855,23735,27063,27320,23736,25785,27066,26810,23738,24251,27067,24252,27582,27069,27070,27071,24768,24256,28866,28867,26564,28868,28869,25285,26566,28870,26567,28871,28615,30152,26568,28872,27337,26569,28618,25291,26574,30671,28623,28624,27088,29904,27344,29905,29137,27089,29650,25298,25299,29907,30676,26580,29908,26581,26837,29909,25301,25302,26584,25816,23770,24795,25307,24028,26844,26845,23773,26847,26848,24032,24033,26850,25826,29922,26595,29923,33866,33644,26852,23780,26596,29157,26853,29925,29158,26854,29926,26598,29159,26599,29160,26600,29161,29162,24810,26602,26860,25326,29169,29428,27125,25590,29431,29687,26104,25849,26361,24313,26618,23546,26362,29690,25339,26875,32763,27388,27132,23548,26876,27133,23549,24061,29950,27134,26879,27391,30730,12785,34081,12784,26117,31240,30216,31241,30218,29456,32538,30002,28827,31044,31069,30306,30307,30309,31078,30310,30311,30314,30067,30069,30070,30074,23895,30734,30336,31115,29343,29344,27046,29396,29405,30431,30433,30946,30434,25314,30436,30437,30438,30439,26110,25394,32565,26938,26941,26945,26968,26969,26972,26977,26982,25978,25237,34094,25247,25256,25272,25273,25274,25278,25279,25280,25288,25289,29155,25327,12788,12794,34060,12793,34063,34043,34038,12796,12795,34078,34075,12778,12781,12783,34084,29203,29205,29207,29208,27928,29480,28500,29587,22819,31084,32533,27935,27938,27940,26917,27943,27950,26949,27990,26983,27765,27785,27803,38017,27575,27856,26851,27136,27155,27156,27158,27159,27314,27316,27317,27577,26878,26212,27784,27544,27038,27039,27041,27042,27043,27044,27045,27318,27872,26877,23547,33762,37888,33598,33597,33853,33596,33595,33594,33849,17103,24729,33769,33770,35073,35573,35574,35575,35576,35577,35578,35579,35580,35131,35132,33025,24330,32477,32478,29951,34093,20278,33939,33935,33934,30252,29757,35068,33640,33637,15309,28037,33871,33872,33940,35101,33868,33869,30223,25931,30472,29651,29937,29944,29945,29947,30247,24052,24053,24054,24057,24282,24328,23749,23888,24038,35099,15077,28179,30657,30224,30226,30227,30677,32594,32571,32540,30294,30127,30105,33924,33931,34090,34091,33928,33915,33918,34088,34089,33916,33920,33917,33919,38042,38044,38045,38295,38328,15119,32405,32385,32832,32383,32834,32380,32381,29804,29346,37887,38040,38041,38066,38325,38293,30869,31036,31051,31052,31054,31108,31109,31153,30870,31053,31091,31101,31102,31106,31107,31151,36517,34483,34476,34382,34480,15199,34653,34783,35340,34714,34654,35343,34684,34678,34712,34768,34683,34677,35341,34787,35342,32809,32806,25918,23510,28347,27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820,27478,24545,33630,33639,33645)
  11. AND (c1.id NOT IN (select entryorguid from smart_scripts) AND c1.guid NOT IN (select entryorguid from smart_scripts))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement