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(7075951,8068895,3228617,9214881,9214882,9214883,9214884,9214885,10846037,10846038,8574521,10963054,8631055,4970684,4970724,10989205,4970771,4970772,10940224,8631275,8631278,8631279,8631280,8631281,8631282,8631283,8631284,8631285,10940293,8583140,10950324,3229136,3229152,10976442,10976443,10976444,10976445,10976446,10976447,10976448,10976449,8621630,10976651,10976652,10976653,10976654,10976655,7065978,10950739,8631782,8631785,8067171,10950890,10950972,3229955,10977254,10977255,10977256,10977257,10977258,10977259,10977260,10977261,10977262,10977263,10977264,10977265,8632227,10977266,8622473,8609638,8067785,10847611,10938603,10938604,10962083,10962084,10962085,10962086,10962087,10962088,10962089,7067583,7075796,8630442,8630443,8630444,8630445,8630446,8630447,8630448,8630450,8630451,8630453,7075813,7075909,8594701,11011820,7201527,10960009,7064492,8075249,10103653,8618476,10973326,11038327,10103869,10104239,10932473,10986859,10986860,8628840,8628841,8066180,8066181,4967453,4967454,10932879,8619388,8596301,7073764,10933252,11036636,10942575,10102092,10102093,7200320,7200321,7071106,7071107,7200380,7071147,11036837,11036898,11036913,11036914,11036923,11036924,11036925,10958966,10958967,10958971,10958987,10958988,10958989,11036989,10959118,8910565,8910566,11049475,8627222,4430201,10943242,10998303,8627294,8627298,10959499,8624659,7198299,8563774,10839884,3235608,3235609,8615029,8615030,7198539,8624966,8624967,11035023,8625002,10941034,7198772,11009496,3236285,10996795,3656704,3926612,3926615,3926670,7199524,3656875,10941995,10942012,10841189,10101573,10841237,10841238,10841239,10841240,10841241,10841242,10841243,10841244,10841245,10841246,10841247,10841248,10841249,10841250,10101653,7199792,7199827,10971280,10971281,10971285,7199929,7070685,10971440,10971441,7070789,8073542,7070827,7200098,10837696,10837697,10837698,11045737,11045738,11045739,11045740,11045741,11045742,11045754,10980873,10837977,4936986,7196587,10623423,7196694,10968219,7196784,8906601,7196867,7196868,7196880,11007319,7196937,10994378,7196951,7196952,8906770,7157351,10838661,3924302,11007694,10981857,7197420,11007890,11007891,7197708,7197711,8071234,3235013,3235314,10839663,10922483,8541489,10927572,10927581,11044744,10617095,8611921,10927684,8541660,10927685,10617206,10622306,10622307,10622308,10622309,10622310,8634934,10617319,8905426,8541898,8905467,8905477,10622451,11045197,11045198,11045199,11045212,11045213,11045214,8542077,11006263,11006265,8542132,10993304,8542133,10993305,10993306,10993307,10993308,10993309,8542137,10993310,10993311,10993312,10993313,10993314,10993315,10993316,10993317,10993318,10993319,10993320,10993321,10993322,10993323,10993324,10993325,10993326,10993327,10993328,10993329,10993330,10993331,10993332,10993333,10993334,10993335,10993336,10993337,10993338,10993339,10993340,10993341,10993342,10993343,11032492,8612652,10967514,8632597,10951611,10990721,10990722,10990723,10990724,10990725,10615192,10615198,10847927,10615206,10847935,10847936,10964939,3230718,3230719,11017068,11017069,10915934,10915935,10915936,10915937,10915938,3581872,3581873,3581882,11043230,11043231,10926113,10965291,10426011,10620778,10991444,3231191,3231208,10615820,10620896,10620937,10620938,10952626,10991691,10991692,8540539,8540540,8540611,11043826,10952929,8904408,10616474,10953212,10621576,10621577,10621578,10621579,8541120,10616641,10616642,10616643,8904709,10616699,10922210,10616700,10922211,10922212,10922213,8541248,10616790,10616791,10616804,8541295,8904870,10616912,7018967,10610979,10611035,9205436,7059643,7059726,7059727,6669783,10611241,6669790,6669812,6669813,6669814,8568173,10714194,6670059,6670060,6670061,6670062,6670063,7019538,10614552,10614553,10614554,9173910,10714390,10714391,10611642,10611650,10611651,10611659,10122200,10122207,9166022,6670234,6670235,10122324,10122325,10122326,10122327,9198149,9198150,9198151,9198152,10614819,6670375,6670376,6670377,10122381,7024953,7024963,6675556,10609076,10609077,9171448,10563420,10563421,10563422,9179693,10612475,9211878,9211915,8862516,9212025,8862574,8862575,8862577,10609764,10609765,10612788,10612789,10612790,10612791,10612792,10612793,10612794,10557977,10120364,9188222,8566749,10613052,8567054,10120855,9204729,10610437,9196802,9196908,9196942,10121176,8567515,10613713,7018755,8863700,10117557,9177371,10125605,7055590,7055591,9185491,9169497,9177592,10117853,10117854,10117855,10117856,10117871,9177805,9169848,10126056,9185881,9169886,9177897,9177898,9161955,7056160,6674216,990461,990463,9186077,7056338,9210194,9210195,4975054,4975055,4975056,4975057,4975058,4975059,7056383,10514109,10514110,10514111,9186409,10118630,10118649,990887,9210527,7056824,7056825,6674908,9186722,9186723,9186724,9186725,9186726,9186727,9186728,9186729,9186730,9186731,991194,10518669,10518670,10518671,10518672,9170956,991347,9202966,9202967,9202968,991357,991390,8565601,8861647,8861648,8861649,8861689,9168328,4973190,4973191,4973192,9160339,9160341,9160342,9160343,9160348,4973244,9168468,9168469,9168470,9168471,9168472,9168493,7014153,7014154,9168522,6672803,9168672,9168673,9168789,10416716,9176807,10415731,10415741,9160820,9160821,9160822,4973737,4973738,9160957,9160958,10418954,7014693,10419049,9193224,7055396,7055420,7055460,10462930,10462931,10469007,9182471,9182474,10463072,10471085,8549779,8549780,8549781,10467327,8550072,10469496,6666948,9199044,9175050,8550206,10467652,9199086,8550248,8550262,6667165,10463914,10463917,10463918,10115612,10115615,7021154,7021165,10123737,10123738,10123747,10470151,10468174,9183626,8917281,10466313,10466314,10466315,10464334,10466338,10466357,10466358,10466359,10466370,10466391,10466400,10464411,10464419,10466460,9207907,9207950,6667955,9191993,9191994,10462615,9168059,10470698,10468737,9168191,10184533,10184534,10184535,10883563,10184620,10184621,10184622,10159917,10884096,10889287,8594346,10899375,10175515,10175516,10175517,10889543,10884576,10889615,10894657,10894658,10889841,10889954,10889955,10885003,10885004,10875007,10875011,10875012,10885061,10890194,10885228,10880257,10880258,10875283,10166318,10166319,10166320,10166321,10166322,10166323,10166334,10171338,10166449,10166455,10166456,10877572,10887654,10945616,10945617,10882832,10183853,10892872,10945796,10945852,10184175,10184176,10154395,10154396,10154397,10154398,10154399,10154426,10888449,10885660,10895762,10895763,10895764,10895765,10172105,10172106,10172107,10172108,10172109,10172110,10172111,10172112,10172113,10172114,10172115,10172116,10172117,10172118,10172119,10172120,10172121,10172122,10172123,10896117,10876131,10876132,10876133,10876134,10876135,10896221,10896222,10896223,10896224,10896225,10896226,10625753,10886267,10876347,10896382,10896397,10187494,10626148,10167969,10882001,10882035,10178223,10178234,10178235,10950075,10877289,10877290,10877291,10877292,10877293,10950161,10892392,10626884,10626885,10945235,10601379,10643553,10568685,10643765,10643766,10643916,10643917,10599315,10647498,10587460,10584560,10587859,10587860,10587861,10587862,10587863,10587864,10590992,10590993,10651386,10651387,10651388,10651389,10651412,10591389,10591390,10591391,10591392,10591393,10591394,10591395,10591396,10591397,10570655,10570656,10570657,10573802,10579807,10579808,10579874,10648970,10649026,10649027,10568097,10568098,10568099,10568100,10527258,10543276,10543277,10543278,10543279,10543280,10543281,10527318,10531665,10531666,10531667,10531668,10531669,10531670,10531671,10531672,10519854,10519855,10519856,10539862,10545952,10545953,10545954,10528179,10528180,10528260,10528407,10532658,10530707,10530708,10532765,10532766,10532767,10532768,10532769,10532770,10532771,10532772,10532773,10532774,10532775,10532776,10532777,10532778,10532779,10532780,10532781,10532782,10532783,10532784,10532785,10532786,10532787,10532788,10532789,10532790,10532791,10532792,10532793,10532794,10532795,10532796,10532797,10532798,10532799,10532800,10532801,10532802,10532803,10532804,10532805,10532806,10532807,10532808,10532809,10532810,10532811,10532812,10538917,10421578,10424613,10423718,10423719,10506757,10506758,10506759,10421941,10421942,10422028,10421041,10422138,10409308,10479013,10479014,10409436,10407455,10407456,10407457,10407506,10409519,10407519,10488193,10492400,10492401,10492402,10492403,10492404,10492405,10492406,10492407,10492408,10492409,10492410,10492411,10408034,10408035,10408036,10473692,10483709,10483710,10473866,10473873,10492896,10492897,10492902,10492903,10492904,10491028,10491029,10491030,10491031,10491032,10491033,10491034,10410584,10474273,10474274,10410627,10410628,10410630,10408673,10474442,10480443,10474443,10480444,10474444,10480445,10474445,10474446,10474447,10474448,10474449,10406915,10406916,10489665,10409101,10478848) 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'