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(10939611,8068887,4970290,4970340,10939810,10940066,10940075,4970677,4970684,10940264,4971024,4971025,4971092,4971093,8066954,8066979,10437041,8067185,4968488,8067431,8067461,8067465,8067518,8067636,10437550,10938596,8067868,4969265,4969266,4969267,4969268,4969269,10938714,10938722,10938776,10939079,10939083,10939119,10939469,8065123,10931630,10931740,8065804,8065879,8065920,8065959,8065960,8065963,8065966,8065967,8065968,8065970,8065971,8065972,8065975,8065992,8065993,8065995,8065996,8065997,8065998,8065999,8066000,8066001,8066002,8066003,8066004,8066005,8066033,8066034,8066035,8066036,8066037,8066038,8066039,8066052,4967448,4967449,4967577,4967767,10933055,10933056,10942630,10942640,10942661,10942678,8064266,8064267,8064268,8064289,8064290,10943155,10943227,10943418,10943421,8064809,8064841,10931211,3655810,3655812,3655982,3655989,3655990,3656033,3656048,3656049,3656088,3656094,3656101,3656144,3656154,3656174,10941374,10941480,10941634,10941706,10941710,3656717,10941786,10941854,10941855,10941856,10941858,3656837,3656838,3656839,3656844,10942019,10942266,11049568,10942510,10923616,10923620,10923621,10918653,10918656,10918661,10918665,10918667,10918675,10918677,10918681,10918687,10918688,10918689,10918693,10918773,10918825,10918827,10918845,10918857,10918868,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,10918884,10918886,10918887,10918888,10918889,10918924,10918929,10918930,10918931,10918932,10918933,10918934,10918935,10918936,10918937,10918938,10918939,10918940,10918941,10918942,10918943,10918944,10918945,10918946,10918947,10918948,10918949,10918950,10918951,10918959,10918967,10918968,10918969,10918970,10919017,10919018,10919030,10919062,10919063,10919064,10919065,10919066,10919067,10919068,10919069,10919070,10919071,10919072,10919073,10919074,10919075,10919095,10919096,10919130,10919131,10919132,10919133,10919134,10919135,10919136,10919137,10919138,10919139,10919140,10919141,10919142,10919143,10919144,10919145,10919146,10919177,10919180,10924223,10924224,10924226,10924237,10924241,10924242,10924247,10623825,10624229,10919945,10919952,10919953,10919958,10919959,10919961,10919969,10919970,10919991,10919992,10919993,10919994,10919995,10919996,10919997,10919998,10919999,10920004,10920005,10920007,10920008,10920009,10920010,10920011,10920015,10624512,10920027,10920030,10920031,10920040,10920041,10920042,10920043,10920044,10920045,10920050,10920051,10920052,10920053,10920056,10920057,10920058,10920059,10920060,10920061,10920066,10920067,10920068,10920074,10920076,10920090,10920097,10920098,10920099,10920100,10920101,10920102,10920111,10920112,10920113,10920133,10920134,10920135,10920136,10920137,10920145,10920158,10920163,10920164,10920165,10920175,10920179,10920183,10920186,10920187,10920188,10920189,10920190,10920197,10920198,10920204,10920208,10920217,10920218,10920251,10920254,10920255,10920274,10920275,10920276,10920277,10920282,10920285,10920299,10920300,10920301,10920302,10920303,10920304,10920305,10920306,10920308,10920309,10920323,10920329,10920330,10920331,10920332,10920333,10920334,10920335,10920336,10920338,10920347,10920352,10920354,10920360,10920365,10920366,10920367,10920369,10920376,10920379,10920392,10920394,10920395,10920401,10920402,10920404,10920408,10920409,10920411,10920416,10920418,10920419,10920420,10920421,10920422,10920423,10920424,10920425,10920426,10920427,10920428,10920429,10920430,10920431,10920432,10920433,10920434,10920435,10920436,10920437,10920438,10920439,10920440,10920441,10920442,10920443,10920444,10920445,10920446,10920447,10920448,10920449,10920450,10920451,10920452,10920453,10920454,10920455,10920469,10922475,10922476,10622020,10922547,10622093,10622108,10622110,10922711,10922712,10922713,10922896,10922928,10922929,10922948,10922974,10922975,10922976,10922977,10922978,10922979,10922997,10922998,10922999,10918007,10923009,10923010,10923011,10923012,10923013,10918015,10918027,10918029,10918038,10918039,10918040,10918041,10918042,10918043,10918052,10918061,10918067,10918075,10918076,10918077,10918078,10918079,10918080,10918093,10918100,10918101,10918102,10918103,10918104,10918105,10918106,10918107,10918108,10918109,10915477,10915502,10915507,10915508,10915509,10915510,10915511,10915512,10915513,10915516,10915562,10915563,10915564,10915565,10915566,10915567,10915568,10915569,10915570,10915571,10915572,10915573,10915574,10915575,10915576,10915578,10915592,10915599,10915605,10915647,10915649,10915667,10915670,10915671,10915672,10915673,10915674,10915675,10620165,10915676,10915677,10915678,10915679,10915680,10915681,10915682,10915683,10915684,10915685,10915686,10915687,10915688,10915689,10915690,10915691,10915692,10915693,10915694,10915695,10915696,10915697,10915698,10915701,10915702,10915703,10915704,10915709,10915719,10915722,10915729,10915730,10915732,10915734,10915744,10915745,10915751,10915752,10915753,10915754,10915761,10915772,10915773,10915774,10915775,10915776,10915777,10915870,10915871,10915872,10915873,10915874,10915876,10915883,10915893,10915895,10915896,10915897,10915917,10915931,10915932,10915939,10915940,10915941,10915942,10915943,10915944,10915945,10915946,10915947,10915948,10915949,10915950,10915951,10915952,10915953,10915954,10915955,10915956,10915957,10915958,10915959,10915960,10915970,10915981,10915997,10915998,10916015,10916065,10916072,10916073,10916074,10916075,10916076,10916077,10916078,10916079,10916080,10916081,10916082,10916083,10916094,10916095,10620586,10916096,10620587,10916097,10620588,10916098,10916099,10916137,10916154,10916189,10916197,10916205,10916206,10916207,10916208,10916209,10916210,10916211,10916212,10916213,10916214,10916215,10916216,10916217,10916218,10916236,10916237,10916238,10916242,10916243,10916244,10916245,10916246,10916247,10916248,10916249,10916250,10916251,10916252,10916261,10916262,10916263,10916264,10916265,10916266,10916267,10916268,10916269,10916270,10916271,10916279,10916280,10916281,10916282,10916304,10916305,10916306,10916307,10916308,10916309,10916317,10916318,10916319,10916320,10916321,10916322,10916323,10916324,10916325,10916331,10916338,10916340,10916341,10916344,10916345,10916346,10916347,10916348,10916349,10916350,10916351,10916361,10916362,10916363,10916364,10916365,10916366,10916378,10916379,10916380,10916381,10916382,10916383,10916384,10916385,10916386,10916387,10916389,10916390,10916391,10916392,10916394,10916408,10916415,10916421,10916422,10916423,10916424,10916425,10916426,10916427,10916428,10916452,10916457,10916460,10916463,10916478,10916479,10916484,10916485,10916486,10916489,10916490,10916515,10916516,10916521,10916524,10916557,10916558,10916559,10916560,10916561,10916562,10916563,10916564,10916568,10916572,10916575,10916580,10916589,10916599,10916600,10916601,10916602,10916603,10916604,10916605,10916606,10916607,10916622,10916636,10916650,10916682,10916686,10916687,10916688,10916689,10916707,10916708,10916709,10916723,10916726,10916727,10916728,10916729,10916730,10916731,10916732,10916733,10916734,10916735,10916736,10916737,10916738,10916739,10916740,10916741,10916742,10916743,10916744,10916745,10916746,10916747,10916748,10916749,10916750,10916751,10916752,10916753,10916754,10916755,10916756,10916757,10916758,10916759,10916760,10916761,10916762,10916763,10916764,10916765,10916766,10916767,10916768,10916769,10916770,10916771,10916772,10916773,10916774,10916775,10916776,10916777,10916778,10916779,10916780,10916781,10916782,10916783,10916784,10916785,10916786,10916787,10916788,10916789,10916790,10916791,10916792,10916793,10916794,10916795,10916796,10916797,10916798,10916799,10916800,10916801,10916802,10916803,10916804,10916805,10916806,10916807,10916808,10916809,10916810,10916811,10916812,10916813,10916814,10916815,10916816,10916817,10916818,10916819,10916820,10916821,10916822,10916823,10916824,10916825,10916826,10916827,10916828,10916860,10916861,10916862,10916863,10916864,10916865,10916866,10916867,10916868,10916869,10916870,10916871,10916872,10916873,10916874,10916875,10916876,10916891,10916899,10916912,10916913,10916914,10916915,10916916,10916917,10916918,10916919,10916920,10916921,10916926,10916936,10916956,10916957,10916958,10916959,10916960,10916961,10916962,10916963,10916964,10916965,10916966,10916970,10917000,10917002,10917004,10621536,10917066,10917196,10917264,10917286,10917303,10917318,10917326,10917388,10565129,10565304,10565305,10565329,10565330,10611242,10611245,10611394,10611579,10611680,10611682,10611703,10609001,10609240,10609327,10609375,10563528,10563573,10609475,10609504,10563694,10563698,10563700,10609717,10609851,10609877,10609878,10609953,10610049,10610070,10610075,10610178,10610180,10610181,10610182,10564460,10610343,10610478,10517552,10518776,10518779,10419318,10415436,10419539,10419540,10419541,10419542,10419564,10419565,10419566,10419567,10419620,10419646,10419647,10419648,10419649,10419650,10415676,10415678,10462933,10471005,10469931,8563481,10462299,10462301,10462365,10462368,10470793) 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'