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(10939621,10939622,10962770,10939710,10962771,10962772,10962773,10962774,10962775,10962776,10962777,10962778,10962779,10962780,10962781,10962782,10962783,10962784,10962785,10962786,10962787,10962788,10963302,10963303,7065950,7065951,7065968,10437204,7066570,7066571,10964461,10964462,7074817,7074818,7074819,7074820,10964530,7066847,10964531,10964532,10964533,10964534,10964535,10964536,10964537,10938484,7067214,7067215,6000219,7072215,10960065,10931853,7072643,7072644,7072645,8065959,8065976,7073025,7073026,8066006,8066014,10961472,10961473,4968060,10933197,7073881,10961600,8063956,7070999,7071000,7071001,7071002,10958955,10958956,10958957,10958958,10958964,10959089,10959090,10959091,11049398,10959188,10959210,10943186,10985558,7069219,11048543,10958381,7070882,7070883,7070884,10928584,10918748,10918749,10918750,10918784,10918785,10928821,10968080,10968081,10968082,10618426,10618427,10618428,10618429,10618430,10618431,10618432,10618433,10618434,10618435,10618436,10618437,10618438,10618439,10618440,10618441,10618442,10618818,10618819,8070923,8070924,10619300,10619301,10619302,10619327,10619334,10619375,10619954,10619955,10619956,10619957,10619958,10927480,10922638,10922639,10966863,10617322,10927929,10967584,10967585,10954619,10620021,10620022,10620023,10620024,10620025,10620026,10620027,10620043,10620063,10620064,10620090,10620091,10920606,10920683,10615355,10920893,10920894,10920895,10920896,10920897,10920898,10920899,10926037,10926038,10926039,10926040,10926041,10926042,10926043,10926044,10926045,8570486,10965550,10930861,10921603,10921631,10616217,10966057,10966058,10966204,10966205,10966206,10966207,10966208,10966209,10966210,10966211,10966212,10966213,10966214,10966215,10966216,10966217,10966336,10966337,10966338,10966339,10966340,10966341,10966342,10966343,10966344,10966345,10966346,10966347,10966348,10616706,10966538,10966539,10966540,10966541,10966542,10611379,10611382,10611389,10611390,10611391,10611393,10611394,10611396,10611400,10611407,10611409,10611411,10611412,10611413,10611414,10611420,10611422,10611425,10611426,10611427,10611428,10611429,10611430,10611433,10611434,10611435,10611436,10611437,10611442,10611444,10611446,10611447,10611449,10611450,6665789,10611455,10611463,10611473,10611476,10611477,10611479,10611480,10611484,10611486,10611491,10611499,10611503,10611507,10611508,10611514,10611515,10611517,10611518,10611525,10611528,10611532,10611536,10611537,10611542,10611543,10611546,10611550,10611551,10611554,10611559,10611560,10611567,10611571,10611572,10611574,10611581,10611584,10611585,10611588,10611594,10611596,10611597,10611598,10611600,10611603,10611604,10611605,10611608,10611609,10611610,10611611,10611616,10611617,10611618,10611619,10611620,10611621,10611623,10611624,10611630,10611631,10611632,10611633,10611634,10611635,10611636,10611637,10611638,10611646,10611647,10611648,10611655,10611662,10611665,10611670,10611676,10611678,10611699,10611705,8864673,10611906,7057920,10609439,10612655,10612684,10612821,10612822,10612837,10613097,9164758,7059118,10610668,9161361,9161476,10517321,10517322,10517323,4974411,4974416,7056123,7056138,10513892,10513893,10513894,4975002,10512118,10512119,10512120,10516198,10516199,10516200,10556373,10556374,10556375,10556376,10556377,10556378,10556379,10556380,10518802,10518803,10518804,10518805,10518806,10518807,10518808,10518809,10518810,10518811,10518812,10518813,10518814,10518815,10518816,10518817,10417312,10417313,10417314,10417315,4973352,10416534,10416646,10418669,10418672,10417803,10418807,10418808,10466954,10466955,10463011,10463023,10463024,10463025,10463026,10463027,10463028,10463029,10463031,10463034,10463035,10463042,10463043,10463044,10463045,10463046,10463050,10463051,10463052,10463054,10463055,10463056,10463057,10463058,10463059,10463060,4971347,4971353,6666505,10467097,10467102,10467108,10467109,10467110,10467116,10467118,10467119,10467122,10467124,10467125,10467126,10467127,10467128,10467131,10467132,10467133,10467134,10467135,10467136,10467137,10467139,10467143,10467144,10467145,10467146,10467148,10467151,10467152,10467153,10467154,10467155,10467156,10467157,10467158,10467159,10467160,8865110,8865165,10463392,10463393,10463394,10463395,10463396,10463397,10463398,10463402,10463430,10463431,10467433,10463434,10467434,10463435,10467437,10467438,10467440,10467444,10467457,10467458,10467459,10467461,10471504,10463595,10463649,10463651,10463652,10463653,10463655,10463656,10463658,10463660,10463661,10463665,10463667,10463670,10463671,10463674,10465683,10465684,10465687,10465688,10465691,10465692,10465695,10465702,10465706,10465709,8916781,10463731,4972007,4972009,10463735,10463739,10463741,4972017,4972018,4972019,4972020,10463745,10463746,4972023,10463748,10463749,10463750,10463751,10463752,4972028,10463753,4972029,10463755,10463756,10463758,10463759,10465760,10463762,10463763,10463764,10463765,10463766,10465766,10463767,10463768,10465769,10463771,10465772,10465773,10463774,10465774,10463775,10465775,10465778,10465779,10463780,10465781,10465782,10463783,10465783,10463784,10463785,10465786,10463786,10465787,10463787,10463789,10465791,10465792,10463792,10465793,10463793,10463794,10465795,10463795,10463797,10465798,10463798,10463799,10465800,10465801,10463801,10465802,10463802,10465803,10465804,10463805,10465806,10463806,10465807,10463809,10465810,10465811,10465812,10463812,10465813,10463813,10465815,10463815,10465816,10463816,10465817,10463817,10465818,10463818,10465819,10465820,10463820,10463823,10465824,10465825,10463825,10465826,10463826,10465827,10463828,10465830,10465831,10463832,10465833,10463833,10465836,10465837,10465839,10465841,10465845,10465846,10465847,10465848,10465849,10465854,10465872,10465873,10463876,10465876,10463877,10465877,10465878,10465879,10463881,10463883,10465883,10463885,10465885,10465887,10463888,10465888,10463889,10465889,10465892,10463893,10465893,10463894,10465894,10463895,10465895,10465896,10463897,10463899,10465900,10463901,10465901,10463904,10463905,10465907,10463908,10463909,10463910,10465910,10465911,10463912,10465912,10465913,10465914,10463915,10465915,10463916,10465916,10465917,10463917,10463918,10463919,10463920,10463924,10463925,10463929,8917096,10464040,10464041,10464042,10464043,10464044,10464045,10464046,10464047,6667559,10466207,10466209,10466211,10466213,10466214,10466215,10466219,10466220,8563545,10466224,10466226,10466227,10466228,10466229,10466230,10466231,10466233,10466236,10466238,10466239,10466241,10466242,8917323,8917324,10462297,10462298,10466304,10466309,10462313,10466314,10462314,10466315,10466316,10462316,10466317,10462317,10466318,10466320,10466321,10462321,10466322,10466323,10462323,10462324,10466325,10466326,10466328,10466329,10466332,10466333,10466334,10466336,10466338,10466339,10466341,10466344,10466345,10466346,10466349,10466350,10466351,10466352,10466353,10466359,10466360,10466361,10466362,10466364,10466365,10466366,10466369,10466370,10466371,10466373,10466376,10466377,10466378,10466379,10466381,10466383,10466386,10466389,10466391,10466392,10466393,10466396,10466397,10466399,10466400,10466401,10466403,10466404,10466405,10462407,10462409,10462411,10466412,10462412,10462413,6667835,10462414,10466415,10462417,10466418,10466419,10462420,10466421,10462421,10466423,10462423,10466424,10466425,10466426,10462427,10466428,10462428,10466429,10462430,10466431,10462431,10466432,10466433,10466434,10462434,10466435,10462435,10466436,10462438,10466439,10462439,10466440,10466441,10462441,10466442,10466444,10462444,10462445,10466447,10462447,10466448,10462448,10466449,10462450,10462451,10466452,10462452,10462455,10462456,10466457,10462457,10466458,10462459,10462460,10462461,10462462,10462463,10462473,10462476,10462477,10462480,10462481,10462483,10462484,10462488,10462491,10462492,10462493,10462494,10462496,10462497,10462498,10462500,10462501,10462502,10462504,10462505,10462507,10462512,10462513,10462514,10462517,10462518,10462521,10462522,10462523,10462524,10462525,10462526,10462528,10462529,10462530,10462531,10462533,10462538,10462539,10462543,10462545,10462546,10464580,10462582,10462583,10462585,10462586,10462590,10462592,10462595,10462596,10462597,10462598,10462603,10462604,10462605,10462607,10462609,10462610,10462611,10462612,10462613,10462614,10462615,10462619,10462621,10462625,10462629,10462630,10462723,10462724,10462725,8917819,10466851,10466855,10466860,10466863,10466864,10159842,10629343,10629344,10629345,10632109,10158705,10627417,10627717,10631412,10631413,10631709,10631710,10571747,10568971,10568972,10568973,10568974,10568975,10568976,10568977,10568978,10568979,10568980,10568981,10568982,10568983,10568984,10568985,10568986,10568992,10573527,10573528,10521154,10521155,10521213,10521804,10521805,10521806,10521807,10521811,10522054,10522055,10522062,10522690,10522691,10522692,10520738,10520739,10520753,10520754,10520755,10520756,10520758,10522892,10522893,10523025,10523026,10420329,10422394,10420488,10420564,10420565,10476175,10476176,10476177,10476178) 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'