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(10448037,10448038,10448051,10448063,8838739,10846003,10846044,8630968,10846076,8630977,7076363,7076365,7076366,8631087,8631088,8631089,8631275,8631286,8631287,8631288,8631293,8631310,8631311,8631312,8631313,8631314,8631315,8631322,8631323,8631324,8631325,8631326,8631327,8631348,8631349,8631357,8631359,8631360,10963402,7068728,8631377,8631378,8631379,7068736,7068752,8631405,8631406,8631407,8631408,8631412,8631420,7068776,8631421,10940406,7068784,7068792,7068793,7068799,8631444,7068804,7068812,7068813,7068814,7068815,7068823,8569838,8569839,8569840,8569841,8621710,7068878,7068899,7068901,7068911,7068918,8621757,7068930,8621787,7074086,3229967,3230166,3230194,8576060,8622750,8837431,8837432,8837433,8837434,8837435,8837436,8619827,8619860,8619983,8619984,8620061,10498040,10498041,8620143,8620189,8837928,8620280,8837986,8837987,8837997,8837998,8838049,8838050,8838218,8838219,8617771,10842982,10843010,10843111,10843115,10843123,10843125,10843129,7072612,7072613,7072714,8836249,7072763,7202029,10103942,7072813,10103949,7072860,7072880,7072907,7072908,7073017,7073053,7202715,7202719,8066455,8066456,7202728,10928867,8619665,8619668,8619676,11048931,10942731,8617004,8617005,10102339,10102366,10102374,8617087,8617137,8617206,8617326,8617371,8617466,7068984,7068985,10839788,10839789,8614996,8615005,8615324,8615447,8615478,8615479,8615480,3656234,10941788,10941801,10941810,10941813,8909312,8909313,10941897,10941903,10941907,10941990,10942025,11048369,8909567,11048440,7070639,10942461,10942462,11010545,11010551,11010552,8909934,3233402,7196251,7196252,8906068,10618040,10618041,10618042,10618043,10618104,10618105,10918663,8906191,7196431,7196432,7196433,7196434,7196435,7196436,7196437,7196438,7196439,8906368,10918890,10918891,8613427,8613428,8613477,8613515,8613516,8613521,10919281,10919282,10968577,8906955,8906956,8613742,8613743,8613744,8613745,8613746,8613747,8613756,11046636,10618979,10618984,10618985,10618986,10618987,10618988,10618989,10618990,10618991,10618992,10919603,7197772,7197773,10920145,8907733,10617068,10993210,10993211,10993232,10993233,10918162,10993345,10993449,10993473,10993474,10993475,10993520,11006526,10993554,10993555,10993556,10993557,10622899,10993558,10993559,10993560,10993561,10993562,10993573,10993574,10993575,10993576,10951634,3230541,10425567,10425568,10425569,10847960,10951962,10920918,10920919,10921086,10952254,10921349,10426193,8577046,10615922,10921500,10921501,8577155,10921618,10991808,10991809,10991810,10991811,8577305,10991812,10991817,10921775,8540781,10426642,10621448,10616473,10426850,10992192,10992211,10992212,10992213,10992214,10992245,8577782,10992338,10992352,10616730,10616731,10616732,3232184,3232185,3232186,3232245,3232324,8611742,8541436,8541437,8541438,8541439,8541440,8541441,8541442,8864209,6677919,6677920,9213714,10614563,10122118,10122119,10122164,10122165,10122169,10122195,9190010,6678310,10122324,10122334,10122441,10122478,7057467,9171303,9171327,9203351,7057533,7057536,9195441,9195442,9195443,9195494,9195495,9203504,9203505,9203506,9203507,9203508,9203509,9203510,9203511,9195549,9195550,9195551,9171599,9187623,9187624,9195632,9195633,9195634,9195635,9195636,10557486,9203679,9203680,9195712,9203819,9203820,9203821,9203822,9195873,9211904,9187998,9204012,9204013,9204014,9204015,9204016,9204128,9204129,9204130,9204131,7058307,9204217,9204218,10120427,10120428,10120429,10120430,10120431,10120432,10120433,9204263,9204324,10613063,9204428,10613119,10610120,9204481,10610190,10613208,9204594,9204595,10610282,10610289,9204704,10613455,8863462,8863463,8863464,8863465,8863466,8863467,10610795,10610823,9173219,10117583,9193395,10117749,9161592,9161593,9193614,9193615,10555454,10555455,10555456,10555457,10555458,10555459,10555460,10555461,10555462,10555463,10555464,10555465,9201659,9201660,9201661,9201662,10555495,10555496,10555497,10555498,10555499,9193686,10555500,10555501,9185701,9185702,9185703,9185704,9185705,9193811,6674052,9201890,7023558,9201929,10126178,9201990,9185993,9185994,9185995,9186006,9186022,10126221,9186032,9186046,9186060,9186062,9186069,9186081,9186113,9186115,9194120,9194121,6674415,6674424,9194345,9194346,9194347,9202432,9186436,9194486,10556303,10556304,10556305,10556306,10556307,9186524,9202604,9194627,9194628,10556450,10556451,9170645,9186661,9186666,9186676,10556540,10556541,9194729,9194730,9186746,9194771,9194772,9186854,9186855,9186859,9186873,9186874,9194874,10556710,9195121,9195122,9195123,9195124,10557062,10416259,10416272,10415331,9200473,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,9200730,9200731,9168828,9168829,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10415887,10415888,10415889,10415896,10415897,10415898,9201003,9201004,9201005,10417121,10417122,10122817,10122818,9190815,9190817,10467428,10467429,10467430,10467431,10467432,4971936,6667156,6667157,10463741,10463742,10463743,10463744,10463745,10463746,10463747,10463748,10463749,10463750,10463751,10463752,10463753,10463754,10463755,10463756,10463757,10463758,10463759,10463760,10463761,10463762,10463763,10463764,10463765,10463766,10463767,8550348,10123483,8563395,10468142,10468143,10468158,10470495,10470595,10124256,10462723,10462724,10462725,10462726,10462727,10124410,10124445,10893504,10174526,8593532,8593533,8593534,8593536,10888539,10628100,8593815,10174826,8593827,10174871,10179963,10179990,10180166,10180167,10180168,10180169,8594460,10180571,10180951,10180952,10180953,10180954,10629541,10629694,10629695,10629696,10181228,10629757,10629758,10629878,10629879,10183538,10183643,10183644,10183645,10627281,10888187,10888267,10174381,10890804,10890872,10890873,10890986,10182048,10182049,10182050,10182051,10182052,10182053,10172105,10182215,10182216,10949159,10182378,10182481,10949309,10949311,10949312,10949313,10949314,10182627,10182628,10167640,10167643,10626132,10626193,10626194,10626196,10187741,10626251,10626252,10626255,10626266,10187810,10172861,10891854,10891855,10183077,10178109,10183146,10183249,10887314,10183328,10183395,10601123,10577452,10643542,10574705,10574713,10574714,10574715,10574716,10574717,10574718,10574719,10577766,10577902,10577903,10577904,10577905,10574919,10578083,10575181,10578203,10578204,10578205,10578206,10569304,10578305,10569305,10578306,10569306,10578307,10569307,10578308,10569308,10578309,10569309,10578310,10569310,10569311,10569312,10569313,10569314,10569315,10569316,10569317,10599349,10599350,10578394,10575439,10578501,10578549,10575561,10572597,10578768,10578778,10578816,10578817,10578818,10578819,10578877,10578878,10578879,10578880,10578881,10569889,10569890,10569891,10647952,10569892,10569893,10569894,10569895,10569896,10569897,10569898,10569899,10569900,10569901,10569902,10569903,10569904,10569905,10569906,10569907,10569908,10573023,10573024,10573025,10573026,10573027,10570127,10570128,10573264,10579383,10579384,10576448,10576449,10576450,10576451,10570641,10570642,10570643,10570644,10591715,10576727,10600951,10600952,10601004,10601005,10601006,10601007,10523666,10523682,10529703,10531795,10531796,10531797,10531798,10531799,10531800,10531815,10531824,10531825,10531826,10531850,10529932,10529933,10535988,10529989,10535989,10535990,10530023,10530047,10532130,10530200,10536406,10530483,10530554,10530555,10530556,10532560,10532561,10532562,10530563,10532563,10530564,10530572,10532572,10530573,10532573,10530574,10532574,10530575,10532575,10532576,10530580,10530581,10530582,10530583,10530584,10530610,10530611,10530612,10532627,10532633,10532634,10532635,10532636,10532637,10532638,10532639,10532640,10532641,10532642,10532643,10532644,10532645,10532646,10532647,10532648,10532649,10532650,10532651,10530658,10530659,10530660,10530661,10530662,10530663,10530664,10530665,10530666,10530667,10530668,10530669,10530670,10530671,10530672,10530673,10530674,10530675,10530676,10530677,10530678,10530679,10530680,10530681,10530682,10530683,10530684,10530685,10532722,10530726,10530727,10530728,10530729,10530730,10530731,10530732,10530745,10530751,10532766,10532767,10532768,10532769,10532770,10532771,10530802,10532816,10532825,10532826,10532827,10540838,10524881,10524882,10530911,10530912,10530913,10530914,10530915,10530916,10534929,10532993,10532994,10532995,10532996,10532997,10532998,10532999,10533000,10533001,10533002,10533048,10533049,10533050,10533051,10533052,10424718,10424866,10422145,10487931,10485970,10488014,10494022,10494133,10494134,10479190,10479191,10479272,10479273,10479303,10479304,10479305,10479306,10479307,10479308,10486504,10408052,10481839,10479897,10497247,10497330,10409007,10493746,10409099,10409100,10409101,10493846) 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'