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(4970707,3228908,4970713,3228965,3228966,8569558,3229038,10950371,3229182,3229207,7065953,10950720,10950746,7066130,7066131,7066132,7066154,3230230,3227390,3227393,8573247,8573263,8573334,8573612,7201253,7201267,7201269,7201354,7201368,7201520,7201521,7201522,7201523,7201524,7201525,7201573,7201622,7201769,7201770,7201771,7201772,7201773,7201774,7201844,7201975,7201976,10960474,8065812,8065813,8065833,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,7202581,7065339,7202596,7202676,7202689,7202690,10933041,3227179,3227180,3227207,8910063,8910064,8910065,8910066,8910067,8910068,8910069,8616856,8910080,7200281,7200282,7200283,7200462,7200501,7200607,7200608,8910466,7200669,8910651,11037316,11049533,7200901,10100083,10100116,7198289,7198340,7198347,7198467,7198502,8908416,8908417,8908418,8908419,8908420,8908421,8908424,8908426,8908427,8908429,7198618,8908430,8908431,8908432,8908433,8908435,8908436,8908437,8908438,8908439,7198664,7198677,7198679,7198684,7198687,7198688,7198690,7198694,7198703,7198708,7198712,7198713,7198723,7198725,7198726,7198730,7198731,7198732,7198736,7198741,7198742,7198743,7198744,7198745,7198751,7198753,7198754,7198755,7198756,7198759,7198764,7198765,7198766,7198771,7198773,7198774,7198775,7198833,7198858,7198891,7199416,7199449,7199480,7199546,10101494,10101524,11048305,10958361,10958368,10958370,7200030,7200155,10618178,10618179,10618180,10618181,10618300,10618301,10623505,7196739,8906755,8906756,8906772,8906773,8906774,8906775,8906776,8906777,8906779,8906780,8906781,8906829,8906833,8906928,8906929,8906930,8906931,8906932,8906934,8906935,8906938,8906939,8906940,8906943,8906944,8906947,8906948,8906949,10838801,10838807,11007777,11007778,10838854,7197439,7197578,7197608,7197619,7197621,7197630,7197633,7197635,7197636,7197639,7197640,7197641,7197644,7197649,7197651,7197654,7197657,7197660,7197661,7197663,7197664,7197667,7197668,7197671,7197672,7197674,7197676,7197679,7197681,7197682,7197984,8907806,7197997,7197998,7198038,7198045,7198051,7198052,8907923,10616967,10616968,10616969,10616978,10617021,10617022,10617068,10617072,10617115,10617162,10617163,10617169,10617170,10622266,10622267,10617319,8905354,8905355,8905356,8905357,8905358,8905359,8905360,8905361,8905362,8905363,8905364,10622406,8905439,8905441,8905502,10622525,8905641,8905660,8905714,8905852,10614962,10614963,10614964,10614965,10425351,10615073,10620195,10620196,10620197,10620198,10620199,10620201,10620202,10615232,10615335,10615389,10615468,10615469,10615509,10615519,10615571,10615577,10615581,10615822,10426214,10426215,10426216,10426217,10426253,10615971,10615972,10615979,10615980,10426356,10426364,10426365,10426402,10616089,10616092,10616175,8611324,8611334,8611335,8611380,10616594,10616633,10616634,10616644,10616655,10616676,10616681,10616704,10616724,10616725,8904798,10616842,8904915,8904916,10616888,10616911,10616913,10610994,10611105,10611126,10611203,10611228,10614259,10714114,10714119,10714120,10614314,10714130,10714140,10714150,10611354,10614355,10614357,10614376,10714195,10614463,10614464,10614476,10611476,10611477,10614486,10614499,10614518,10614555,10614588,10614592,10614593,10559766,10614632,10614647,10614649,10614650,10614651,10614652,10614663,10614664,10614665,10614666,10614667,10611684,10611709,10611711,10611714,9166051,10611764,10611778,10611788,10611801,10611802,10611838,10611839,10611840,10611841,10611842,10611856,10614858,10614859,10614862,10614944,10614945,10614946,10614947,10614948,8549450,10614961,10611974,10611975,10611976,10611977,10611978,10611979,10611980,10611981,10611982,10611983,10611984,10611985,10611986,10611987,10611988,10611989,10611990,10611991,10611992,10611993,10611994,10611995,10611996,10611997,10611998,10611999,10612000,10612001,10612002,10612003,10612004,10612012,10612069,10612082,10612083,10119650,10612232,10612233,10612320,10612321,10612350,10612374,10609393,10612408,10612409,10612410,10612411,10612417,10612419,10612420,10612422,10612506,10612555,10612556,10612557,10612558,10612620,10609626,10612628,10612629,10612630,10612631,10612632,10612633,10612634,8862510,8862530,8862531,10612697,10612699,10612700,10612701,10612702,10612703,10612725,10612746,10612755,10612757,10612763,10612765,10612766,10612767,10609772,10612782,10609818,10609819,10612825,10609826,10612826,10612886,10612888,10612893,10612894,10612895,10612896,10612897,10612898,10612909,10612916,10612948,10612951,10612970,10609975,10609976,10609999,10613019,10610026,10610030,10610067,10613120,10613121,10610132,10613168,10613173,10613219,10613223,10613235,10613237,10613262,10610268,10610271,10613278,10613279,10610289,10610317,10613318,10610318,10610319,10610320,10613337,10613346,10613347,10613348,10613349,10613358,10613371,10613373,10610397,10610417,10613434,10613435,10613466,10610466,10613570,10613571,10613629,10613646,10613654,10613658,10613659,10613660,10613662,10613663,10613664,10613665,10613666,10613667,10613670,10613671,10613672,10613673,10613674,10613680,10613681,10613682,10613683,10613684,10613685,10613686,10613687,10613688,10613689,10613690,10610691,10613691,10613692,10613693,10613694,10610695,10610696,10613700,10613706,10613707,10613708,10613709,10613710,10613711,10613713,10613714,10613716,10613717,10613719,10613730,10613731,10613734,10613735,10613741,10610836,10610842,10610847,10610850,10610918,10610921,10610922,10610924,10610927,10610958,7055491,7055492,7055493,7055494,9169377,10117656,10117657,10117658,10117659,10117660,10117661,10117662,10117663,10117664,9169520,10515335,9169571,10117787,10117788,9169636,10117862,10117863,7015376,7015377,7015378,7015379,7015380,7015381,7015382,7015383,7015384,7015385,7015386,7015387,9169773,9169775,9169804,10118043,9169868,10118068,10118095,10118096,10118098,10118099,10118124,10118125,10118139,10118145,10118263,10118299,10118300,10118301,10118654,9178477,10417257,10419258,10416258,10417260,9168349,9168351,9168352,10416276,10416277,10416278,10416279,9168363,9168368,10419294,10416362,10416363,9168467,10417398,10417399,10417400,10417401,10417402,10417405,10417406,10417407,10417408,9160490,10116695,10417532,10416574,10416593,10416594,10416595,10416596,10416597,10416598,10416599,10416600,10416601,10416602,10416603,10416604,10416605,10416606,10416607,10416608,9168686,10416638,10416639,10415701,9168797,9168857,9168871,9168873,9168874,9168876,9168878,10417811,10417812,10417814,10417816,10417818,10417820,10417822,10417824,10417826,10417828,10417830,10417832,10417834,9168914,10417837,10417839,10417841,10417843,10417845,10417847,10417849,10417850,9168928,10417852,9168930,9168931,10417854,9168932,10417856,10417858,10417860,10417862,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,9168956,9168957,10417881,10417883,9168961,9168962,10417885,9168963,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10418990,10418992,9169270,10419207,7055452,10419208,7055453,10419209,9182441,10471054,10471065,10471066,10469108,10471114,10471117,10469151,10469152,10469153,10469154,10469155,10469156,10469157,10469264,8549927,8550002,8550003,8550018,8550031,8550126,8550128,8550145,8550146,8550147,10469663,8550252,10469679,10469680,10465754,10465755,10465756,9167297,9167901,10468543,10468544,10468545,10468546,10468547,9168021,10470721,10470722,10468735,10470805,10883495,10184510,10184511,10184512,10184520,10184528,10883604,10184624,10184625,10184635,10628152,10628153,10883677,10883934,10883935,10883936,10883937,10883938,10883947,10883948,10883949,10884446,10884447,10884579,10884620,10884630,10884631,10884632,10884633,10884634,10884635,10884636,10884637,10884638,10884639,10884687,10884688,10884694,10884701,10884750,10884751,10884752,10879846,10879847,10879879,10879906,10879909,10879917,10884933,10874951,10875062,10885064,10885077,10880247,10885257,10880306,10880307,10885328,10885465,10885468,10885469,10631994,10632010,10632011,10632012,10632013,10632018,10882951,10883143,10883212,10883220,10627712,10883226,10627776,10883370,10883371,10883372,10883373,10883374,10883375,10883376,10883377,10883381,10883392,10883397,10883398,10883431,10883455,10161957,10161958,10161975,10162049,10162050,10162127,10162128,10162129,10162130,10881994,10881999,10877088,10877089,10882428,10882429,10882432,10882433,10521871,10521872,10521873,10425195,10425200,10425204,10425209,10477141,10494358,10494359,10494376,10477681,10490992,10491052,10491127,10474381,10474395,10474396,10474397,10474434,10472581,10474587,10474588) 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'