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(10939572,8068841,8068850,8068880,10939614,8068895,10939654,10939722,10943672,4970639,4970640,4970641,4970642,4970643,4970644,4970685,10940101,10940110,10940112,10940152,4970775,10940154,10940159,10940165,10940172,10940175,10940186,10940187,10940188,10940189,10940190,10940191,10940197,10940198,10940199,10940200,4970892,4970927,4970934,10940403,10940404,10940409,4971046,4971047,4971048,10940440,10940441,10940442,10940443,10940444,10944263,10940469,10940470,10940471,10940518,4971145,4971146,4971147,10940527,10940528,8066886,8066890,8066897,8066915,8066919,8066920,4968234,4968328,4968337,4968338,4968360,4968363,4968364,4968365,4968412,4968443,8067221,8067269,8067274,8067292,8067293,8067298,10437194,10437200,10437289,10437290,8067422,10437332,10437333,10437334,10437335,10437336,10437402,10437409,10437433,4968849,4968862,8067629,8067644,8067653,8067680,8067681,8067682,8067689,8067690,10437588,10437594,10437595,10437596,10437600,8067748,4969177,4969303,4969304,4969305,4969306,4969307,4969308,4969309,4969310,4969311,8067960,4969317,4969324,4969325,4969330,4969331,4969332,4969333,4969334,4969335,4969336,4969337,8067997,8067999,8068000,8068001,8068002,8068003,8068004,8068005,8068006,8068007,8068008,8068009,8068010,8068011,8068012,8068050,8068051,8068052,8068053,8068054,8068055,8068056,8068116,8068117,8068118,8068119,8068120,8068121,8068122,8068140,8068141,10938931,8068219,8068222,8068223,8068224,8068225,8068226,8068227,8068228,8068229,8068230,8068231,8068232,8068233,8068234,8068235,8068236,8068237,8068238,8068239,8068240,8068241,8068255,8068288,8068289,8068290,8068293,8068294,8068295,8068296,8068304,8068305,8068308,8068309,10939071,8068343,10939100,10939386,10939395,8074803,8065107,8075272,8065770,8065771,8065772,8065773,8065774,8065775,8065776,8065777,8065778,8065779,8065780,8065973,8065977,8066080,8066124,8066125,8066166,8066222,8066223,8066236,8066237,8066238,8066252,8066253,8066254,8066255,8066256,8066257,8066258,8066259,8066260,8066261,8066262,8066263,8066283,8066284,8066285,8066322,8066323,8066324,8066325,8066326,8066327,8066349,8066350,8066351,8066352,8066382,8066383,8066384,8066385,8066386,8066387,8066403,8066404,8066405,8066406,8066407,8066408,8066409,8066410,8066458,8066485,8066486,8066487,8066488,8066536,8066537,8066538,8066539,8066540,8066541,8066542,8066543,8066544,8066557,8066562,8066563,8066587,8066588,8066606,8066607,8066608,8066609,8066610,8066611,8066612,8066613,8066614,8066615,8066616,8066617,8066618,8066619,8066620,8066621,8066622,8066623,8066624,8066625,8066677,8066678,8066690,8066691,8066712,8066713,8066714,8066715,8066716,8066717,8066718,8066719,8066720,8066721,8066722,8066723,8066724,8066725,8066726,8066727,8066728,8066729,8066730,8066731,8066732,8066733,8066734,8066735,8066736,8066737,8066738,8066739,8066740,8066741,8066742,8066743,8066744,8066745,8066746,8066747,8066748,8066749,8066750,8066751,8066752,8066753,8066754,8066784,8066785,8066786,8066787,8066788,8066796,8066797,8066798,8066799,8066800,8066801,8066802,8066803,8066804,8066805,8066806,8066807,8066808,8066809,8066810,8066811,8066812,8066813,8066814,8066815,8066816,8066817,8066847,8066848,8066861,8066862,8066863,8066864,8066865,8066866,8066867,8066868,8066869,8066870,8066871,8066872,8066873,8066874,8066875,8066876,8066877,8066878,8066879,8066881,8066883,8064764,8064765,8064766,8064767,8064768,3655577,3655585,3655602,3655603,3655604,3655677,3655680,8072314,3656247,3656248,8072427,8072428,8072441,3656302,3656303,8072467,8072468,3656304,3656305,8072469,8072773,8072774,8072775,8072776,8072777,3656626,3656654,8072917,8072918,8072919,8072920,8072921,8072922,8072923,8072924,8072925,8072926,8072927,8072928,8072929,8072930,8072931,8072932,8072933,8072934,3656817,3656835,3656836,3656894,3656895,3656912,3656913,3656920,8073503,10623043,10918569,10918570,10623063,10918623,10918646,10918647,10918648,10918713,10918714,10918715,10623308,10623366,10623457,10623491,10623492,10623493,10623503,10919098,10919099,10919100,10919101,10919102,10919103,10919104,10919105,10919106,10623653,10623654,10919410,10919411,10919412,10919413,10919761,10919762,10919763,10919887,10919888,10919889,10919890,10919933,10919934,10624731,10624732,10920371,10920372,10920373,10920374,10920375,10920376,10920377,10920378,10920379,10920380,10920381,10920382,10920383,10920384,10920385,10920386,10920387,10920388,10920389,10920390,10920391,10621978,10621992,10622093,10917613,10917614,10917615,10917616,10917617,10917618,10917619,10917620,10917621,10917622,10917623,10917624,10917625,10622122,10917852,10917853,10917854,10917855,10622438,10917984,10622506,10622507,10622508,10622509,10622510,10622511,10622512,10622513,10622517,10918090,10918091,10918092,10622880,10622889,10622911,10918437,10918438,10619980,10620048,10620055,10620096,10620180,10620181,10620182,10620183,10620219,10620220,10620344,10620345,10620365,10620669,10916569,10916570,10916571,10916572,10916573,10916574,10916575,10916576,10916577,10916578,10916579,10916580,10916581,10916582,10916583,10916584,10916585,10916586,10916587,10916588,10916589,10916590,10916591,10916592,10916593,10916594,10916595,10916596,10916597,10916598,10916599,10916600,10916601,10916602,10916603,10916604,10916605,10916606,10916607,10916608,10916609,10916610,10916611,10916612,10916613,10916614,10916615,10916616,10916617,10916618,10916619,10916620,10916621,10916622,10916623,10916624,10916625,10916626,10916627,10916628,10916629,10916630,10916631,10916632,10916633,10916634,10916635,10621125,10916636,10916637,10916638,10916639,10621133,10621135,10621155,10621156,10621157,10621158,10621159,10621164,10621251,10621252,10621253,10621254,10621255,10621256,10621257,10621258,10621259,10621260,10621261,10621300,10621342,10621349,10621350,10621352,10621353,10621354,10621355,10621356,10621371,10621372,10621380,10621411,10621427,10621438,10621454,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621498,10621505,10621506,10621509,10621515,10621564,10621570,10621578,10621579,10621586,10621626,10621627,10621628,10621642,10621644,10621666,10621683,10621684,10621685,10621686,10621687,10621696,10621698,10621699,10621700,10621713,10621720,10621726,10621735,10621736,10621737,10621738,10621739,10621740,10621741,10917337,10917338,10917339,10917340,10611025,10565223,10565259,10611140,10611149,10611150,10565315,10565323,10611175,10611254,10611652,10611682,10611693,10611785,10566066,10611942,10609132,10609283,10609286,10609308,10609316,10609322,10609382,10609383,10609384,10563602,10609709,10609714,10609839,10609855,10609939,10609940,10609941,10609942,10610024,10610067,10610269,10610333,10610334,10610350,10610418,10610437,10610463,10564639,10564659,10564770,10564771,10564772,10564773,10564830,10610747,10610784,10610862,10610868,10555124,10555125,10555126,10555127,10555128,10555129,10555130,10555131,10517273,10517274,10517275,10517276,10517287,10517288,10517541,10517542,10517543,10517569,10517570,10517571,10517572,10517593,10517669,10517672,10517676,10555717,10555718,10555719,10555720,10555721,10555903,10555904,10555905,10555906,10555907,10555908,10556395,10556396,10556397,10556398,10556399,10556400,10556480,10518980,10419330,10419331,10419350,10415381,10419417,10415487,10415515,10415516,10415517,10419575,10419584,10419587,10419588,10419589,10419590,10415600,10415601,10415606,10415607,10415634,10419741,10419744,10415744,10415745,10415746,10415747,10415748,10415749,10415750,10415751,10415752,10415753,10415754,10415755,10415756,10415757,10415758,10415759,10415760,10415761,10415762,10415763,10415764,10415765,10415766,10415767,10415768,10415769,10415770,10415771,10415772,10415773,10415774,10415775,10415776,10415777,10415778,10415779,10415780,10415781,10415787,10415788,10415791,10415792,10419807,10415835,10419841,10419842,10419843,10419917,10419918,10419919,10419920,10419921,10419922,10419923,10415925,10415967,10415980,10415989,10416065,10416066,10420095,10420096,10420097,10420098,10416113,10420122,10420123,10420124,10420134,10420186,10420199,10420200,10420201,10420202,10463011,10463035,10463060,10471214,10463360,10463361,10463362,10463402,10463430,10471491,10471492,10471528,10471566,10463653,10463655,10463736,10463765,10463766,10463786,10463787,10463797,10463827,10463828,10463829,10463830,10469912,10469916,10469919,10469921,10470081,10470095,10470125,8563546,10462314,10462315,10470426,10470427,10470428,10462459,10462460,10462461,10462478,10462479,10462480,10462481,10462495,10462496,10462497,10462514,10462521,10462522,10462540,10462541,10462542,10462543,10470551,10470552,10470553,10470554,10462583,10462585,10470611,10462623,10462624,10462626,10462631,10470674) 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'