QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(10939946,10939947,10939948,10939949,10939950,10939951,10939952,10939953,10939954,10939955,10939956,10939957,10939958,10939959,10939960,10939961,10939962,10939963,10939964,10939965,10939966,10939967,10939968,10939969,10939970,10939971,10939972,10939973,10939974,10939975,10939976,10939977,10939978,10939979,10939980,10939981,10939982,10939983,10939984,10939985,10939986,10939987,10939988,10939989,10939990,10939991,10939992,10939993,10939994,10939995,10939996,10939997,10939998,10939999,10940000,10940001,8569735,8569736,8569737,8569738,8569739,8066138,8066139,10969500,10969501,10969502,10969503,10969504,10969505,10969506,10969507,10969508,10969509,10969510,10969511,10969512,10969513,10969514,10969515,10969516,10969517,10969518,10969519,10969520,10969521,10969522,10969523,10969524,10969525,10969526,10969527,10969528,10969529,10969530,10969531,10969532,10969533,10969534,10969535,10969536,10969537,10969538,10969539,10969540,10969541,10969542,10969543,10969544,10969545,10969546,10969547,10969548,10969549,10969550,10969551,10969552,10969553,10969554,10969555,10969556,10969557,10969558,10969559,10969560,10969561,10969562,10969563,10969564,10969565,10969566,10969567,10969568,10969569,10969570,10969571,10969572,10969573,10969574,10969575,10969576,10969577,10969578,10969579,10969580,10969581,10969582,10969583,10969584,10969585,10969586,10969587,10969588,10969589,10969590,10969591,10969592,10969593,10969594,10969595,10969596,10969597,10969598,10969599,10969600,10969601,10969602,10969603,10969604,10969605,10969606,10969607,10969608,10969609,10969610,10969611,10969612,10969613,10969614,10969615,10969616,10969617,10969618,10969619,10969620,10969621,10969622,10944450,10969623,10969624,10944451,10969625,10969626,10969627,10969628,10969629,10969630,10969631,10969632,10969633,10969634,10969635,10969636,10969637,10969638,10969639,10969640,10969641,10969642,10969643,10969644,10969645,10969646,10969647,10969648,10969649,10969650,10969651,10969652,10969653,10969654,10969655,10969656,10969657,10969658,10969659,10969660,10969661,10969662,10969663,10969664,10969665,10969666,10969667,10969668,10969669,10969670,10969671,10969672,10969673,10969674,10969675,10969676,10969677,10969678,10969679,10969680,10969681,10969682,10969683,10969684,10969685,10969686,10969687,10969688,10969689,10969690,10969691,10969692,10969693,10969694,10969695,10969696,10969697,10969698,10969699,10969700,10969701,10969702,10969703,10969704,10969705,10969706,10969707,10969708,10969709,10969710,10969711,10969712,10969713,10969714,10969715,10969716,10969717,10969718,10969719,10969720,10969721,10969722,10969723,10969724,10969725,10969726,10969727,10969728,10969729,10969730,10969731,10969732,10969733,10969734,10969735,10969736,10969737,10969738,10969739,10969740,10969741,10969742,10969743,10969744,10969745,10969746,10969747,10969748,10969749,10969750,10969751,10969752,10969753,10969754,10969755,10969756,10969757,10969758,10969759,10969760,10969761,10969762,10969763,10969764,10969765,10969766,10969767,10969768,10969769,10969770,10969771,10969772,10969773,10969774,10969775,10969776,10969777,10969778,10969779,10969780,10969781,10969782,10969783,10969784,10969785,10969786,10969787,10969788,10969789,10969790,10969791,10969792,10969793,10969794,10969795,10969796,10969797,10969798,10969799,10969800,10969801,10969802,10969803,10969804,10969805,10969806,10969807,10969808,10969809,10969810,10969811,10969812,10969813,10969814,10969815,10969816,10969817,10969818,10969819,10969820,10969821,10969822,10969823,10969824,10969825,10969826,10969827,10969828,10969829,10969830,10969831,10969832,10969833,10969834,10969835,10969836,10969837,10969838,10969839,10969840,10969841,10969842,10969843,10969844,10969845,10969846,10969847,10969848,10969849,10969850,10969851,10969852,10969853,10969854,10969855,10969856,10969857,10969858,10969859,10969860,10969861,10969862,10969863,10969864,10969865,10969866,10969867,10969868,10969869,10969870,10969871,10969872,10969873,10969874,10969875,10969876,10969877,10969878,10969879,10969880,10969881,10969882,10969883,10969884,10969885,10969886,10969887,10969888,10969889,10969890,10969891,10969892,10969893,10969894,10969895,10969896,10969897,10969898,10969899,10969900,10969901,10969902,10969903,10969904,10969905,10969906,10969907,10969908,10969909,10969910,10969911,10969912,10969913,10969914,10969915,10969916,10969917,10969918,10969919,10969920,10969921,10969922,10969923,10969924,10969925,10969926,10969927,10969928,10969929,10969930,10969931,10969932,10969933,10969934,10969935,10969936,10969937,10969938,10969939,10969940,10969941,10969942,10969943,10969944,10969945,10969946,10969947,10969948,10969949,10969950,10969951,10969952,10969953,10969954,10969955,10969956,10969957,10969958,10969959,10969960,10969961,10969962,10969963,10969964,10969965,10969966,10969967,10969968,10969969,10969970,10969971,10969972,10969973,10969974,10969975,10969976,10969977,10969978,10969979,10969980,10969981,10969982,10969983,10969984,10969985,10969986,10969987,10969988,10969989,10969990,10969991,10969992,10969993,10969994,10969995,10969996,10969997,10969998,10969999,10970000,10970001,10970002,10970003,10970004,10970005,10970006,10970007,10970008,10970009,10970010,10970011,10970012,10970013,10970014,10970015,10970016,10970017,10970018,10970019,10970020,10970021,10970022,10970023,10970024,10970025,10970026,10970027,10970028,10970029,10970030,10970031,10970032,10970033,10970034,10970035,10970036,10970037,10970038,10970039,10970040,10970041,10970042,10970043,10970044,10970045,10970046,10970047,10970048,10970049,10970050,10970051,10970052,10970053,10970054,10970055,10970056,10970057,10970058,10970059,10970060,10970061,10970062,10970063,10970064,10970065,10970066,10970067,10970068,10970069,10970070,10970071,10970072,10970073,10970074,10970075,10970076,10970077,10970078,10970079,10970080,10970081,10970082,10970083,10970084,10970085,10970086,10970087,10970088,10970089,10970090,10970091,10970092,10970093,10970094,10970095,10970096,10970097,10970098,10970099,10970100,10970101,10970102,10970103,10970104,10970105,10970106,10970107,10970108,10970109,10970110,10970111,10970112,10970113,10970114,10970115,10970116,10970117,10970118,10970119,10970120,10970121,10970122,10970123,10970124,10970125,10970126,10970127,10970128,10970129,10970130,10970131,10970132,10970133,10970134,10970135,10970136,10970137,10970138,10970139,10970140,10970141,10970142,10970143,10970144,10970145,10970146,10970147,10970148,10970149,10970150,10970151,10970152,10970153,10970154,10970155,10970156,10970157,10970158,10970159,10970160,10970161,10970162,10970163,10970164,10970165,10620297,10620298,10620299,10620300,10620301,10620302,10620303,10620304,10620305,10620306,10620307,10620308,10930725,10611394,10611579,8863102,8863103,8863104,8863105,8863106,8863107,8863108,8863109,8863110,8863111,8863112,8863113,8863114,8863115,8863116,8863117,8863118,8863119,8863120,8863121,8863122,8863123,8863124,8863125,8863126,8863127,8863128,8863129,8863130,8863131,8863132,8863133,8863134,8863135,8863136,8863137,8863138,8863139,8863140,8863141,8863142,8863143,8863144,8863145,8863146,8863147,8863148,8863149,8863150,8863151,8863152,8863153,8863154,8863155,8863156,8863157,8863158,8863159,8863160,8863161,8863162,8863163,8863164,8863165,8863166,8863167,8863168,8863169,8863170,8863171,2809331,2809332,10416935,10416936,10416937,10416938,10416939,4971466,4971467,4971468,4971469,4971470,4971471,4971472,4971473,4971474,4971475,4971476,4971477,4971478,4971479,4971480,4971481,4971482,4971483,4971484,4971485,4971486,4971487,4971488,4971489,4971490,4971491,4971492,4971493,4971494,4971495,4971496,4971497,4971498,4971499,4971500,4971501,4971502,4971503,4971504,4971505,4971506,4971507,4971508,4971509,4971510,4971511,4971512,4971513,4971514,4971515,4971516,4971517,4971518,4971519,4971520,4971521,4971522,4971523,4971524,4971525,4971526,4971527,4971528,4971529,4971530,4971531,4971532,4971533,4971534,4971535,4971536,4971537,4971538,4971539,4971540,4971541,4971542,4971543,4971544,4971545,4971546,4971547,4971548,4971549,4971550,4971551,4971552,4971553,4971554,4971555,4971556,4971557,4971558,4971559,4971560,4971561,4971562,4971563,4971564,4971565,4971566,4971567,4971568,4971569,4971570,4971571,4971572,4971573,4971574,4971575,4971576,4971577,4971578,4971579,4971580,4971581,4971582,4971583,4971584,4971585,4971586,4971587,4971588,4971589,4971590,4971591,4971592,4971593,4971594,4971595,4971596,4971597,4971598,4971599,4971600,4971601,4971602,4971603,4971604,4971605,4971606,4971607,4971608,4971609,4971610,4971611,4971612,4971613,4971614,4971615,4971616,4971617,4971618,4971619,4971620,4971621,4971622,4971623,4971624,4971625,4971626,4971627,4971628,4971629,4971630,4971631,4971632,4971633,4971634,4971635,4971636,4971637,4971638,4971639,4971640,4971641,4971642) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'