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(4970579,4970580,4970636,4970637,4970638,4970668,4970669,4970679,4970738,4970767,4970825,4970845,4970846,4970847,4970848,4970849,4970850,4970851,4970858,4970873,4970874,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970921,4970922,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970971,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970992,4970993,4971022,4971023,4971024,4971025,4971028,4971030,4971031,4971032,4971033,4971053,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971070,4971071,4971072,4971085,4971086,4971087,4971088,4971089,4971110,4971111,4971147,4968189,4968268,4968312,4968313,4968314,4968369,4968477,4968478,4968479,4968480,4968481,4968482,4968483,4968484,4968485,4968486,4968487,4968488,4968489,4968490,4968491,4968492,4968493,4968494,4968608,4968619,4968620,4968621,4968626,4968627,4968636,4968637,4968655,4968681,4968888,4968898,4968899,4968900,4968901,4969177,4969178,4969179,4969180,4969181,4969182,4969183,4969207,4969208,4969237,4969238,4969252,4969253,4969254,4969255,4969256,4969257,4969258,4969259,4969260,4969261,4969262,4969263,4969264,4969265,4969266,4969267,4969268,4969269,4969282,4969283,4969284,4969285,4969286,4969287,4969288,4969294,4969295,4969371,4969372,4969373,4969374,4969375,4969376,4969377,4969378,4969379,4969380,4969381,4969493,4969494,4969495,4969496,4969497,4969498,4969499,4969500,4969501,4969502,4969503,4969504,4969505,4969506,4969507,4969508,4969509,4969510,4969511,4969512,4969513,4969514,4969515,4969516,4969517,4969518,4969519,4969520,4969521,4969522,4969523,4969524,4969547,4969614,4969632,4969633,4969634,4969635,4969636,4969637,4969638,4969642,4969643,4969644,4969645,4969646,4969647,4969648,4969649,4969650,4969651,4969652,4969653,4969665,4969666,4969667,4969668,4969669,4969673,4969674,4969675,4969676,4969677,4969678,4969679,4969680,4969681,4969682,4969683,4969684,4969685,4969686,4969687,4969688,4969689,4969696,4969697,4969698,4969699,4969700,4969701,4969702,4969703,4969704,4969705,4969706,4969707,4969708,4969709,4969710,4969711,4969712,4969713,4969714,4969715,4969716,4969717,4969718,4969719,4969755,4969756,4969757,4969758,4969759,4969760,4969761,4969762,4969763,4969764,4969765,4969775,4969776,4969777,4969778,4969779,4969780,4969781,4969782,4969783,4969784,4969785,4969786,4969787,4969788,4969789,4969790,4969791,4969792,4969793,4969802,4969803,4969804,4969805,4969806,4969807,4969818,4969819,4969820,4969821,4969822,4969823,4969824,4969825,4969826,4969827,4969828,4969829,4969830,4969831,4969832,4969833,4969834,4969835,4969878,4969879,4969880,4969881,4969882,4969883,4969906,4969907,4969908,4969909,4970016,4970020,4970057,4970058,4970119,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8075225,8075227,8075228,8075229,8075230,8075231,8075288,8075312,8075344,8075345,8075364,8075365,8075478,8075479,8075480,8075482,8075483,8075484,8075487,8075489,8075495,8075498,8075502,8075506,8075513,8075514,8075518,8075520,4967027,4967028,4967030,4967031,4967034,4967048,4967049,4967050,4967051,4967052,4967053,4967078,4967081,4967100,4967107,4967148,4967149,4967150,4967151,4967152,4967153,4967154,4967155,4967156,4967157,4967158,4967159,4967160,4967162,4967166,4967168,4967171,4967177,4967178,4967180,4967201,4967211,4967219,4967221,4967225,4967233,4967236,4967238,4967239,4967240,4967248,4967259,4967265,4967266,4967271,4967289,4967299,4967301,4967302,4967305,4967309,4967313,4967318,4967322,4967329,4967336,4967343,4967346,4967348,4967349,4967353,4967355,4967356,4967357,4967365,4967371,4967372,4967373,4967378,4967379,4967384,4967385,4967390,4967394,4967395,4967406,4967414,4967429,4967432,4967433,4967435,4967446,4967447,4967475,4967478,4967550,4967553,4967555,4967560,4967566,4967567,4967568,4967569,4967570,4967571,4967577,4967580,4967587,4967588,4967592,4967594,4967597,4967599,4967600,4967608,4967611,4967615,4967622,4967625,4967628,4967633,4967635,4967639,4967643,4967647,4967655,4967661,4967671,4967674,4967681,4967688,4967690,4967692,4967701,4967703,4967708,4967712,4967713,4967716,4967717,4967722,4967729,4967736,4967743,4967744,4967745,4967746,4967747,4967750,4967752,4967753,4967768,4967777,4967778,4967804,4967913,4967936,4967947,4967955,4967996,4968004,4968005,4968006,4968010,4968012,4968017,4968020,4968022,4968026,4968029,8073670,8073671,8073672,8073673,8073674,8073675,8073676,8073677,8073678,8073679,8073680,8073681,8073682,8073683,8073684,8073685,8073686,8073687,8073688,8073689,8073690,8073691,8073692,8073693,8073694,8073695,8073696,8073697,8073698,8073699,8073700,8073701,8073702,8073703,8073704,8073705,8073706,8073707,8073708,8073709,8073710,8073711,8073712,8073713,8073714,8073715,8073716,8073717,8073718,8073719,8073720,8073721,8073722,8073723,8073724,8073725,8073726,8073727,8073728,8073729,8073730,8073731,8073732,8073733,8073734,8073735,8073736,8073737,8073738,8073739,8073740,8073741,8073742,8073743,8073744,8073745,8073746,8073747,8073748,8073749,8073750,8073751,8073752,8073753,8073754,8073755,8074037,8074038,8074039,8074040,8074041,8074042,8074043,8074044,8074045,8074046,8074047,8074048,8074049,8074050,8074051,8074052,8074053,8074054,8074055,8074056,8074057,8074058,8074081,8074082,8074083,8074084,8074085,8074086,8074087,8074088,8074089,8074090,8074091,8074092,8074093,8074094,8074095,8074096,8074097,8074098,8074099,8074100,8074101,8074596,8074597,8074598,8074599,8074600,8074601,8074602,8074603,8074604,8074605,8074606,8074607,8074608,8074609,8074610,8074611,8074612,8074613,8074614,8074615,8074616,8074617,8074618,8074619,8074620,8074621,8074622,8074623,8074624,8074625,8074626,8074627,8074628,8074629,8074630,8074631,8074632,8074633,8074634,8074635,8074636,8074637,8074638,8074639,8074640,8074641,8074642,8074643,8074644,8074645,8074646,8074647,8074648,8074649,8074650,8074651,8074652,8074653,8074654,8074655,8074656,8074657,8074658,8074659,8074660,8074661,8074662,8074663,8074664,8074665,8074666,8074667,8074668,8074669,8072582,8072583,8072590,8072591,8072592,8072593,8072594,8072635,8072643,8072644,8072645,8072646,8072647,8072648,8072649,8072650,8072651,8072652,8072653,8072654,8072655,8072656,8072657,8072658,8072659,8072660,8072661,8072662,8072663,8072664,8072665,8072666,8072667,8072668,8072669,8072670,8072671,8072672,8072673,8072674,8072675,8072676,8072677,8072678,8072679,8072680,8072681,8072682,8072683,8072684,8072685,8072686,8072687,8072688,8072689,8072690,8072691,8072692,8072693,8072694,8072695,8072696,8072697,8072706,8072711,8072726,8072731,8072751,8072771,8072776,8072801,8072802,8072803,8072804,8072805,8072806,8072807,8072808,8072820,8072821,8072822,8072823,8072824,8072836,8072837,8072838,8072839,8072840,8073021,8073024,8073025,8073026,8073027,8073028,8073079,8073080,8073091,8073092,8073093,8073094,8073097,8073099,8073107,8073114,8073124,8073129,8073341,8073344,8073348,8073353,8073498,8073499,8073500,8073507,8073508,8073509,8073510,8073546,8073553,8073554,8073555,8073556,8073557,8073558,8073559,8073560,8073561,8073562,8073563,8073564,8073565,8073566,8073567,8073568,8073569,8073570,8073571,8073572,8073573,8073574,8073575,8073576,8073577,8073578,8073579,8073580,8073581,8073582,8073583,8073584,8073585,8073586,8073587,8073588,8073589,8073590,8073591,8073592,8073593,8073594,8073595,8073596,8073597,8073598,8073599,8073600,8073601,8073602,8073603,8073604,8073605,8073606,8073607,8073608,8073609,8073610,8073611,8073612,8073613,8073614,8073615,8073616,8073617,8073618,8073619,8073620,8073621,8073622,8073623,8073624,8073625,8073626,8073627,8073628,8073629,8073630,8073631,8073632,8073633,8073634,8073635,8073636,8073637,8073638,8073639,8073640,8073641,8073642,8073643,8073644,8073645,8073646) 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'