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(10843156,10843157,10843158,10843159,10843160,8595109,8595112,8595113,8595115,8595116,10843270,8628167,8595175,8628183,8628187,7201844,8628250,10858945,10858946,8911755,8628343,7201959,7202133,7202165,7202168,7202171,7202209,7202210,7202214,8569510,8569511,10874354,10874355,10874379,10874380,10874381,7202685,7202686,7202688,7202689,7202690,7202691,7202693,7202694,7202697,7202698,7065941,8629325,7066266,8629679,8629680,8629681,8629736,8573335,8573336,8573337,7200603,10857648,7200609,7200612,8910449,8910450,8910451,8627068,8627129,8627137,8627138,8627146,8627147,8627148,8627159,8627160,8627161,8627172,8627173,8627174,8627184,8627185,8627186,8627192,8627193,8627194,8627202,8627203,8627204,7200901,8627370,8627372,8627375,8627376,7201080,8627488,8627490,8627493,8627495,8627525,8627527,8594636,7201319,7201335,7201366,8627822,8625022,8625025,8625042,8625045,8625055,8625056,8625057,8625058,8625059,7198678,7198684,7198695,10855742,10855743,10855744,7198712,8625135,8625136,8625137,8625140,7198742,8625143,7198749,7198750,7198752,7198759,7198770,8625241,8625242,7199135,7199403,10840912,8626085,8626086,8626223,8626379,10196490,7200091,10857143,10857144,7200111,8626719,8626720,8626721,8626722,8626812,8626813,8626814,8626815,10857461,10857462,7200456,7200458,7197854,7197855,7197856,3235067,8624401,8624409,8624439,8624441,8624449,10868106,8624472,8624589,8624594,8624595,8624596,8624597,8624598,8624599,10100083,8624600,8624601,8624602,8624603,8624604,8624605,8624606,8624607,8624608,10868261,10868262,10868263,10868264,10868265,10868266,10868267,10868268,10868269,10868270,10868271,10868272,10868273,10868274,10868275,10868276,10868277,10868278,10868279,10868280,10868281,10868282,10868283,10868284,10868285,10868286,8624935,8624944,8624945,8624960,8624961,8624973,8624978,10855624,8624985,3232798,8541920,8541921,3922832,3232913,3232914,3232915,10866009,10866011,10866013,10853133,10853141,10853335,3923440,3923441,3923489,10853409,10853410,10853411,3923620,3923632,10866561,10866563,10866564,10866565,7196523,10866567,10866568,7196526,7196528,10866571,10866573,10866575,10866577,10866579,10866580,10866583,10866588,10866590,10866597,10866599,10866603,10866605,10866607,10866609,10866617,10838803,10838816,10854367,10838919,10838920,10838921,10838922,10838923,10838924,9217008,9217072,8633159,8633276,8633277,10864025,8633402,10851158,10851159,10851160,10851161,10851162,10851163,10851164,10851165,8633543,10864501,10864502,10864505,10864507,10864509,10864511,10864513,10864515,10864517,10864519,10864522,10864525,10864527,10864529,10864531,10864533,10864535,10864537,10864538,10864540,10864542,10864544,10864546,10864548,10864550,10864551,10864553,10864556,8540781,8540782,10864558,10864560,10864562,10864564,10864566,10864568,10864570,10864572,10864574,10864576,10864578,10864580,10864582,10864584,10864586,10864589,10864591,10864593,10864595,10864597,10864599,10864601,10864603,10864605,10864607,10864610,10864613,10864619,10864622,10864624,10864626,10864629,10864631,8634011,8634015,8634019,8634023,8634027,8634031,8634050,8634051,8634056,8634057,8634062,8634063,8634071,8634072,8634076,8634077,8634081,8634082,8634271,8634441,8634442,8634443,8634444,8634571,8634572,3232382,8905149,8905162,8905163,10852524,10852572,10432062,8575733,10849868,10617209,8632383,8632384,10863054,10617454,10617455,10622460,8632514,8632520,8632521,8632545,8632546,8632559,8632560,8632573,8632574,8632618,8632619,8632620,8632621,8632622,8632625,8632626,8632627,8632628,8632629,8632630,8632631,8632632,8632684,8632685,8632686,8632687,8632688,8632689,8632690,8632691,10847971,10190017,10190018,10860834,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620208,8630245,8630246,10615229,8630321,10615334,8630420,10861074,8630456,8630463,8630465,8630467,10620559,8630625,8630626,8630627,8630628,8630629,8630630,8630631,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630644,8630645,8630646,8630647,8630648,8630655,8630656,8630657,8630720,10615711,10861432,10861434,10930631,8630854,8630855,8630856,8630902,8630903,10615896,8631030,8631052,8631053,8631054,8631055,8631056,8631057,8631058,8631059,8631060,8631061,8631062,8631063,8631064,8631065,8631066,8631067,8631068,8631079,10616058,8631119,8631120,8631121,8631147,3228950,8631298,8631299,8631301,8631302,10188366,8631303,8631310,8631311,8631313,10188377,8631314,10188378,8631315,10188379,10188380,10188381,10188382,10188383,10188384,10188385,8631322,8631323,8631325,8631326,8631327,3229206,10188658,10188659,8631606,8631611,8631630,8631636,10616644,8631712,10849376,10849377,10849378,10849379,10849380,10849381,10849382,10849383,10849384,10849385,10849386,10849387,10714023,6669818,10614376,10614497,10614498,10614552,10614553,10614554,9166136,10612062,10612063,10612064,10612086,10612104,10612105,10612106,10612107,10612294,7058247,7058248,7058249,7058250,7058251,8567072,8567073,10613235,9188597,10613369,10613475,10613729,10117529,6673563,6673690,6673692,6673696,9161492,7055723,6673808,7055836,6674175,9912193,10517809,9912227,6674248,6674256,6674276,6674278,6674280,6674281,9912386,10118451,10118452,10516142,10118606,10118607,10118610,9913245,9913246,10427685,6672592,9168394,10417424,10419470,10419472,10419474,10419476,10419477,10419481,10419483,10419486,10419488,10419490,10419492,10419498,10116818,6672829,6672871,6672872,6672887,6672896,6672897,6672898,6672899,6672900,6672901,6672960,6673086,6673087,10417811,10417812,10417814,10417816,10417818,10417820,10417822,10417824,10417826,10417828,10417830,10417832,10417834,10417837,10417839,10417841,6673126,10417843,10417845,10417847,10417849,10417850,10417852,10417854,10417856,10417858,10417860,10417862,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,10417881,10417883,10417885,10417887,10417889,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,6673287,6673300,6673317,10419165,10419166,10419167,10419173,9169275,10117478,8549463,6670762,10467883,6667407,6667412,976362,976367,976495,10470721,10470722,9168216,10883485,10888524,10883588,10946563,10946564,10946565,10893979,10893980,10893981,10893982,10893983,10893984,10893985,10893986,10893987,10893988,10893989,10893990,10884324,10884493,10885074,10890104,10890132,10890163,10890171,10890172,10885313,10631994,10632010,10632011,10632012,10632013,10632014,10632018,10627321,10630023,10630024,10630025,10630027,10630028,10630031,10630032,10630035,10630036,10630037,10630038,10630041,10630093,10949006,10886850,10887096,10887097,10626710,10626711,10626720,10626724,10626725,10882284,10610984,10610985,10611037,10602162,10602167,10602184,10602185,10602197,10608610,10602689,10602709,10602710,10602739,10647394,10609285,10609355,10609369,10590996,10610473,10610474,10610480,10610481,10601698,10601707,10521871,10521872,10521873,10508242,10508243,10508267,10508322,10508323,10508324,10508325,10508326,10508335,10508603,10420717,10420858,10420859,10420860,10420861,10420862,10420863,10420864,10420865,10420866,10420867,10420868,10420869,10420870,10420871,10420872,10420873,10420874,10420875,10420876,10420877,10420878,10420879,10420880,10420881,10420882,10420883,10420884,10420885,10420886,10420887,10424940,10424941,10424965,10424966,10424967,10409350,10407369,10413460,10413461,10409501,10409564,10409565,10413677,10408185,10408186,10408187,10408188,10408189,10408190,10408191,10408192,10408193,10410787,10410905,10410906,10410907,10406982,10406983,10406984,10406985,10406986,10406987,10408988,10406988,10406989,10406990,10406991,10406992,10406993,10409025) 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'