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(4970674,4970678,4970689,4970690,4970691,4970692,4970693,4970694,4970695,4970696,4970697,4970698,4970724,8067904,8067914,8067915,8067916,8067917,10939101,10939102,10939386,10939387,10939399,10939400,10939401,10939402,10939404,10939419,10939424,10939425,10939426,10939427,10939428,10939433,10931549,10931550,8065818,8065819,8065830,8970177,10620073,10620074,10610984,10610985,10611012,10614048,10611179,10614210,10611242,10611243,10611244,10611245,10611246,10611247,10611248,10611249,10611250,10614255,10614256,10614257,10614258,10614259,10614260,10614261,10614262,10614263,10614264,10614289,10614296,10614297,10614355,10614376,10614411,10614417,10614418,10614419,10614420,10614421,10614422,10614423,10614501,10614595,10614634,10614646,10611759,10611760,10611761,10611762,10611763,10611786,10614857,10611880,10611881,10611882,10611883,10611884,10611885,10614886,10611886,10611887,10611888,10611889,10611890,10611891,10611892,10611893,10611894,10611895,10611896,10611897,10611898,10611899,10611900,10611901,10611902,10611903,10611904,10611905,10611906,10611907,10611908,10611909,10611910,10611911,10611912,10611913,10611914,10611915,10611916,10611917,10611918,10611919,10611920,10611921,10611922,10611923,10611924,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10566084,10611934,10611935,10611936,10611937,10611938,10611939,10611940,10611941,10611942,10611943,10611944,10611945,10611946,10611947,10611948,10611949,10611950,10611951,10611952,10611953,10611981,10612062,10612063,10612064,10612082,10612083,10612084,10612085,10612086,10612109,10612126,10612258,10612259,10612260,10612270,10609277,10609287,10609313,10612344,10609351,10609362,10612381,10609385,10609388,10609389,10609408,10612431,10612432,10609432,10612433,10609433,10612434,10612435,10612436,10612437,10612438,10612439,10612440,10612441,10612442,10612443,10612444,10612445,10612446,10612447,10612448,10612449,10612450,10612451,10612452,10609452,10612453,10612454,10612455,10612456,10612457,10612458,10612459,10612460,10612461,10612462,10612463,10612464,10612465,10612466,10612467,10612468,10612469,10612470,10612471,10612472,10612473,10612474,10612475,10612476,10612477,10612478,10612479,10612480,10612481,10612482,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612494,10612495,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612504,10609505,10612505,10612506,10612507,10612508,10612509,10612510,10612511,10612512,10612513,10612514,10612515,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612533,10612534,10609535,10612535,10612536,10612537,10612538,10612539,10612540,10612541,10612542,10612543,10612544,10612545,10612546,10612547,10612548,10612549,10612550,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612560,10612561,10609562,10612562,10609563,10612563,10612564,10612565,10612566,10612567,10612568,10612569,10612570,10612571,10612572,10612573,10612574,10612575,10612576,10612577,10612578,10612579,10612580,10612581,10612582,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612590,10612591,10612592,10612593,10612594,10612595,10612596,10612597,10612598,10612599,10612600,10612601,10612602,10612603,10612604,10612605,10612606,10612607,10612608,10612609,10612610,10612611,10612612,10612613,10612614,10612615,10612616,10612617,10612618,10612619,10612620,10609621,10612621,10609622,10612622,10612623,10612624,10612625,10612626,10609626,10612627,10612628,10612629,10612630,10612631,10609631,10612632,10609632,10612633,10609633,10612634,10612635,10612636,10612637,10612638,10612639,10612640,10609640,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612649,10612650,10612651,10612652,10612653,10612654,10612655,10612656,10612657,10612658,10612659,10612660,10612661,10612662,10609662,10612663,10609663,10612664,10612665,10612666,10609666,10612667,10609667,10612668,10609668,10612669,10609669,10612670,10612671,10612672,10612673,10609673,10612674,10612675,10612676,10612677,10609677,10612678,10612679,10609679,10612680,10609680,10612681,10612682,10612683,10612684,10612685,10612686,10612687,10612688,10612689,10612690,10612691,10612692,10612693,10612694,10612695,10612696,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612708,10612709,10612710,10612711,10612712,10612713,10612714,10612715,10609715,10612716,10609716,10612717,10612718,10612719,10612720,10612721,10612722,10612723,10612724,10609724,10612725,10612726,10612727,10612728,10612729,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612737,10612738,10612739,10612740,10612741,10612742,10612743,10612744,10612745,10612746,10612747,10612748,10612749,10612750,10612751,10612752,10612753,10612754,10612755,10612756,10612757,10612758,10612759,10612760,10612761,10612762,10612763,10612764,10612765,10612766,10612767,10612768,10612769,10612770,10609770,10612771,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612781,10612782,10612783,10612784,10612785,10612786,10612787,10612788,10612789,10612790,10612791,10612792,10612793,10612794,10612795,10612796,10612797,10612798,10612799,10612800,10612801,10612802,10612803,10612804,10612805,10612806,10612807,10612808,10612809,10612810,10612811,10612812,10612813,10612814,10612815,10612816,10609816,10612817,10612818,10612819,10612820,10612821,10612822,10612823,10612824,10609824,10612825,10612826,10612827,10612828,10612829,10612830,10612831,10612832,10612833,10612834,10609834,10612835,10609835,10612836,10609836,10612837,10612838,10612839,10612840,10612841,10612842,10612843,10612844,10612845,10612846,10612847,10612848,10612849,10612850,10612851,10612852,10612853,10612854,10612855,10612856,10612857,10612858,10612859,10612860,10612861,10612862,10612863,10612864,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612880,10612881,10612882,10612883,10612884,10612885,10612886,10612887,10612888,10612889,10612890,10612891,10612892,10612893,10612894,10612895,10612896,10612897,10612898,10612899,10612900,10612901,10612902,10612903,10612904,10612905,10609905,10612906,10612907,10612908,10612909,10612910,10612911,10612912,10612913,10612914,10612915,10612916,10612945,10612958,10612993,10613025,10610044,10610046,10613079,10613085,10613087,10613088,10610098,10613127,10613193,10610233,10613235,10610298,10610318,10610319,10613322,10610339,10610340,10610348,10610349,10610350,10610351,10613372,10613380,10613440,10613442,10613453,10610492,10610493,10613553,10613634,10613635,10613646,10613654,10610674,10610675,10610676,10613750,10613752,10613804,10613805,10613806,10610822,10610826,10610846,10610851,10610870,10610915,10610916,10610917,10610918,10610919,10610920,10610921,10610922,10610923,10610924,10610925,10610926,10610927,10610928,10610929,10610930,10610931,10610932,10610955,10416253,10419257,10419260,10419261,10416282,10416283,10416284,10416301,10415340,10415344,10416347,10416364,10416365,10419365,10416366,10416367,10416368,10416369,10416370,10416371,10415371,10416372,10416373,10415373,10416374,10415374,10416375,10415375,10416376,10415376,10416377,10416378,10416379,10416380,10416381,10416382,10416383,10415383,10416384,10416385,10416386,10416387,10416388,10416389,10416390,10416391,10416392,10416393,10416394,10416395,10416396,10416397,10416398,10416399,10416400,10416401,10416402,10415402,10416403,10415403,10416404,10415404,10416405,10415405,10416406,10415406,10416407,10415407,10415408,10419439,10415539,10415540,10415541,10415542,10415543,10415546,10415547,10415548,10415552,10415553,10415557,10415563,10415566,10415569,10419570,10415573,10415580,10415583,10415585,10415586,10419605,10419612,10415612,10415615,10419616,10419625,10419635,10419639,10419644,10419649,10419652,10419654,10419657,10419664,10415665,10415687,10415694,10415695,10415696,10415697,10415699,10415701,10415702,10415703,10415704,10415705,10415706,10415707,10415708,10415709,10415710,10415711,10415712,10415713,10415714,10415715,10415716,10415790,10419852,10419853,10419854,10419855,10419856,10419857,10419858,10419859,10419860,10419861,10419862,10419863,10419864,10419865,10419866,10419867,10419868,10419869,10419870,10419871,10419872,10419873,10471104,10471105,10471106,10471107,10471108,10471109,10471110,10471111,10471112,10471113,10471114,10471115,10471116,10471117,10471118,10471119,10471120,10469908,10469909,10469910,10469911,10469912,10469913,10469914,10469915,10469916,10469917,10469918,10469919,10469920,10469921,10469922,10469923,10469924,10469925,10469926,10469927,10469928,10469929,10469930,10469931,10469932,10469933,10469934,10469935,10469936,10469937,10469938,10469939,10469940,10469941,10469942,10469943,10469944,10469945,10469946,10469947,10469948,10469949,10469950,10470624,10470625,10470626,10470627,10470628,10470629,10470630,10470631) 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'