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(10939537,7067824,7067838,7067892,7067893,7067894,7067895,7067896,7067897,7067898,7067899,7067900,7067901,7067902,10939617,7067903,10939618,10939628,10939677,10939694,10943493,10939700,10939703,10939772,7068072,10939792,10939796,10939822,10943628,10939848,10939868,10939882,10939907,10939908,10939914,10939915,10939916,10943842,4970670,4970671,4970675,10940061,4970731,4970732,4970733,4970734,4970738,4970775,10940293,4971081,10940507,10940524,7065830,7065831,7065832,7065833,7065834,7065835,7065836,7065837,7065838,7065839,10437050,10437068,7066178,8067275,8067286,8067292,7066265,7066266,4968613,4968614,4968622,4968623,4968624,4968625,4968631,8067368,8067369,8067396,7066348,7066375,7066378,7066379,7066381,10437331,7066453,10437503,10437522,8067757,7066766,10437751,10437753,7066825,10437774,7066836,10938787,10938791,10938792,10938794,10938795,10938797,7067102,10938832,10938842,7067134,10938854,10938881,7067196,7067298,10939126,7067425,7067452,7067697,10939439,10939465,10939467,10939492,10939495,10939503,10939511,7067801,7067815,7064355,7064587,7064592,7064733,7064735,7064736,7064747,7064748,7064751,7064754,8065823,7064756,7064760,7064761,7064771,7064822,7064856,7064863,7064878,8065953,8065954,8065955,8065956,8065957,8065958,7064892,7064911,7064912,7064926,7064932,7064935,7064947,7064977,7064983,7064984,7064985,7064986,7065004,7065421,7065457,7065750,10942534,10942535,10942598,10942600,10942666,10942671,10942692,10942693,10942710,10942712,10942714,10942715,10942734,10942735,10942737,10942743,10942745,10942793,10942799,10942804,10942812,10942817,10942861,10942913,10942992,10942994,10943018,10943019,10943026,10943044,10943045,10943048,10943113,10943122,10943248,10943256,10943270,10943290,10943304,10943308,10943309,10943342,10943419,10940578,10940580,10944411,10944412,3655603,3655604,10940633,10944447,10940741,10940742,10940783,10940883,10944725,10944726,10944727,10944728,10944729,10944730,10944731,10944732,10944733,10944734,10944735,10944736,10940969,10940993,10940998,10941002,10941103,10941128,10941161,10941163,10941195,10941226,10941262,10941278,10941285,10941296,10945101,10941383,10941389,10941391,10941400,10941477,10941512,10941589,10941636,10941651,10941682,10941745,10941749,10941791,10941929,10941948,3656933,10941961,10941969,10941979,10942106,10942201,10942205,10942210,10942213,10942218,10942219,10942222,8860412,10942228,10942229,10942286,10942304,10942325,10942343,10942344,10942346,10942347,10942348,10942350,10942357,10942358,10942361,10942366,10942367,10942385,10942390,10942395,10942401,10942410,10942435,10942448,10942455,10942477,10942489,10623490,10624632,10624633,10622257,10622365,10922895,10922896,10922899,10922900,10622402,10622428,10922949,10622441,10622445,10928007,10928008,10928009,10928010,10928011,10622533,10928301,10928302,10928303,10620117,10620118,10620208,10620297,10620298,10620301,10620302,10620303,10925981,10620559,10621034,10926651,10926652,10926653,10926654,10927259,10927260,10927261,10927262,10610963,10610964,10610965,10610969,10610971,10610975,10610976,10610977,10610978,10610980,10610982,10610984,10610985,10610987,10610988,10610989,10610994,10610995,10610996,10610997,10565150,10614009,10614054,10614057,10614064,10614182,10565349,10614257,10614269,10565478,10614376,10611376,10611378,10611381,10611382,10611383,10611390,10611391,10611392,10611393,10611394,10611398,10611400,10611404,10611406,10611409,10611411,10611412,10611422,10611423,10611426,10611428,10611434,10611435,10611436,10611437,10611441,10611444,10611449,10611457,10611459,10611461,10611462,10611463,10611466,10611467,10611469,10611473,10611476,10611479,10611480,10611482,10611486,10611492,10611493,10611495,10614495,10565646,10614496,10614497,10565647,10614498,10614499,10611500,10614500,10614501,10614502,10614503,10614504,10614505,10611507,10611514,10614519,10614520,10611520,10614521,10611521,10611522,10614522,10614523,10611525,10611526,10611527,10611528,10611530,10611532,10611536,10611537,10611538,10611542,10611544,10611546,10614548,10611549,10611551,10611552,10611554,10611560,10611563,10611564,10611567,10611569,10611572,10611574,10611577,10611578,10611580,10611581,10611583,10611584,10611588,10611589,10611598,10611600,10611603,10611604,10611605,10611608,10611611,10611612,10611613,10611615,10611618,10611619,10611621,10611623,10611635,10611636,10611637,10611638,10611640,10611646,10611647,10611648,10611649,10611655,10611658,10611659,10611660,10611731,10611778,10611782,10611789,10611804,10611856,10611954,10611957,10611969,10611970,10611983,10611995,10611996,10611997,10612060,10612086,10612104,10612105,10612106,10612107,10612131,10612134,10612135,10612136,10612137,10609155,10612268,10612291,10612292,10612293,10612294,10612295,10612319,10609355,10609369,10612381,10609844,10612909,10612916,10612935,10612936,10612937,10612938,10612939,10612940,10612941,10612942,10612943,10609950,10612959,10612961,10609988,10610015,10610026,10610030,10610060,10610075,10613096,10610097,10613097,10613098,10613099,10613102,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613111,10613112,10613113,10613114,10613115,10613116,10613117,10613135,10613136,10613137,10613144,10613192,10613208,10613215,10610292,10613350,10613369,10613393,10613406,10613421,10613431,10613432,10610434,10613434,10610435,10613435,10610449,10613475,10610479,10610480,10610481,10610482,10613483,10613498,10613501,10613504,10613505,10613506,10613513,10613514,10613515,10564666,10564669,10613523,10613524,10613525,10613527,10613531,10613545,10610666,10613695,10610697,10613722,10610729,10610730,10564883,10613736,10613737,10613738,10610739,10613739,10613740,10613750,10613760,10564973,10610850,10613858,10613859,10613860,10565037,10565038,10565039,10610890,10565040,10610901,10610913,10610914,10610947,10610954,10610958,10517614,10517615,10517616,10517617,10517618,10517670,10512530,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10512782,10415232,10415251,10416284,10419307,10415342,10416348,10416349,10416350,10416351,10416352,10416353,10416354,10416355,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10415370,10419370,10415372,10419468,10419469,10419470,10419471,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10416481,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419493,10419494,10419495,10419496,10419497,10419498,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419530,10419535,10419537,10419538,10415575,10415576,10415585,10415586,10415614,10415685,10419810,10419966,10419971,10419983,10420052,10417053,10417054,10417055,10417056,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417077,10417078,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10420149,10417150,10420150,10417151,10420151,10417152,10420152,10417153,10420153,10420154,10417155,10420155,10417156,10420156,10417157,10420157,10417158,10420158,10417159,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10420167,10420168,10420169,10420170,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420200,10420201,10420202,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,8563250,8563251,8563252,10469949,10469950,8563299) 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'