Error writing file '/tmp/MYfd=147' (OS errno 28 - No space left on device)SELECT tovar.id as id, tovar.header as header, (CASE currency WHEN 'usd' THEN round(price * 81,2) WHEN 'euro' THEN round(price * 90,2) WHEN 'rur' THEN price END) as pricecon, (CASE tovar.currency WHEN 'usd' THEN round(tovar.price_old * 81,2) WHEN 'euro' THEN round(tovar.price_old * 90,2) WHEN 'rur' THEN tovar.price_old END) as oldpricecon FROM tovar WHERE tovar.id IN (1899,1900,1901,1902,1907,1909,1915,1917,1918,1919,1924,1927,1933,1934,1935,1938,1943,1944,1945,1946,1947,1948,1950,1956,1959,1962,1965,1974,1976,1979,1981,1983,1992,1993,2003,2004,2009,2011,2013,2018,2027,2029,2052,2098,5168,5172,5176,5177,5180,5181,5182,5183,6479,6480,6481,6482,6483,6484,6485,6486,6487,6488,6862,6926,6927,6929,7752,7759,7764,7765,8131,8229,8230,8231,8232,8233,8235,8236,8237,8238,8239,8243,8247,8248,8250,8580,8599,8600,8601,8603,8604,8605,8606,8607,8608,8610,8869,8870,8871,8880,8881,8883,8884,8886,8888,8889,8890,8891,8892,8893,8894,8895,8897,8899,8900,8901,8903,8906,8907,9126,9127,9129,9132,9141,9448,9449,9450,9451,9452,9453,9454,9503,9544,9547,9643,9647,9648,9650,10003,10187,10188,10190,10192,10193,10194,10196,10475,10691,10693,10694,10817,10818,11005,11006,11007,11008,11009,11011,11387,11388,11389,11390,11391,11392,11394,11395,11396,11397,11398,11399,11400,11401,11402,11403,11480,11481,11482,11483,11484,11485,11486,11487,11489,11490,11671,11672,11675,11706,11707,11708,11709,11710,11711,11712,11716,11717,11718,11723,11725,11726,11727,11728,11732,11734,11739,11740,11741,11742,11743,11744,11745,11746,11747,11748,11749,11750,11751,11752,11753,11920,11923,11930,11941,11942,11943,11944,11945,11946,11954,11956,11966,11985,11986,11988,11991,11992,12182,12183,12184,12187,12189,12190,12519,12522,12523,12524,12525,12526,12527,12528,12529,12530,12531,12532,12533,12880,13042,13061,13088,13089,13090,13091,13093,13094,13095,13097,13098,13099,13100,13102,13104,13106,13108,13109,13146,13147,13149,13228,13229,13230,13234,13235,13236,13238,13270,13271,13272,13273,13274,13276,13277,13278,13279,13280,13281,13331,13334,13335,13342,13343,13346,13352,13420,13421,13426,13428,13434,13435,13436,13437,13438,13439,13442,13443,13445,13446,13447,13448,13453,13456,13457,13458,13459,13460,13461,13462,13463,13465,13466,13474,13476,13477,13478,13479,13480,13481,13482,13483,13484,13485,13533,13572,13581,13585,13586,13588,13589,13590,13591,13592,13593,13594,13596,13597,13598,13599,13600,13601,13602,13603,13604,13605,13606,13611,13612,13613,13614,13615,13616,13617,13618,13891,14094,14111,14112,14113,14114,14115,14153,14184,14185,14231,14232,14233,14375,14376,14378,14380,14381,14382,14383,14397,14523,14524,14612,14613,14616,14653,14654,14655,14656,14759,14761,14762,14767,14768,14901,14902,14904,14905,14908,14977,14979,14980,14984,14986,14988,14989,15221,15222,15223,15453,15454,15455,15456,15457,15458,15459,15460,15461,15462,15463,15464,15492,15493,15494,15562,15563,15564,15565,15566,15670,15671,15705,15706,15707,15708,15709,15710,15711,15712,15713,15714,15715,15761,15762,15763,15764,15765,15766,15767,15856,15972,15976,15977,15978,15980,15981,15982,15983,15984,16009,16013,16083,16086,16087,16112,16113,16114,16115,16116,16117,16118,16121,16127,16129,16130,16131,16132,16134,16136,16152,16153,16154,16155,16156,16168,16193,16207,16274,16275,16276,16277,16278,16279,16306,16319,16320,16330,16331,16332,16378,16379,16383,16384,16385,16397,16398,16404,16411,16431,16434,16436,16437,16624,16625,16626,16627,16663,16753,16754,16755,16756,16757,16758,16759,16760,16761,16762,16816,16817,16818,16819,16820,16821,16822,16823,16824,16825,16826,16827,16828,16829,16830,16831,16832,17293,17488,17512,17513,17514,17515,17516,17517,17518,17519,17520,17521,17522,17523,17524,17525,17526,17527,17528,17529,17530,17531,17532,17533,17534,17535,17536,17572,17603,17604,17686,17687,17688,17689,17690,17691,17692,17693,17701,17702,17704,17705,17706,17707,17713,17714,17756,17757,17758,17759,17760,17769,17770,17771,17987,17988,18000,18001,18002,18003,18004,18006,18007,18008,18009,18011,18012,18082,18083,18084,18089,18092,18093,18096,18097,18098,18104,18105,18107,18110,18111,18116,18117,18118,18197,18198,18199,18200,18201,18202,18336,18391,18392,18393,18397,18398,18399,18400,18401,18402,18403,18404,18405,18421,18422,18597,18600,18627,18628,18629,18630,18631,18632,18660,18661,18678,18751,18789,18863,18866,18867,18868,18869,18957,18958,18959,18960,18961,18962,18963,18964,18965,19072,19073,19077,19264,19517,19518,19536,19539,19540,19542,19543,19544,19545,19546,19547,19549,19550,19565,19567,19568,19569,19570,19571,19574,19813,19814,19815,19816,19817,19818,19819,19820,19821,19822,19823,19824,19825,19826,19828,19916,19917,19918,19968,19969,19970,20014,20016,20017,20018,20019,20020,20021,20022,20023,20024,20025,20026,20027,20035,20040,20042,20043,20044,20045,20046,20048,20101,20102,20103,20195,20199,20267,20571,20572,20574,20575,20576,20577,20578,20619,20620,20621,20695,20696,20931,20932,20933,20934,20935,20936,20940,20941,20942,21014,21016,21017,21018,21246,21247,21248,21251,21252,21253,21258,21262,21263,21269,21803,21878,21879,21880,21881,21882,21883,21888,21890,22140,22155,22156,22369,22370,22371,22372,22374,22375,22376,22377,22378,22379,22380,22381,22382,22383,22384,22385,22386,22387,22430,22431,22432,22433,22434,22435,22436,22630,22631,22632,22633,22636,22637,22638,22640,22645,22646,22647,22649,22650,22651,22652,22653,22669,22671,22674,22675,22677,22680,22681,22686,22689,22690,22691,22692,22693,22694,22695,22696,22697,22698,22699,22700,22701,22702,22703,22704,22705,22706,22707,22708,22709,22710,22711,22712,22717,22722,22726,22727,22732,22738,22739,22750,22751,22757,22761,22762,22763,22764,22766,22769,22773,22775,22776,22777,22778,22779,22780,22781,22782,22783,22784,22785,22787,22788,22789,22790,22791,22792,22793,22794,22795,22796,22801,22803,22805,22810,22811,22812,22815,22816,22826,22827,22828,22829,22830,22831,22832,22833,22834,22835,22836,22837,22838,22839,22840,22841,22842,22843,22845,22847,22848,22850,22852,22854,22859,22860,22861,22862,22863,22864,22865,22866,22867,22868,22869,22870,22871,22872,22873,22874,22875,22876,22877,22878,22879,22882,22883,23301,23498,23499,23527,23528,23531,23532,23533,23538,23553,23554,23555,23556,23557,23558,23559,23560,23561,23562,23563,23564,23565,23566,23567,23568,23569,23570,23571,23572,23573,23574,23575,23576,23577,23578,23579,23580,23581,23736,23738,23739,23740,23870,23974,23975,23979,23980,23982,23983,23984,23988,23989,24007,24015,24016,24017,24019,24020,24021,24022,24023,24032,24033,24034,24035,24036,24038,24039,24040,24041,24042,24043,24045,24065,24067,24083,24214,24216,24217,24218,24220,24221,24222,24223,24224,24225,24226,24227,24228,24229,24230,24231,24232,24284,24285,24287,24288,24289,24290,24291,24292,24293,24294,24295,24296,24297,24298,24299,24300,24301,24302,24303,24523,24598,24599,24600,24601,24602,24603,24604,24605,24606,24607,24608,24609,24610,24611,24621,24622,24624,24628,24630,24632,24636,24639,24640,24641,24642,24643,24644,24645,24646,24647,24648,24649,24671,24672,24673,24674,24675,24676,24677,24678,24679,24680,24681,24816,24817,24818,24819,25206,25207,25208,25209,25210,25211,25212,25213,25214,25215,25216,25217,25218,25219,25220,25221,25222,25223,25224,25266,25269,25270,25271,25272,25274,25275,25276,25278,25279,25284,25286,25287,25289,25291,25292,25293,25294,25295,25296,25297,25298,25299,25300,25301,25302,25303,25425,25652,25653,25655,25658,25760,25761,25769,25770,25774,25782,25783,25784,25785,25800,25801,25802,25803,26564,26566,26568,26569,26626,26641,26642,26643,26644,26664,26665,26666,26667,26668,26670,26674,26676,26704,26712,26713,26714,26716,26717,26718,26720,26721,26722,26723,26724,26730,26731,26732,26734,26736,26737,26738,26739,26740,26743,26767,26780,26786,26788,26790,26833,26834,26837,26838,26839,26840,26841,26842,26843,26845,26846,26847,26849,26850,26851,26852,26853,26854,26855,26860,26861,26866,26867,26868,26873,26874,26875,26876,26877,26878,26879,26880,26881,26883,26886,26897,26900,26902,26910,27059,27093,27162,27343,27344,27346,27347,27348,27349,27350,27383,27384,27385,27386,27387,27389,27390,27391,27392,27393,27436,27437,27438,27439,27440,27441,27442,27443,27444,27445,27446,27447,27448,27450,27451,27452,27453,27454,27468,27469,27470,27471,27473,27475,27476,27477,27517,27518,27526,27528,27529,27540,27541,27543,27545,27546,27547,27548,27551,27552,27553,27554,27557,27558,27559,27560,27561,27562,27563,27564,27565,27567,27568,27569,27570,27571,27573,27575,27577,27578,27579,27580,27629,27634,27635,27636,27637,27638,27642,27643,27644,27645,27646,27647,27650,27651,27652,27653,27654,27655,27656,27657,27658,27660,27661,27662,27663,27665,27666,27667,27668,27669,27670,27672,27673,27674,27676,27677,27678,27679,27680,27681,27682,27683,27684,27685,27686,27688,27689,27690,27691,27692,27693,27694,27695,27696,27697,27706,27707,27714,27715,27740,27746,28276,28278,28279,28281,28282,28288,28289,28290,28291,28292,28293,28294,28295,28296,28297,28298,28299,28300,28301,28599,28652,28653,28797,28798,28799,28800,28801,28802,28803,28804,28805,28806,28807,28808,28809,28845,28846,28847,28848,28849,28850,28851,28852,28853,28854,28855,28859,28860,28861,28862,28863,28864,28865,29003,29004,29005,29007,29008,29009,29010,29118,29119,29120,29121,29148,29149,29150,29152,29153,29188,29189,29190,29191,29192,29193,29194,29195,29198,29199,29200,29201,29202,29203,29204,29333,29334,29335,29336,29342,29358,29359,29360,29376,29377,29378,29732,30042,30043,30044,30045,30046,30047,30048,30049,30112,30113,30116,30117,30118,30119,30120,30121,30122,30123,30124,30125,30126,30127,30128,30129,30130,30131,30132,30133,30134,30135,30136,30137,30138,30139,30140,30141,30142,30143,30144,30145,30146,30147,30148,30149,30150,30151,30152,30153,30154,30156,30157,30158,30159,30161,30162,30163,30164,30165,30166,30167,30168,30169,30170,30171,30172,30173,30174,30175,30176,30177,30178,30179,30180,30181,30183,30184,30185,30186,30187,30189,30192,30193,30194,30217,30218,30219,30220,30221,30222,30223,30224,30225,30226,30227,30228,30229,30236,30237,30238,30239,30240,30241,30242,30243,30244,30245,30246,30247,30249,30250,30251,30252,30253,30254,30255,30256,30257,30258,30260,30261,30262,30263,30264,30265,30266,30267,30268,30269,30271,30272,30273,30545,30573,30574,30575,30576,30577,30581,30585,30586,30587,30588,30589,30590,30591,30592,30593,30594,30595,30596,30597,30598,30599,30601,30602,30603,30604,30606,30607,30608,30609,30610,30613,30614,30615,30616,30617,30640,30641,30642,30643,30644,30645,30651,30652,30653,30654,30658,30659,30660,30661,30662,30663,30664,30681,30683,30686,30689,30811,30812,30889,30890,30891,30892,30896,31008,31011,31048,31066,31226,31268,31269,31270,31272,31275,31276,31277,31278,31279,31280,31281,31282,31283,31284,31289,31290,31291,31292,31293,31294,31295,31296,31307,31308,31309,31310,31311,31313,31316,31317,31318,31320,31324,31325,31326,31327,31328,31329,31330,31331,31332,31333,31334,31341,31342,31343,31345,31350,31362,31363,31428,31429,31430,31431,31432,31433,31434,31435,31436,31437,31690,31694,31695,31696,31697,31698,31699,31700,31701,31702,31703,31704,31705,31706,31707,31708,31709,31710,31711,31712,31713,31714,31716,31717,31718,31719,31720,31721,31722,31723,31724,31726,31727,31728,31729,31730,31731,31732,31733,31734,31735,31736,31737,31738,31739,31740,31741,31742,31743,31744,31745,31746,31747,31748,31749,31750,31751,31752,31753,31754,31755,31756,31757,31758,31759,31760,31761,31762,31763,31764,31765,31766,31767,31768,31773,31774,31775,31776,31950,31951,32344,32345,32346,32347,32348,32349,32350,32351,32352,32353,32354,32355,32356,32357,32358,32359,32360,32361,32362,32363,32364,32365,32367,32368,32369,32370,32371,32372,32373,32374,32375,32376,32377,32378,32379,32380,32381,32382,32383,32384,32385,32386,32387,32388,32389,32390,32391,32392,32393,32394,32395,32396,32397,32398,32399,32400,32401,32402,32403,32404,32405,32406,32408,32409,32410,32411,32412,32413,32414,32415,32416,32417,32418,32419,32420,32421,32422,32423,32424,32425,32426,32427,32428,32429,32430,32431,32432,32433,32434,32435,32436,32437,32438,32439,32440,32441,32442,32443,32444,32445,32446,32447,32448,32449,32450,32451,32452,32453,32454,32455,32456,32457,32458,32460,32461,32462,32463,32464,32465,32466,32467,32468,32469,32470,32471,32472,32473,32474,32475,32476,32477,32479,32480,32506,32507,32508,32509,32510,32511,32512,32513,32514,32515,32516,32517,32518,32519,32520,32521,32522,32523,32524,32525,32539,32540,32541,32542,32543,32551,32552,32592,32593,32718,32719,32720,32721,32722,32723,32727,32728,32729,32730,32731,32732,32734,32736,32919,32920,32921,32922,32923,32924,32925,32926,32927,32928,32929,32930,32931,32932,32933,32934,32935,32936,32937,32938,32939,32940,32941,33117,33118,33897,33900,33901,33902,33903,33904,33905,33920,33921,33922,33956,33957,33959,33978,33979,33980,33981,33982,33983,33984,33985,33986,33987,33988,33989,33990,33991,33992,33993,33994,33995,33996,33997,33998,33999,34000,34001,34002,34003,34004,34005,34006,34007,34008,34040,34041,34042,34043,34044,34045,34046,34047,34048,34049,34050,34051,34052,34053,34054,34055,34056,34057,34058,34059,34088,34089,34167,34168,34169,34296,34297,34482,34483,34484,34485,34486,34487,34488,34489,34490,34491,34492,34499,34500,34501,34502,34503,34504,34505,34506,35160,35161,35162,35163,35164,35165,35166,35167,35168,35169,35170,35171,35172,35173,35174,35175,35176,35177,35178,35179,35180,35181,35182,35183,35184,35185,35186,35187,35188,35189,35190,35191,35192,35193,35194,35195,35196,35197,35198,35199,35200,35201,35202,35203,35216,35217,35241,35242,35243,35244,35245,35246,35247,35248,35249,35250,35251,35252,35253,35254,35255,35256,35257,35258,35259,35260,35261,35262,35263,35264,35265,35266,35267,35268,35269,35282,35283,35284,35285,35797,35798,35801,35802,35803,35804,35805,35806,35807,35808,35815,35816,35817,36121,36122,36123,36124,36125,36126,36193,36292,36293,36294,36295,36297,36298,36299,36300,36301,36306,36307,36418,36419,36420,36422,36426,36427,36428,36436,36438,36439,36440,36443,36444,36446,36742,36743,36744,36745,36746,36747,36748,36749,36750,36751,36752,36754,36755,36756,36757,36758,36759,36760,36761,36762,36763,36764,37041,37044,37045,37046,37077,37176,37177,37178,37240,37241,37242,37243,37244,37245,37246,37247,37248,37249,37250,37251,37252,37253,37254,37255,37256,37257,37258,37259,37260,37261,37262,37263,37264,37265,37266,37267,37268,37269,37270,37271,37272,37273,37274,37275,37276,37277,37278,37279,37280,37281,37629,37630,37631,37641,37642,37651,37652,37653,37654,37655,37656,37657,37658,37659,37660,37661,37662,37663,37664,37665,37666,37667,37668,37669,37670,37671,37672,37673,37674,37675,37676,37677,37678,37679,37680,37681,37682,37683,37684,37685,37686,37687,37688,37689,37690,37691,37692,37693,37694,37695,37696,37697,37698,37699,37700,37701,37705,37712,37713,37714,37715,37716,37717,37718,37719,37720,37721,37940,37941,37942,37943,37944,37945,37946,37947,37958,37959,37960,37961,37975,37980,37984,37989,37992,37996,38003,38007,38020,38021,38022,38023,38024,38025,38027,38028,38029,38031,38032,38033,38034,38264,38265,38266,38267,38268,38269,38272,38273,38274,38275,38276,38277,38278,38279,38280,38286,38287,38288,38289,38290,38291,38292,38293,38294,38295,38296,38297,38298,38299,38300,38302,38303,38304,38305,38306,38307,38308,38309,38310,38311,38312,38313,38314,38315,38316,38317,38318,38319,38320,38321,38322,38323,38324,38325,38326,38327,38429,38430,38431,38432,38752,38753,38754,38755,38756,38757,38758,38761,38762,38763,38764,38765,38766,38767,38906,38907,38908,38909,38910,39070,39071,39206,39207,39208,39209,39210,39222,39254,39255,39256,39258,39259,39260,39261,39262,39263,39264,39265,39266,39267,39268,39269,39270,39271,39276,39277,39278,39279,39280,39281,39282,39283,39284,39285,39286,39295,39296,39297,39298,39299,39300,39390,39391,39392,39397,39398,39399,39400,39442,39443,39444,39445,39446,39447,39455,39456,39457,39458,39459,39460,39711,39883,39884,39885,39886,39887,39888,39889,39890,39891,40125,40137,40249,40250,40251,40283,40285,40286,40287,40388,40450,40451,40452,40453,40454,40485,40486,40591,40592,40593,40628,40629,40630,40631,40642,40643,40703,40712,40713,40714,40715,40737,40738,40739,40740,40741,40744,40745,40746,40747,40748,41041,41042,41056,41139,41140,41141,41142,41143,41144,41145,41146,41147,41148,41149,41150,41151,41152,41201,41202,41203,41211,41212,41213,41214,41215,41216,41217,41218,41219,41251,41261,41262,41263,41264,41265,41266,41267,41268,41269,41270,41271,41272,41311,41312,41343,41344,41345,41346,41347,41348,41349,41350,41351,41352,41353,41354,41355,41356,41357,41358,41359,41360,41361,41362,41363,41364,41365,41366,41367,41368,41369,41370,41371,41372,41373,41374,41375,41376,41377,41378,41379,41380,41381,41382,41383,41384,41385,41386,41387,41388,41389,41390,41391,41392,41393,41394,42034,42035,42036,42037,42546,42547,42548,42549,42550,42551,42552,42553,42554,42555,42556,42557,42558,42559,42560,42561,42562,42563,42564,42565,42566,42567,42568,42569,42570,42571,42572,42573,42574,42575,42576,42678,42679,42688,42689,42690,42691,42692,42710,42784,42785,42822,42823,42824,42825,42828,42829,42830,42831,42832,42847,42848,42849,42850,42876,42877,42878,42880,42881,42882,42883,42884,42885,42886,42887,42888,42889,42890,42891,42892,42893,42894,42895,42896,42897,42898,42899,42900,42901,42902,42903,42904,42905,42906,42907,42908,42909,42914,42915,42916,42917,42919,42920,42921,42922,42923,42924,42925,42926,42927,42928,42929,42930,42931,42932,42933,42934,42935,42936,42937,42938,42939,42940,42941,42942,42956,42957,42958,42959,42960,42961,42962,42963,42964,42965,42966,42967,42968,42969,42970,42971,42972,42973,42984,42985,42986,42987,42988,42989,42990,42991,42992,42993,42994,42995,42996,42997,42998,42999,43000,43001,43002,43003,43004,43005,43006,43007,43008,43010,43012,43013,43014,43015,43016,43017,43018,43019,43020,43091,43092,43093,43094,43095,43096,43113,43114,43115,43116,43117,43118,43119,43120,43121,43122,43123,43124,43125,43126,43127,43128,43129,43130,43131,43132,43133,43134,43135,43136,43137,43138,43139,43140,43141,43142,43143,43144,43145,43146,43147,43148,43149,43150,43151,43152,43153,43154,43155,43156,43157,43158,43161,43162,43184,43185,43186,43187,43188,43189,43251,43252,43253,43254,43255,43256,43257,43258,43263,43264,43265,43266,43267,43268,43269,43270,43271,43272,43273,43274,43275,43277,43279,43280,43281,43282,43283,43594,43595,43596,43804,43860,43861,43862,43863,43872,43873,43874,43875,43876,43877,43878,43879,43884,43885,43886,43887,43889,44083,44248,44249,44250,44251,44252,44253,44254,44255,44257,44258,44259,44260,44261,44262,44263,44264,44265,44266,44267,44268,44269,44270,44279,44284,44285,44286,44287,44288,44289,44290,44291,44292,44293,44294,44295,44296,44297,44298,44299,44300,44301,44302,44307,44308,44309,44310,44311,44312,44313,44314,44315,44316,44317,44318,44319,44320,44321,44369,44370,44371,44372,44373,44374,44375,44624,44625,44626,44627,44628,44629,44630,44631,44632,44634,44635,44682,44683,44684,44686,44687,44688,44689,44690,44772,44773,44774,44775,44776,44777,44778,44779,44780,44781,44782,44954,44955,44956,44957,44958,44959,45349,45350,45352,45353,45354,45357,45358,45359,45360,45361,45362,45363,45530,45531,45532,45533,45534,45535,45536,45537,45538,45539,45540,45541,45590,45591,45592,45593,45594,45720,45721,45722,45723,45726,45727,45728,45729,45942,45943,45944,45945,45946,45947,45948,45949,45950,45951,45952,45953,45954,45955,45956,45970,45971,45972,45973,45974,45975,45976,45977,45978,45979,45980,45981,45985,45986,45987,46001,46002,46003,46004,46005,46006,46007,46008,46009,46010,46011,46012,46013,46014,46015,46016,46017,46018,46019,46020,46021,46023,46024,46025,46026,46027,46028,46029,46030,46048,46049,46050,46052,46097,46098,46099,46100,46101,46102,46249,46250,46251,46252,46253,46254,46255,46256,46257,46258,46259,46260,46261,46262,46263,46264,46265,46266,46267,46268,46269,46270,46271,46272,46273,46275,46276,46277,46278,46279,46280,46281,46282,46283,46284,46285,46286,46287,46288,46289,46290,46291,46292,46293,46321,46323,46325,46326,46327,46329,46330,46331,46332,46333,46334,46336,46337,46338,46339,46340,46342,46343,46344,46345,46346,46348,46349,46350,46497,46498,46499,46500,0) ORDER BY pricecon ASC