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(10943807,10943808,10943809,10943810,10943811,10943812,10943813,10943814,10943815,10943816,10943817,10943818,10943819,10943820,10943821,10943822,10943823,10943824,10943825,10943826,10943827,10943828,10943829,10943830,10943831,10943832,10943833,10943834,8569477,10437148,10437149,10437150,10437151,10437152,10437153,10437154,10437155,10437156,10437157,10437158,10437159,10437160,10437161,10437162,10437163,4968646,4968647,4968648,4968649,4968650,4968651,4968652,4968653,10938881,10938882,10938883,10938884,10938885,10962244,10931316,10931317,10931318,10931319,10931320,10931321,10931322,10931323,10931324,10931325,10931326,10931327,10931328,10931329,10931330,10931331,10931332,10931333,10931334,10931335,10931336,10931337,10931338,10931339,10931340,10931341,10931342,10931343,10931344,10931345,10931346,10931347,10931348,10931349,10931350,10931351,10931352,10931353,10931354,10931355,10931356,10931357,10931358,10931359,10931360,10931361,10931362,10931363,10931364,10931365,10931366,10931367,10931368,10931369,10931370,10931371,10931372,10931373,7064901,7064902,7064903,7064904,7064905,7064906,7064907,7064908,7064909,7064910,7064911,7064912,7064913,7064914,7064915,7064916,7064917,7064918,7064919,7064920,7064921,7064922,7064923,7064924,7064925,7064926,7064927,7064928,7064929,7064930,7064931,7064932,7064933,7064934,7064935,7064936,7064937,7064938,7064939,7064940,7064941,7064942,7064943,7064944,7064945,7064946,7064947,7064948,7064949,7064950,7064951,7064952,7064953,7064954,7064955,7064956,7064957,7064958,7064959,7064960,7064961,7064962,7064963,7064964,7064965,7064966,7064967,7064968,7064969,7064970,7064971,7064972,7064973,11047879,11047880,11047881,11047882,11047883,11047884,11047885,11047886,11047887,11047888,11047889,11047890,11047891,11047892,11047893,11047894,11047895,11047896,11047897,11047898,11047899,11047900,11047901,11047902,11047903,11047904,11047905,11047906,11047907,11047908,11047909,11047910,11047911,11047912,11047913,11047914,11047915,11047916,11047917,11047918,11047919,11047920,11047921,11047922,11047923,11047924,11047925,11047926,11047927,11047928,11047929,11047930,11047931,11047932,11047933,11047934,11047935,11047936,11047937,11047938,11047939,11047940,11047941,11047942,11047943,11047944,11047945,11047946,11047947,11047948,11047949,11047950,11047951,11047952,11047953,11047954,11047955,11047956,11047957,11047958,11047959,11047960,11047961,11047962,11047963,11047964,11047965,11047966,11047967,11047968,11047969,11047970,11047971,11047972,11047973,11047974,11047975,11047976,11047977,11047978,11047979,11047980,11047981,11047982,11047983,11047984,11047985,11047986,11047987,11047988,11047989,11047990,11047991,11047992,11047993,11047994,11047995,11047996,11047997,8070356,8070357,8070358,8070359,8070360,8070361,8070362,8070363,8070364,8070365,8070366,8070367,8070368,8070369,8070370,8070371,8070372,8070373,8070374,8070375,8070376,8070377,8070378,8070379,8070380,8070381,8070382,8070383,8070384,8070385,8070386,8070387,8070388,8070389,8070390,8070391,8070392,8070393,8070394,8070395,8070396,8070397,8070398,8070399,8070400,8070401,8070402,8070403,8070404,8070405,8070406,8070407,8070408,8070409,8070410,8070411,8070412,8070413,8070414,8070415,8070416,8070417,8070418,8070419,8070420,8070421,8070422,8070423,8070424,8070425,8070426,8070427,8070428,8070429,8070430,8070431,8070432,8070433,8070434,8070435,8070436,8070437,8070438,8070439,8070440,8070441,8070442,8070443,8070444,8070445,8070446,8070447,8070448,8070449,8070450,8070451,8070452,8070453,8070454,8070455,8070456,8070457,8070458,8070459,8070460,8070461,8070462,8070463,8070464,8070465,8070466,8070467,8070468,8070469,8070470,8070471,8070472,8070473,8070474,8070475,8070476,8070477,8070478,8070479,8070480,8070481,8070482,8070483,8070484,8070485,8070486,8070487,8070488,8070489,8070490,8070491,8070492,8070493,8070494,8070495,10955658,10955659,10955660,10955661,10955662,10955663,10955664,10955665,10955666,10955667,10955668,10955669,10955670,10955671,10955672,10955673,10955674,10955675,10955676,10955677,10955678,10955679,10955680,10955681,10955682,10955683,10955684,10955685,10955686,10955687,10955688,10955689,10955690,10955691,10955692,10955693,10955694,10955695,10955696,10955697,10955698,10955699,10955700,10955701,10955702,10955703,10955704,10955705,10955706,10955707,10955708,10955709,10955710,10955711,10955712,10955713,10955714,10955715,10955716,10955717,10955718,10955719,10955720,10955721,10955722,10955723,10955724,10955725,10955726,10955727,10955728,10955729,10955730,10955731,10955732,10955733,10955734,10955735,10955736,10955737,10955738,10955739,10955740,10955741,10955742,10955743,10955744,10955745,10955746,10955747,10955748,10955749,10955750,10955751,10955752,10955753,10955754,10955755,10955756,10955757,10955758,10955759,10955760,10955761,10955762,10955763,10955764,10955765,10955766,10955767,10955768,10955769,10955770,10955771,10955772,10955773,10955774,10955775,10955776,10955777,10955778,10955779,10955780,10955781,10955782,10955783,10955784,10955785,10955786,10955787,10955788,10955789,10955790,10955791,10955792,10955793,10955794,10955795,10955796,10955797,10955798,10955799,10955800,10955801,10955802,10955803,10955804,10955805,10955806,10955807,10955808,10955809,10955810,10955811,10955812,10955813,10955814,10955815,10955816,10955817,10955818,10955819,10955820,10955821,10955822,10955823,10955824,10955825,10955826,10955827,10955828,10955829,10955830,10955831,10955832,10955833,10955834,10955835,10955836,10955837,10955838,10955839,10955840,10955841,10955842,10955843,10955844,10955845,10955846,10955847,10955848,10955849,10955850,10955851,10955852,10955853,10955854,10955855,10955856,10955857,10955858,10955859,10955860,10955861,10955862,10955863,10955864,10955865,10955866,10955867,10955868,10955869,10955870,10955871,10955872,10955873,10955874,10955875,10955876,10955877,10955878,10955879,10955880,10955881,10955882,10955883,10955884,10955885,10955886,10955887,10955888,10955889,10955890,10955891,10955892,10955893,10955894,10955895,10955896,10955897,10955898,10955899,10955900,10955901,10955902,10955903,10955904,10955905,10955906,10955907,10955908,10955909,10955910,10955911,10955912,10955913,10955914,10955915,10955916,10955917,10955918,10955919,10955920,10955921,10955922,10955923,10955924,10955925,10955926,10955927,10955928,10955929,10955930,10955931,10955932,10955933,10955934,10955935,10955936,10955937,10955938,10955939,10955940,10955941,10955942,10955943,10955944,10955945,10955946,10955947,10955948,10955949,10955950,10955951,10955952,10955953,10955954,10955955,10955956,10955957,10955958,10955959,10955960,10955961,10955962,10955963,10955964,10955965,10955966,10955967,10955968,10955969,10955970,10955971,10955972,10955973,10955974,10955975,10955976,10955977,10955978,10955979,10955980,10955981,10955982,10955983,10955984,10955985,10955986,10955987,10955988,10955989,10955990,10955991,10955992,10955993,10955994,10955995,10955996,10955997,10955998,6665913,6665914,6665915,6665916,6665917,7057821,7057822,7057823,7055092,7055093,7055094,7055095,7055096,7055097,7055098,7055099,7055100,7055101,7055102,7055103,7055104,7055105,7055106,7055107,7055108,7055109,7055110,7055111,7055112,7055113,7055114,7055115,7055116,7055117,7055118,7055119,7055120,8916545,8916546,8916547,8916548,8916549,8916550,8916551,8916552,8916553,8916554,8916555,8916556,8916557,8916558,8916559,8916560,8916561,10471800,10471801,10471802,10471803,10471804,10471805,10471806,10471807,10471808,10471809,10471810,10471811,10471812,10471813,10471814,10471815,10471816,10471817,10471818,10471819,10471820,10471821,10471822,10471823,10471824,10471825,10471826,10471827,10471828,10471829,10471830,10471831,10471832,10471833,10471834,10471835,10471836,10471837,10471838,10471839,10471840,10471841,10471842,10471843,10471844,10471845,10471846,10471847,10471848,10471849,10471850,10471851,10471852,10471853,10471854,10471855,10471856,10471857,10471858,10471859,10471860,10471861,10471862,10471863,10471864,10471865,10471866,10471867,10471868,10471869,10471870,10471871,10471872,10471873,10471874,10471875,10471876,10471877,10471878,10471879,10471880,10471881,10471882,10471883,10471884,10471885,10471886,10471887,10471888,10471889,10471890,10471891,10471892,10471893,10471894,10471895,10471896,10471897,10471898,10471899,10471900,10471901,10471902,10471903,10471904,10471905,10471906,10471907,10471908,10471909,10471910,10471911,10471912,10471913,10471914,10471915,10471916,10471917,10471918,10471919,10471920,10471921,10471922,10471923,10471924,10471925,10471926,10471927,10471928,10471929,10471930,10471931,10471932,10471933,10471934,10471935,10471936,10471937,10471938,10471939,10471940,10471941,10471942,10471943,10471944,10471945,10471946,10471947,10471948,10471949,10471950,10471951,10471952,10471953,10471954,10471955) 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'