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(3228965,3228966,10976475,10976476,7066008,8583494,8067910,8067913,3227533,3227536,3227538,3227544,8573612,7201443,7201444,10960071,10960072,7201769,7201770,7201771,7201772,7201773,7201774,7201899,7201902,7202024,7202026,7202029,7202030,7202033,7202034,7202036,7202054,7202318,7202319,7202329,7202619,7202676,8910048,8910049,8616856,7200454,7200455,7200472,7200473,7200474,7200501,7200669,7200753,7200755,7200756,10959209,8910590,8910591,7200784,8910598,7200881,7200885,7200887,7200901,7200904,7201035,7201036,7201037,7201038,7201039,10931197,7198391,7198402,7198408,7198409,7198411,7198412,7198413,7198415,7198416,7198417,7198418,7198419,7198457,7198458,7198459,7198460,7198461,7198462,7198463,7198464,7198465,7198708,7198726,7198741,7198745,7198751,7198756,7198759,7198771,7198773,7198833,7199062,7199065,7199388,7199389,7199390,7199490,7199491,7199546,11048437,10958376,10618178,10618179,10618180,10618181,10618325,7196739,10623605,10623606,10623700,8906858,8906871,8906872,10981517,7197243,7197244,7197578,7197748,7197754,7197758,7197759,7197762,7197948,7197954,7197976,7197984,7197988,7197989,7197990,7197991,7197992,7197993,7197994,7197995,7197996,7198000,7198001,7198007,7198024,7198031,7198044,7198052,7198101,7198102,7198103,7198104,7198105,7198115,7198116,7198117,7198118,7198119,7198120,7198121,10617057,10617068,10617072,10617114,10617135,10617145,10617146,10617158,10617169,10617170,10617171,10617172,10622258,10622264,10622265,10622266,8905298,10622267,10622268,10622272,10953985,10953987,10953988,10953990,10953991,10953992,8905365,10953994,10622360,8905393,8905394,10954022,8905395,8905396,10954023,10954024,8905397,8905401,8905402,8905403,8905404,8905405,8905406,8905407,8905408,8905409,8905410,8905411,8905412,8905413,8905414,8905415,8905421,10622405,10622408,10622431,10622447,10617509,10622514,10622516,10622523,10954195,10954196,10954197,10954199,10954200,10615014,10425394,10615077,10615079,10615389,10615509,10615510,10615511,10615512,10615513,10615514,10615515,10615516,10615536,10615540,10615545,10615581,10620654,10615746,10848536,10615821,10615897,10615898,10426253,10615923,10615925,10615926,10615927,10426269,10615931,10426271,10426272,10615941,10615943,10615944,10615945,10615947,10615967,10615981,10615983,10615984,10615985,10615987,10615990,10616089,10616092,10616301,8611321,10616577,10616704,10427108,10616840,10616841,10616842,10616888,10616890,10616891,10616911,10616913,10616932,10611107,10611179,10614230,10611232,10714130,10714137,10614355,10614376,10614377,10614463,10614464,10614518,10614537,10614555,10614565,10614572,10614588,10614592,10559766,10614632,10611699,10611700,10611701,10611702,10611705,10611706,10611707,10611785,10611788,10611800,10611801,10611802,10611812,10611819,10611821,10611823,10611826,10611827,10611828,10611829,10611842,10611854,10611857,10614858,10614859,10614862,10611863,10611878,10611879,8549450,10611963,10611964,10611968,10611972,10611973,10611976,10611977,10611981,10611982,10611989,10611992,10612008,10612010,10612060,10612069,10612103,10612171,10612174,10612175,10612176,10612189,10612190,10612191,10612192,10612193,10612194,10612195,10612196,10612197,10612198,10612199,10612200,10612201,10612202,10612203,10612204,10612205,10612214,10612225,10612233,10612283,10612284,10612285,10612286,10612342,10609393,10612407,10612408,10612409,10612410,10612411,10612412,10612414,10612424,10612426,10612427,10612428,10612429,10612430,10612483,10612484,10612485,10612486,10612487,10612488,10612489,10612490,10612491,10612492,10612493,10612496,10612497,10612498,10612499,10612500,10612501,10612502,10612503,10612505,10612506,10612507,10612508,10612509,10612510,10612513,10612516,10612517,10612518,10612519,10612520,10612521,10612522,10612523,10612524,10612525,10612526,10612527,10612528,10612529,10612530,10612531,10612532,10612534,10612535,10612536,10612538,10612539,10612542,10612546,10612547,10612551,10612552,10612553,10612554,10612555,10612556,10612557,10612558,10612559,10612562,10612563,10612565,10612566,10612567,10612568,10612570,10612571,10612573,10612575,10612577,10612578,10612583,10612584,10612585,10612586,10612587,10612588,10612589,10612592,10612594,10612596,10612597,10612599,10612600,10612601,10612602,10612603,10612604,10612605,10612606,10612607,10612608,10612609,10612610,10612611,10612612,10612613,10612614,10612615,10612616,10612617,10612618,10612619,10612620,10612622,10612623,10612624,10612625,10612626,10612633,10612635,10612637,10612638,10612639,10612640,10612641,10612642,10612643,10612644,10612645,10612646,10612647,10612648,10612650,10612651,8862510,10612652,10612653,10612655,10612657,10612658,10612659,10612660,10612661,10612663,10612664,10612666,10612667,10612668,10612673,10612675,10612677,10612678,10612679,10612680,10612682,10612683,10612684,10612685,10612687,10612688,10612689,10612690,10612697,10612698,10612699,10612700,10612701,10612702,10612703,10612704,10612705,10612706,10612707,10612711,10612713,10612714,10612715,10612716,10612717,10612718,10612720,10612721,10612722,10612723,10612753,10612757,10612791,10612792,10609818,10609819,10612824,10609826,10609828,10612833,10612834,10612836,10612837,10612838,10612839,10612840,10612841,10612842,10612843,10612844,10612846,10612847,10612850,10612852,10612853,10612856,10612860,10612862,10612863,10612865,10612866,10612867,10612868,10612869,10612870,10612871,10612872,10612873,10612874,10612875,10612876,10612877,10612878,10612879,10612881,10612882,10612884,10612886,10612888,10612898,10612935,10612936,10612937,10612938,10612939,10612941,10612942,10612943,10612951,7058472,10609975,10609976,10609978,10609979,10609981,10612984,10609999,10613019,10613023,10613027,10613119,10613120,10613168,10610174,10610270,10610271,10610272,10610279,10610280,10610282,10610285,10610289,10610293,10610295,10610296,10610299,10610318,10610319,10613349,10610359,10610362,10610364,10610371,10610372,10610373,10610466,10610476,10613654,10613693,10613719,10610793,10610795,10610823,10610824,10610825,10610832,10610833,10610834,10610836,10610927,10610937,10610939,10610940,10610941,7055490,7055491,9169377,9169526,9169527,9169528,10117788,10117791,10117857,10117863,10117865,9169709,10117907,10117908,10117909,10117910,10117911,10117912,10117913,10117920,10117924,10117925,10117926,10117927,10117928,10117929,10118397,10118403,10118455,10118646,9168330,9168331,10419258,9168351,10418276,10418278,10418280,10419307,10415323,10415324,9168415,9168416,9168417,9168418,9168419,9168420,9168421,9168422,9168423,9168424,9168425,9168447,9168448,9168449,9168450,9168451,10417374,9168452,10417376,10415377,10417378,9168458,9168459,10419394,10419395,10419396,10417424,10419427,10419428,10419429,10419430,10419431,10419432,10419433,10419434,10419435,10419436,10417462,10417463,10417464,10116828,10419593,10416610,10416611,10416613,10416617,10416619,10417642,9168720,9168721,10416652,9168758,10117034,9168878,10418864,9169270,10419202,10419210,10419211,10419212,10419213,10419214,10419215,10419216,10419217,10419218,10419219,10419220,10468876,10467240,8549927,8550031,10467466,8550183,8550184,8550316,9167502,10470107,10470108,10470109,10466247,10468249,9167783,9167784,9167785,9167786,10468364,10468436,10468447,10468448,10468449,10468450,10468451,10468452,10468453,10468454,10468455,10468456,10468457,10468458,10468473,10468474,10468475,10468476,10468477,10468478,10468479,10468498,10468499,10468500,10468501,10468502,10468503,10468504,9167952,10468800,10468801,10468802,10468803,10468806,10468807,10468808,10468809,10468810,10468811,10468812,10468813,10468814,10468815,10468816,10468852,10468853,10468854,10468855,10468856,10468857,10468859,10468860,10468862,10468863,10468864,10468865,10468866,10468869,10468870,10468871,10468872,10468874,10468875,10888555,10888561,10888563,10888564,10888568,10888655,10883670,10889036,10170104,10884446,10884574,10884579,10884593,10884612,10884620,10884624,10884625,10884626,10884632,10884633,10884644,10884688,10884692,10884693,10884695,10884696,10884698,10884705,10884706,10884738,10889798,10884881,10884882,10884883,10884884,10884885,10884886,10884887,10884928,10884929,10884930,10884933,10884944,10884945,10884946,10884947,10884948,10884949,10884950,10884951,10874951,10884952,10884953,10884954,10884955,10884956,10884957,10884958,10884959,10884960,10884961,10884962,10884963,10884964,10884965,10884966,10884968,10884969,10884970,10884971,10884972,10884973,10884974,10884975,10884976,10884977,10884978,10885018,10890100,10890101,10890201,10890202,10890203,10885357,10887525,10164088,10888081,10888107,10883143,10883176,10883186,10883187,10627773,10888316,10883318,10888319,10883319,10888322,10627930,10883455,10885502,10885507,10885531,10161662,10161931,10161969,10161970,10161972,10161974,10162173,10162174,10162175,10949008,10949013,10877102,10877125,10877126,10877127,10882426,10882432,10882433,10582561,10488183,10494358,10477681) 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'