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(10962733,10962734,8630786,8630791,8630792,8630793,8630810,8630857,8630875,8630876,8630878,8630879,8630880,8630882,8630883,8630887,8631024,10848692,10848697,8631133,3229107,8631595,8631606,10950726,10849869,8632380,8632381,8632382,8632383,8632384,8632392,8632393,8632394,8632395,8632396,8632397,8632398,8632399,8632537,8632538,8632545,8632547,8629581,8629582,8629583,8629584,3227401,8629679,8629680,8629681,8629718,7201277,7201354,7201368,7201498,7201499,7201502,7201504,7201505,7201508,7201509,7201510,7201511,7201512,7201559,7201711,8595109,8595112,8595113,8595114,8595115,8595116,8595117,7201727,7201728,7201729,7201761,7201762,8595175,8628215,8628232,8628258,8628259,8911744,8911745,8628344,8628351,8628352,7202133,7202165,7202168,7202171,7202209,7202210,8628626,8628627,7202347,8628818,8628819,8628820,8628821,8628822,8628823,8628824,8628825,8628826,8628827,8628828,8628829,8628830,8628831,8628832,8628833,8628834,8628835,8628874,8628875,8628876,8628877,8628878,8628879,8628880,8628881,8628882,8628883,8628884,8628885,8628886,8628887,8628888,8628889,8628890,8628891,8628892,8628893,8628894,8628895,8628896,8628897,8628898,8628899,8628900,8628901,8628902,8628903,8628904,8628908,8628909,8628910,8628911,8628912,8628913,8628999,8629000,8629001,8629002,8629044,8629045,8629046,8629047,8629048,8629049,8629050,8629051,8629052,8629053,8629054,8629055,8629056,8629057,8629058,8629059,8629060,8629061,7202673,9794589,8629324,3227094,8629332,8629336,8629337,3227190,8629422,8629423,8629424,8629514,8629578,8629579,8629580,3237394,3237395,10958953,10958954,8626958,8626963,8627005,8627006,8627012,8627013,8627017,8627019,8627022,8627024,8627026,8627027,8627030,8627033,8627035,8627039,8627042,8627044,8627046,8627047,8627048,8627049,8627068,4430154,4430155,4430156,4430157,4430158,8627228,8627246,8627286,8624646,8624647,8624648,8624649,8624650,8624651,8624652,8624653,8624654,8624655,8624656,8624657,8624658,8624659,8624660,8624679,8624680,8624693,8624694,7198381,7198392,7198393,7198394,8624925,7198682,7198730,8625248,8625249,8625250,7198853,8625255,8625262,8625267,8625424,8625425,8625426,8625427,8625428,8625429,8625430,8625431,8625432,8625433,8625434,8625435,8625436,8625437,8625438,8625439,8625440,8625551,8625552,8625555,8625556,8625560,8625562,8625567,8625659,7199392,8625792,7199394,7199395,7199396,7199397,7199398,7199399,7199401,7199402,7199403,7199405,7199409,7199410,7199411,7199414,7199415,7199417,8625871,8625880,7199508,8625975,8625995,10101497,8626021,8626145,8626146,8626147,8626152,8626158,8626165,8626177,8626223,7200087,3923440,3923441,3923467,7196333,3923490,7196456,7196463,7196539,3235063,3235064,3235065,7197901,7197909,8624418,8624433,8624522,8624551,8624553,8624554,8624572,8634695,8634697,8634699,8634701,8634702,8634703,8634705,8634708,8634710,8634716,8634718,8634720,8634721,8634722,8634723,8634724,8634725,8634726,8634727,8634728,8634800,8634801,8541669,8634804,8634805,8634807,8634808,8634810,8634811,8634813,8634816,8634818,8634823,8634826,8634827,8634828,8905383,8905384,8905385,10622402,10622441,10622460,3922832,8632900,8632901,8632902,8632903,8632904,8632905,8633158,8633159,8633272,8633273,8633274,8633275,3231052,8633280,8633281,8633286,8633287,8633288,8633290,8633291,8633295,8633296,10615721,10615722,10426193,10426372,8540593,8540603,10426474,8540631,8540633,8633986,10616644,10616655,8634406,8634407,8634414,8634415,8634421,10616888,8634565,8634566,8634567,8634568,8634570,10614048,6669828,6669829,6669830,6669831,6669918,10614376,10614518,10614565,10612013,10612022,10612025,10612050,10612059,10612060,10612062,10612063,10612064,10612069,10612086,10612094,10612095,10612096,10612097,10612102,10612104,10612105,10612106,10612107,10609313,8851584,8851693,8851694,8851703,7058247,7058248,7058249,7058250,8566611,8566612,8566613,8566614,8566615,8566616,8566617,8566618,8566640,8566641,8566642,8566643,10612916,10612940,10609971,10613056,10610061,10610065,10613147,10613148,10613157,9172534,10613235,10613350,10613353,10613354,10613369,10610901,6673527,6673528,6673529,6673530,6673531,6673532,6673552,10117726,9911860,9911862,9911864,10117876,10117890,10117891,9169748,9912051,10118062,9912091,9912092,6674165,9169965,9912226,9912227,6674249,9912271,6674276,6674278,6674308,10118398,9912469,8850116,8850117,9913100,9913362,9913363,10415232,10415242,10415251,9168393,9168394,6672624,10419370,10415373,10415374,10415375,10415376,10416481,10116818,6672911,9168765,10417811,10417812,10417814,10417816,10417818,10417820,10417822,10417824,10417826,10417828,10417830,10417832,10417834,10417837,10417839,10417841,10417843,10417845,10417847,10417849,10417850,10417852,10417854,10417856,10417858,10417860,10417862,10417864,10417866,10417868,10417870,10417872,10417874,10417876,10417878,6673162,10417881,10417883,10417885,10417887,10417889,6673174,10417891,10417893,10417895,10417897,10417899,10417901,10417903,10417905,10417907,10417909,10417911,6673196,10417913,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,10418961,6673267,6673271,6673272,6673273,6673277,6673278,6673279,6673281,6673282,6673287,6673288,6673289,6673293,6673297,6673299,6673300,6673301,10418018,6673304,6673308,6673310,6673317,6673318,10418048,6670762,8550023,8550087,8550097,8550155,10115665,10468233,9167779,10884324,10889451,10884513,10884653,10884720,10884721,10884722,10884723,10884724,10884725,10884738,10884764,10884787,10884788,10884793,10884799,10884800,10889998,10890165,10885313,10627319,10883081,10883421,10885564,10885733,10161842,10161843,10162052,10949057,10891380,10886910,10887052,10887096,10887097,10882284,10647479,10648050,10648051,10545324,10547913,10547998,10544310,10548747,10548748,10548751,10548885,10508169,10498367,10498499,10507900,10507901,10507920,10507921,10507922,10507938,10413269,10413270,10413271,10413272,10413273,10413274,10413275,10409349,10407370,10411761,10411769,10411773,10411779,10411786,10411787,10411793,10411794,10411811,10411813,10407925,10411951,10411956,10410024,10410025,10410026,10408157,10412174,10412237,10412238,10412239,10412240,10412241,10412242,10412243,10412244,10412245,10412246,10412247,10412248,10487109,10487110,10487111,10487112,10412500,10412501,10412502,10412503,10412504,10412505,10412506,10412507,10412508,10412509,10412510,10412511,10412512,10412513,10412514,10412515,10412516,10412517,10412518,10412519,10412520,10412521,10412522,10412523,10412524,10412525,10412526,10412527,10412528,10412529,10412530,10412531,10412532,10412533,10412534,10412535,10412536,10412537,10412538,10412539,10412540,10412541,10412542,10412543,10412544,10412545,10412546,10412547,10412548,10412549,10412550,10412551,10412552,10412553,10412554,10412555,10412556,10412557,10412558,10412559,10412560,10412561,10412562,10412563,10412564,10412565,10412566,10412567,10412568,10412569,10412570,10412571,10412572,10412573,10412574,10412575,10412576,10412577,10412578,10412579,10412580,10412581,10412582,10412583,10412584,10412585,10412586,10412587,10412588,10412589,10412590,10412591,10412592,10412593,10412594,10412595,10412596,10412597,10412598,10412599,10412600,10412601,10412602,10412603,10412604,10412605,10412606,10412607,10412608,10412609,10412610,10412611,10412612,10412613,10412614,10412615,10412616,10412617,10412618,10412619,10412620,10412621,10412622,10412623,10412624,10412625,10412626,10412627,10412628,10412629,10412630,10412631,10412632,10412633,10412634,10412635,10412636,10412637,10412638,10412639,10412640,10412641,10412642,10412643,10412644,10412645,10412646,10412647,10412648,10412649,10412650,10412651,10412652,10412653,10412654,10408654,10412655,10408655,10412656,10412657,10412658,10412659,10412660,10412661,10412662,10412663,10412664,10412665,10412666,10412667,10412668,10412669,10412670,10412671,10412672,10412673,10412674,10412675,10412676,10412677,10412678,10412679,10412680,10412681,10412682,10412683,10412684,10412685,10412686,10412687,10412688,10412689,10412690,10412691,10412692,10412693,10412694,10412695,10412696,10412697,10412698,10412699,10412700,10412701,10412702,10412703,10412704,10412705,10412706,10412707,10412708,10412709,10412710,10412711,10412712,10412713,10412714,10412715,10412716,10412717,10412718,10412719,10412720,10412721,10412722,10412724,10412725,10412726,10412727,10412728,10412729,10412730,10412731,10412732,10412733,10412734,10412735,10412736,10412737,10412738,10412739,10412740,10412741,10412742,10412743,10412744,10412745,10412746,10412747,10412754,10412755,10412756,10412757,10412758,10412759,10412760,10412761,10412762,10412763,10410905,10410906,10406959,10406964) 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'