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(10861365,10861366,10861390,10861391,10861401,10861402,10861403,10861477,10848797,3229186,3229187,7066245,7066246,10863055,10860257,10860258,8629621,8629622,10860310,10860311,10860317,8067922,8067923,8067924,8067925,10860326,10860328,10860332,10860333,10860334,10860335,10860339,10860343,10860345,10860346,10860348,10860356,10860365,10860373,10860374,10860383,8629759,10860412,8630269,8630270,10860924,10861072,10861073,10866280,10866282,10866289,10866290,10866291,10866357,10866368,10866369,10866370,7201454,10866610,10866611,10866612,10866613,7201606,7201705,7064547,7064548,7201840,8628265,8595286,8595287,7201894,7201896,7201897,10858948,10858953,10858954,10858955,10858956,10858957,7201974,10859258,10859282,10859290,10859315,10859377,10859380,7202349,10859391,7202350,7202351,7202352,10859395,10859402,10859425,10859503,7202676,10860089,10860092,10860096,10860097,10860100,10857226,10857227,10857229,10857232,10857259,10857260,10857261,10857262,10857263,10857264,10857265,10857266,10857267,10857268,10857269,10857270,10857271,10857272,10857273,10857274,10857275,10857276,10857277,10857278,10857279,10857280,10857281,10857282,7200340,7200341,7200342,7200343,7200344,7200345,7200346,7200347,7200348,7200349,7200350,7200351,7200352,7200353,7200354,7200355,7200356,7200357,7200358,7200359,7200360,7200361,7200362,7200363,7200364,7200365,7200366,7200367,7200368,7200369,7200370,7200371,7200372,7200373,7200374,7200375,7200376,7200377,7200378,7200379,7200380,7200381,10865444,10865506,10857558,10857601,10857602,3927721,3927722,10865648,10865653,10857657,10857658,10857682,10865709,10865710,10865717,8627087,10865822,10865823,10865824,7200782,7200783,10865825,10865826,10865827,10865828,10865829,10865830,10865831,10865832,10865833,10857892,10865954,10865955,10865956,10865957,10865994,10865995,10865996,10865997,10866021,10866114,10866115,10866121,10866127,10866128,10866129,10866130,10866131,10866132,10866133,10866134,10866135,10866136,10866137,10866138,10866139,10866140,10866141,10866142,10866143,10866144,10866145,10866146,10866147,10866148,10866149,10866150,8624722,8624723,8624724,8624725,8624726,8624727,8624741,8624742,8624743,8624744,8624745,8624746,10863420,10863421,10863422,10855632,10855633,10855678,10855681,10855688,10855700,10855704,10855709,10855712,10855746,10855747,10855749,7198767,7198768,7198769,7198770,10855897,8615477,10864029,10864030,10864031,10864032,10864033,10864034,10864035,10864036,10864037,10864038,10856309,10856310,10856315,10856347,10856348,10856615,10856619,10856652,10101575,11048421,10864827,10864830,10864908,10857077,10857127,10857134,7200113,7200114,10853287,10853288,10853289,10853290,10853291,10853292,10853293,10853294,10853307,10853318,10853320,10853377,10853381,10853383,10853385,10853386,3923521,3923646,8554363,8554364,10853787,10853798,10853799,10853800,10853803,10853804,10853811,3924079,8906785,8906786,8906787,8906788,8906789,8906790,8906791,8906792,8906793,8906794,10854343,10838882,10855091,10855151,10855152,10855155,10855156,10855157,10855158,10855159,10855160,10855161,10855162,10855163,10855165,10855166,3925320,10427317,8634729,8634730,8634764,8634765,10853142,10425349,10425360,10425487,10615202,10425570,10425573,10615398,10615483,10850789,10425940,10425941,10426012,10426014,10850945,10850946,10850950,10850952,10850953,10850954,10850955,10850956,10850957,10850958,10850959,10850960,10850962,10850963,10850964,10850965,10850966,10850967,10850968,10850969,10850970,10850973,10850974,10850975,10850976,10850977,10850978,10850979,10850980,10850981,10850982,10850983,10850984,10850985,10850986,10850987,10850988,10850989,10850990,10850991,10850992,10850993,10850994,10850995,10850996,10850997,10850998,10850999,10851000,10851001,10851002,10851003,10851004,10851005,10851006,10851007,10851008,10851009,10851010,10851011,10851012,10851013,10851014,10851015,10851016,10851017,10851018,10851019,10851020,10851021,10851022,10851023,10851024,10851025,10851026,10851027,10851028,10851029,10851030,10851031,10851032,10851033,10851053,10851057,10851060,10851062,10851065,10851066,10851070,10851071,10851073,10851074,10851075,10426152,10851094,10851097,10851098,10851099,10851100,10851101,10851102,10851105,10851106,10851110,10851111,10851115,10851116,10851117,10851118,10965515,10851119,10851121,10851122,10851123,10851125,10851127,10851128,10851129,10851130,10615870,10851131,10851133,10851134,10851135,10851136,10851137,10851138,10851139,10851140,10851141,10851142,10851143,10851144,10851145,10851146,10851147,10851148,10851149,10851151,10851153,10851154,10615954,10426445,8540609,8611316,10616644,10616745,10616746,10616747,10616748,10616749,10616750,10616751,10616752,10616753,10616754,10616755,10616756,10616757,10616758,10616759,10616760,10616761,10616762,10616763,10616764,10616765,10616766,10616767,10616768,10616769,10616770,10616771,10616772,10616773,10616774,10616775,10616804,10614048,10611293,8853683,8853684,8853685,8853695,8853696,8853697,8853699,8853704,8853705,8853706,8853707,8853708,8853709,8853710,8853711,8853712,8853747,8853748,8853749,8853750,8853751,8853752,8853754,8853755,8853756,8853757,8853758,8853759,8853760,8853761,8853763,8853764,8853765,8853766,8853767,8853769,8853770,8853771,8853772,8853773,8853774,8853775,8853776,8853777,8853778,8853779,8853780,8853781,8853782,8853785,8853786,8853787,8853788,8853789,8853790,10614629,8853791,8853792,8853793,10611830,10611831,10611832,10611833,10611834,7057465,10609165,10609169,10609261,10612273,10609443,10609444,8566311,10612529,8851699,8851700,8851774,8851827,8851828,8851829,8851830,8851831,8851832,8851833,8851834,8851835,8851836,8851837,8851838,8851840,8851841,8851842,8851843,8851844,8851845,8851846,8851847,8851848,8851850,8851851,8851852,8851853,8851854,8851855,8851856,8851857,8851858,8851859,8851860,8851861,8851862,8851863,8851864,8851865,8851866,8851867,8851868,8851870,8851885,8851912,8851913,8566594,8851940,8851941,8851942,8566627,8566631,8566632,8851956,8851958,8851960,10612803,10612804,8851981,8851982,8851983,8851984,8851988,8851992,8851994,8852014,8852015,8566698,8852048,8852049,8852050,8852127,8852128,8852129,8852130,8852131,8852134,8852147,8852148,8852153,8852155,8852156,8852157,8852305,8852324,8852325,9914817,10610274,10610310,10610311,8852526,8852528,8852529,8852530,8852531,8852532,8852533,8852534,8852535,8852536,8852537,8852538,8852539,8852555,8852556,10610468,8852687,8852688,8852689,8852691,8852697,8852698,8852700,8852701,8852702,8852703,8852704,8852705,8852706,8852707,8852708,8852709,8852710,8852711,8852712,8852741,10613844,10117569,8849365,10117871,9169801,9169808,9169809,9169810,9169811,8849707,10118080,8849709,8849711,8849714,8849715,8849716,8849717,8849718,8849719,8849720,8849721,8849722,8849723,8849724,8849725,8849726,8849727,8849728,8849729,8849730,8849731,8849732,8849733,8849784,7056193,6674267,8849973,8850006,8850007,8850009,8850016,8850018,8850019,8850031,10118496,8850130,8850131,8850132,8850133,8850134,8850135,8850136,8850137,8850184,8850185,8850186,8850187,8850192,8850193,8850194,8850199,8850200,8850202,8850203,8850205,10118580,8850211,8850212,8850216,8850217,8850219,8850220,8850221,8850222,8850223,8850224,8850225,8850226,8850227,9912618,10118662,10118663,10118664,8850600,9913255,10419253,10419256,10419257,10419258,10419259,10419260,10419261,10419262,10415342,10415343,10415344,10419493,10419494,9168726,10418734,9168925,9168927,10418881,10418933,10416955,10416956,10416957,10471087,10471088,10471089,10471090,10471091,10471092,10471093,10471094,10471095,8550046,9183576,10116195,10116196,10628149,10889627,10889628,10889629,10889630,10889631,10889632,10889633,10877556,10877558,10882617,10888376,10893382,10161931,10162219,10162220,10631549,10608626,10604374,10604458,10508508,10508527,10411385,10409479,10409538,10409542,10413729,10413748,10409765,10413829,10413834,10413848,10413892,10411919,10412024,10408025,10408177,10408179,10412228,10412256,10410349,10410798,10414953,10411036,10415086) 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'