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(10873280,8838544,10930372,8838596,8838597,8838598,8838599,10939735,10930402,7068160,7068161,7068162,7068163,7076301,11041144,11041145,11041146,11041147,11041148,11041149,11041150,11041151,11041152,11041153,11041154,11041155,11041156,11041157,8621373,10846332,10846333,10846334,10846335,10846336,10846337,10846338,10846339,10846340,10846341,10846342,10846343,10846344,10846345,10870886,10870887,10873946,8621507,8621508,8621509,4971030,4971031,10933333,10846843,11015868,11015869,11015870,10846985,10846986,7074260,8622111,10862603,9216078,10849720,8575625,7066731,11016453,11016454,11016455,11016456,10850060,10460418,10460421,10964580,10964581,10964582,7074965,7074968,11013699,11013700,8619881,8619882,8619883,10872347,10844852,10844853,10929380,7075122,8620318,8838168,8838169,8838170,11040366,11040367,11040368,11040369,11040370,11040371,11040372,11040373,11040374,11040375,11040376,11001422,10873087,9214563,10845678,8617788,11011714,11011715,11011716,11011717,11011718,11011719,11011720,7201325,7201330,10103481,8911544,7072546,7072556,11012289,11012290,11012291,11012292,11012323,7072698,7072699,7072700,7072701,10999388,10999389,10999390,10999391,7072709,11012410,11012411,11012412,11012413,11012414,11012415,10986534,10986535,10986536,10999562,10999563,10999564,10986587,10843722,10104211,10104281,11012852,11012853,11012854,11012855,11012904,11012905,11012906,8560188,10867625,7202587,8560301,8560302,8560303,10844110,10844111,10844112,7073562,10867895,10867896,10867897,8560572,11013317,10961344,10961345,10961346,10961347,10961348,10961349,10961350,7073772,10961551,10961552,10961553,10961554,10961555,10933218,10961556,10961563,11013607,3237410,3237422,11048960,8834585,3927492,3927493,3927494,8616974,7071203,3927637,8617297,11049374,8835030,10943192,4430266,4430267,4430268,4430270,6000157,11024607,7069331,10863647,10863650,8615315,8615353,8072357,8072358,8072359,8072360,8072361,8072362,8072363,8072364,8072365,8072366,8072367,8072386,8072387,8072388,8072389,8072390,8072391,8072392,8072393,8072394,8072395,8072407,8072408,8072409,8072410,8072411,8072412,8072417,8072418,8072419,8072420,8072421,8072422,8072438,8072439,8072440,8072441,8072442,10996396,8072448,8072449,8072450,8072451,8072452,8072453,8072454,10996412,10856053,10864308,10840812,10840813,11022898,11022899,3236647,3236648,3236649,3236650,3236651,3236652,3236653,3236654,3236655,3236656,3236657,3236658,3236659,3236660,3236661,3236662,3236663,3236664,3236665,3236666,3236667,3236668,3236669,3236670,3236671,3236672,3236673,11023040,11023041,10864768,3926905,3926906,8557481,3926940,11048489,10958367,10997387,10997388,10997391,10101894,10101895,8909828,8909833,11019657,11019658,10618053,10618054,11019742,11019746,11019747,11019748,11019749,11019750,11019751,11019752,11019753,11019754,11019755,10837896,10837897,10837898,11033062,11033063,3923938,3923939,3923940,3923941,8554518,3234116,7157302,7157303,10618832,8555013,8555014,8555015,3234509,10838880,8907297,8907298,10619354,10619355,4938095,4938096,4938097,4938098,4938099,4938100,4938101,4938102,4938103,4938104,4938105,4938124,4938125,4938126,4938127,4938128,4938129,4938130,4938131,4938132,4938133,4938145,4938146,4938147,4938148,4938149,4938150,4938155,4938156,4938157,4938158,4938159,4938160,4938176,4938177,4938178,4938179,4938180,4938186,4938187,4938188,4938189,4938190,4938191,4938192,11008159,11008160,11008161,3234925,11021589,11021590,10927495,8611820,10927565,10927566,10917824,10917825,10917826,8612476,8905952,11042669,11042670,10990806,10951871,10925833,10925834,10925835,10925836,10925837,10925838,10925842,10920913,3230811,3230812,10615447,10615452,10615453,10850728,10926154,10926155,10926156,10926157,10926158,10926159,10926160,10926161,10926162,10926163,10926164,10926165,10926166,10926167,10926168,10926169,9217341,10952432,10952433,10615873,11030900,10921815,10921816,10926878,9218035,8577673,10927083,7155344,6677596,6677597,9165536,7019238,7019239,7019240,7019241,7019242,7019243,7019244,7019245,7019246,7019247,7019248,7019249,7019250,7019251,7019252,7019253,7019254,7019255,7019256,7019257,7019258,7019259,7019260,7019261,7019262,7019263,7019264,7019265,7019266,7019267,9189726,3655023,9174009,9174010,9174011,9174012,9174013,9174014,9174015,9174016,9174017,8864603,10611866,7057639,9211682,8851649,8851650,8851651,8851703,9187944,8862718,8862719,10612962,8862848,8862849,9172382,9172390,9189055,9205087,9205095,10428694,10125662,9193573,8849408,7023306,7023307,8849840,9202104,10512118,10512119,10512120,10516188,7056578,3286107,7024137,7024138,7024139,7024140,7024141,7024142,7024143,7024144,7024145,7024146,7024147,7024148,7024149,7024150,7024151,7024152,7024153,10119377,10119378,9913450,10519059,10519060,10519061,10416245,9200782,9200783,9200784,9200785,10428368,10416035,10418084,10125429,10125430,10125431,10125432,10125433,10125434,10125435,10125436,10125437,10125438,10125439,10125440,10125441,10125442,10125443,10125444,10125445,9209261,8864905,8864906,8864907,8864908,8864909,8864910,8864911,8864912,6678596,6678599,8854348,8854352,8854353,10122728,9206791,10123092,10469589,10469604,10469609,9207222,9207223,9207224,8916877,9175261,9175262,6665639,10469978,10469979,10469980,10469981,9199491,9199492,9199498,6679797,9207664,9207665,9207666,9207667,9207668,9207669,9207670,9207671,10123926,9191754,9191911,9191912,9191923,9191924,9191929,9191930,6474287,10908856,10908857,10908858,10908859,10908860,10908861,10908862,10908863,10909149,10909150,10909151,10909152,10914258,10914259,10629038,10629039,10629040,10629041,10629042,10629043,10904787,10904788,10904789,10904790,10904791,10904799,10904800,10915014,10915015,10915016,10915017,10915019,10915020,10915021,10626967,10632016,10632017,10158579,10632095,10158718,10158719,10903127,10627779,8593447,10630101,10890775,10176791,10176792,10161849,10167420,10187486,10187487,10906639,10906641,10631273,10631274,10631275,10162853,10172867,10187991,10912225,10912226,10912227,10892442,10950268,10568548,10583876,10583877,10583878,10653998,10653999,10654048,10654049,10654050,10654051,10607000,10651468,10651469,10588411,10651537,10582560,10652018,10545463,10545464,10545465,10545466,10545467,10545468,10545469,10545470,10545471,10545472,10545473,10545474,10545475,10545476,10545477,10545478,10545479,10545480,10545481,10545482,10545483,10545484,10545485,10545486,10545487,10545488,10545489,10545490,10545491,10545492,10545493,10545494,10545495,10545496,10545497,10545498,10545499,10545539,10545540,10545593,10545594,10545595,10545596,10545606,10545607,10545608,10545609,10545610,10545611,10545612,10545613,10545614,10545615,10545616,10545617,10545618,10545619,10545620,10545621,10545622,10545623,10545624,10545625,10545626,10545627,10545628,10545629,10545630,10545631,10545632,10545633,10545634,10545635,10545636,10545637,10545638,10545639,10545640,10545641,10545642,10545643,10545644,10545645,10545646,10545647,10545699,10545700,10545701,10545709,10545710,10545711,10545712,10545713,10545714,10530109,10530110,10530111,10530112,10530113,10530114,10530115,10530116,10530117,10534190,10550816,10550817,10520829,10520830,10520831,10520832,10520833,10520834,10520835,10520836,10520837,10520838,10539038,10539039,10539040,10539041,10539042,10539043,10553043,10539044,10553044,10553045,10553046,10553047,10553048,10553049,10553050,10553051,10553052,10553053,10553054,10553055,10553056,10553057,10553058,10553059,10553060,10553061,10553062,10553063,10553064,10553065,10553066,10553067,10553068,10553069,10553070,10553071,10553072,10553073,10553074,10553075,10553076,10553077,10553078,10553079,10553080,10553081,10553082,10553083,10553084,10553085,10553086,10553087,10553088,10553089,10553090,10553091,10553092,10423491,10422524,10422525,10420583,10423978,10407494,10481669,10481670,10481671,10481672,10496908,10487288,10487325,10487326,10487327,10487491,10487494,10472572) 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'