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(8838310,8068811,8838319,10962538,8068867,8068868,10861307,8630681,8620892,8630718,8630719,8630720,9214738,10943685,9214869,9214874,10870555,11041353,4971052,10846572,7065878,10459509,10871269,4968339,10846779,10459609,10459617,10459625,7074057,10459633,10950704,8067313,10437286,7074376,7074385,7074397,7074401,7074406,7074429,7074452,7074456,7074495,7074523,10990218,9216193,7074543,8067638,8575930,8632449,8632450,8632451,8632458,8632459,8632460,10844619,10872205,8629571,8629572,3227660,10872643,10872651,8620294,10845327,10845341,11001371,4430503,4430504,4430505,4430506,4430507,4430508,4430509,4430510,10998691,10998692,10858311,10972973,10972974,10972975,10972976,10931856,10931861,7072486,10858779,10843287,10843288,10843289,10843361,8559710,8559711,8836305,10999506,10999539,10999540,8618699,3899391,8559863,8559869,8559871,8559874,8559884,10104108,8836544,10932610,10932619,10932659,10932681,10932690,5654614,8066496,8066497,8629108,8596132,10961194,10961195,10961196,11039200,10932978,8629196,10928823,8629197,8629198,8629199,8629200,8629201,10933030,4967941,10844372,8557763,8557767,3927276,3927277,3927279,11010573,8616956,10958987,10958988,10958989,8558276,11037085,10959105,11037111,11037112,11037171,11037178,10943248,11037276,4430352,4430353,4430398,4430399,4430400,3655645,10863501,10995951,3235853,3235866,3235867,3235868,3235869,8072316,3235903,3235911,10840245,3235923,3235935,3235936,3235941,3236002,3236026,3236027,3236028,3236039,3236072,3236073,8072783,8072784,8072785,8072786,8072787,8565065,8565066,8565067,3926783,8565154,11010235,11010236,11010237,8565266,11010258,7156435,10954694,10623309,4936934,4937068,4937080,3233779,4937092,4937104,7157029,7157039,7157050,7157069,7157124,7157129,7157136,7157145,7157157,7157180,7157181,8906882,3234295,10619125,3234466,3234577,8071170,4938054,10995060,3234844,8071323,8071335,8071351,8071363,4938487,4938488,4938489,4938490,4938491,8614610,10837046,10837263,10837264,7156086,10837322,10837542,10460393,8632469,8632470,9216493,8576042,10964561,8609832,8570050,8570051,9216974,9216982,9216983,8570355,3581878,9217209,10965287,9217401,9217402,9217403,9217404,9217405,3582204,8540371,10930900,10930901,8610992,8610994,11044080,11044081,11044082,11044083,8611254,8611335,8577956,8577957,10922440,10922455,8577992,9205353,9205355,10565196,8864449,8568487,9197991,9197992,8568500,8568523,9198023,9198024,9166119,10563137,10563151,10563184,10563185,10563186,10610097,9220505,9204548,9204549,9204550,9204551,9204552,9204553,9204554,9204555,9204556,9204557,9204558,9204559,9204560,9204561,9204562,9204563,9204564,7058753,10564634,10564635,10564655,10564661,10564662,10564673,9196875,10564774,10564775,10564826,10564827,7059198,7059199,8853042,9915443,9915444,8567739,8567797,10125528,10660165,9169453,10117849,8849765,8593143,8593149,8593150,8593151,8593165,8593167,9162132,9162144,6674452,9162387,10512689,10512690,10512691,10512692,10512693,10512694,10512695,9210920,9210921,9171055,9171089,9203160,9184331,10415273,9910559,4973357,4973358,10124808,10124809,10124814,10124815,10124819,10124820,10124840,10124841,10124842,10124843,6680895,6680929,6680930,10125049,4973751,4973752,6681133,6681134,6681135,6681155,10417033,10428496,7055297,9161245,9161246,9206406,6678687,6678691,6678692,6678693,6678694,6678695,6678696,6678697,6678698,6678699,6678700,6678701,6678702,6678703,6678704,6678705,6678706,6678707,6678708,6678709,6678710,6678711,6678712,6678713,6678714,6678715,6678716,6678717,6678718,6678719,6678720,6678721,6678722,6678723,6678724,6678725,6678726,6678727,6678728,6678729,6678730,6678731,6678732,6678733,6678734,6678735,6678736,6678737,6678738,6678739,6678740,6678741,6678742,6678743,6678744,6678745,6678746,6678747,6678748,6678749,6678750,6678751,6678752,6678753,6678754,6678755,6678756,6678757,6678758,6678759,6678760,6678761,6678762,6678763,6678764,6678765,6678766,6678767,6678768,6678769,6678770,6678771,6678772,6678773,6678774,6678775,6678776,6678777,6678778,6678779,6678780,6678781,6678782,6678783,6678784,6678785,6678786,6678787,6678788,6678789,6678790,6678791,6678792,6678793,6678794,6678795,6678796,6678797,6678798,6678799,6678800,6678801,6678802,6678803,6678804,6678805,6678806,6678807,6678808,6678809,6678810,6678811,6678812,6678813,6678814,6678815,9916934,9916949,9916950,10467467,10123118,9175015,10123271,8550324,9175220,10123558,9167557,9167558,9167559,9167560,8550778,9167734,8551006,9191882,8551048,8551049,8551065,8551073,8551097,8551115,8551118,8551144,8551145,8551146,8551171,8551172,8551173,8551191,8551199,8917895,10628399,10904104,10904105,10905083,10905084,10905085,10905086,10905087,10905088,10905089,10905090,10176169,10176170,10156214,10910283,10910340,10629884,10629885,10629886,10629887,10629888,10629889,10629890,10905440,10905441,10905442,10905443,10905444,10905445,10905455,10905456,10905457,10173753,10173800,10173814,10883143,10908163,10908164,10908182,10174282,10184297,10174326,10174327,10174328,10905472,10905473,10905474,10905493,10905494,10905525,10905526,10905527,10905528,10161593,10890730,10630252,10911379,10911380,10911381,10911382,10911383,10911428,10911429,10911430,10911449,10630951,10630952,10630953,10630954,10630955,10630956,10630957,10630958,10630959,10911486,10911487,10911531,10911532,10172545,10172546,10172573,10172574,10172599,10172600,10172629,10911629,10911650,10911651,10172665,10172666,10172667,10172668,10911680,10172695,10172696,10911688,10626463,10949816,10949817,10949818,10949819,10949824,10949825,10949826,10949827,10949828,10626548,10163097,10949958,10882322,10882323,10950207,10605278,10605297,10580544,10608517,10644299,10650393,10650394,10653591,10653592,10653593,10653594,10653595,10578538,10578539,10578707,10578708,10578709,10578710,10578711,10578712,10603710,10578964,10578965,10578966,10578967,10578968,10578969,10578970,10578971,10578972,10578973,10578974,10578975,10578976,10578977,10578978,10578979,10578980,10578981,10603880,10651544,10651545,10651546,10582590,10576591,10582591,10582592,10582593,10582594,10651948,10651974,10651975,10651976,10651977,10537720,10541763,10534344,10534345,10534346,10534347,10534348,10534349,10534370,10550478,10423392,10507497,10507498,10422760,10422761,10413340,10490051,10490052,10490082,10490083,10490084,10490085,10490086,10490087,10490113,10490114,10490115,10490136,10490137,10486170,10486171,10486172,10486173,10494220,10494280,10494281,10494282,10494283,10494284,10494285,10494286,10494287,10494288,10494289,10494290,10494291,8562624,8562627,8562631,8562639,8562644,10473335,10473336,10496340,10473341,10473352,10473411,10473412,10473418,10473419,10473449,10473450,10473451,10473518,10473519,10473520,10473521,10496592,10496593,10496594,10496595,10475643,10475644,10475645,10475646,10475647,8563077,10496780,10496781,10496782,10473963,10473964,10473965,10473966,10473967,10474000,10474051,10474056,10474061,10474069,10474070,10487208,10489356,10489357,10476358,10489358,10476359,10489359,10476360,10476361,10476362,10476363,10489369,10489380,10489381,10489382,10489383,10489384,10489385,10489397,10489414,10489522,10472824,10472848) 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'