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(10939535,10939536,10939539,10939541,10939542,10939552,10939670,10939674,7068074,7068114,7076207,10940009,10940032,10940035,10940036,10940041,10940052,10940056,10940063,10940064,10940065,10940067,10940068,10940069,10940070,10940072,10940073,10940074,10940078,10940088,10940089,10940090,10940091,10940096,10940097,8569388,8569396,8569397,8569399,8569400,8569401,8569403,8569429,10940202,10940204,8569470,8569477,8569479,8569481,10940246,10940248,10940249,10940250,10940251,10940252,10940253,10940254,10940255,10940258,10940264,8569540,8569542,10940292,10940302,10940305,10940306,10940309,8569622,10940365,10940394,10940431,10940433,10940435,8569704,8569705,10940459,10940460,7066102,7066222,10938479,10938480,10938481,10938503,10938504,10938505,10938506,10938507,7066792,10938508,10938509,10938510,10938512,10938526,10938546,10938551,10938552,10938553,10938554,10938555,10938556,10938557,10938558,10938559,10938560,10938561,10938562,10938563,10938566,10938568,10938569,10938577,10938578,10938580,10938586,10938587,10938588,10938589,10938590,10938591,10938592,10938593,10938594,10938595,10938597,10938598,10938601,10938602,10938603,10938607,10938608,10938625,10938629,10938630,10938631,10938632,10938633,10938639,10938641,10938642,10938643,10938644,10938645,10938646,10938648,10938652,10938653,10938654,10938658,10938659,10938660,10938661,10938662,10938663,10938665,10938666,10938667,10938671,10938672,10938673,10938680,10938683,10938684,10938701,10938702,10938703,10938744,10938745,10938798,10938802,10938807,10938809,10938810,10938811,10938812,10938815,10938816,10938817,10938818,10938928,10938929,10938932,10938933,10938934,10938935,10938937,10938938,10938939,10938944,10938945,10938946,10938947,10938948,10938950,10938951,10938953,10938955,10938958,10938964,10938965,10938972,10938973,10938984,10938985,10939011,10939023,10939036,10939040,10939041,10939042,10939115,10939130,10939131,10939132,10939133,10939134,10939135,10939136,10939137,10939139,10939140,10939141,10939142,10939143,10939144,10939145,10939151,10939155,10939156,10939157,10939158,10939162,10939165,10939166,10939168,10939169,10939185,10939194,10939199,10939200,10939209,10939210,10939219,10939222,10939224,10939225,10939229,10939230,10939231,10939232,10939235,10939236,10939237,10939238,10939239,10939241,10939242,10939243,10939244,10939245,10939246,10939248,10939249,10939251,10939254,10939255,10939256,10939257,10939258,10939259,10939260,10939262,10939263,10939264,10939265,10939266,10939271,10939273,10939275,10939276,10939279,10939280,10939281,10939282,10939285,10939286,10939287,10939288,10939289,10939290,10939291,10939292,10939293,10939294,10939295,10939296,10939298,10939299,10939301,10939302,10939303,10939304,10939305,10939307,10939308,10939310,10939311,10939312,10939313,10939315,10939316,10939317,10939318,10939319,10939321,10939325,10939326,10939327,10939329,10939332,10939337,10939338,10939339,10939340,10939341,10939342,10939344,10939345,10939346,10939347,10939348,10939349,10939350,10939351,10939352,10939353,10939354,10939355,10939357,10939358,10939359,10939360,10939487,10939488,10939501,10939502,10939503,10939504,10939505,10939508,10939509,10939512,10939513,10939514,10939515,10939516,10939519,10939520,10939521,10939525,10939526,7072006,7064121,7064122,7064130,7064131,7064136,7064138,10931620,7064235,7064262,7064330,7064425,10931897,7064532,7064533,7064534,7064606,7064656,7064670,7064692,10932570,10932571,10932572,10932573,7065156,7065193,7065194,7065224,7065225,10932711,7065496,7065527,7065533,7065543,7065547,7065553,7065559,7065561,7065562,7065563,7073634,7073635,7070861,10942643,8970213,8970214,8970225,10940580,10940583,10940584,10940585,10940618,10940619,10940655,10940657,10940658,10940659,10940660,10940665,10940667,10940668,10940669,10940672,10940675,10940677,10940681,10940782,7069164,7069168,10940926,10940936,10940983,10940984,10941001,10941008,10941010,10941019,10941020,10941021,10941022,10941035,7069562,7069570,7069571,7069595,10941358,10941359,10941361,10941362,10941366,10941368,10941377,10941379,10941387,10941393,10941395,10941413,3656389,10941414,10941419,7069705,10941421,10941440,10941441,10941444,7069731,10941467,10941469,10941470,10941471,7069777,7069778,10941575,10941576,10941577,10941602,10941606,10941607,10941638,10941641,10941643,10941644,10941729,10941732,10941733,7070108,7070135,7070212,7070218,7070227,7070230,7070232,7070247,10942022,10623069,10623098,10623235,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623322,8070031,10623323,10623324,10623325,10623326,10623327,10623328,10623329,10623330,10623331,10623332,10623333,10623334,10623335,10623336,10623337,10623338,10623339,10623340,10623341,10623342,10623343,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623395,10623396,10623397,10623398,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,10623505,10623510,10623511,10623512,10623515,10623524,10623525,10623526,10623529,10623544,10623545,10623546,10623550,10623554,10623555,10623556,10623558,10623559,10623560,10623561,10623562,10623563,10623564,10623587,10623588,10623589,10623590,10623632,10623633,10623634,8070759,8070760,8070761,8070762,8070763,8070765,10624898,10624901,10624902,10624904,10624905,10624906,10624907,10624910,10624911,10624912,10624913,10624914,10624919,10621966,10621971,10621972,10621975,10622155,10622156,10622157,10622169,10622170,10622171,10622172,10622185,10622199,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622384,10622385,10622386,10622387,10622388,10622389,10622390,10622391,10622392,10622393,10622394,10622395,10622396,10622397,10622398,10622772,10622927,10925633,10925635,10925636,10620164,10620186,10620187,10620188,10620189,10620190,10620191,10620192,10620193,10620194,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10620203,10620204,10620205,10620206,10620207,10620208,10620213,10620214,10620232,10620253,10620254,10620255,10620256,10620257,10620258,10620259,10620267,10620283,10620284,10620285,10620327,10620441,10620442,10620443,10620444,10620465,10620467,10620483,10620537,10620538,10620540,10620563,10620585,10620591,10620592,10620593,10620594,10620595,10620596,10620597,10620598,10620599,10620600,10620601,10620602,10620603,10620604,10620605,10620606,10620607,10620608,10620609,10620610,10620611,10620612,10620613,10620614,10620615,10620616,10620617,10620618,10620619,10620620,10620621,10620622,10620623,10620628,10620708,10620742,10620855,10620856,10620933,10620934,10620935,10620936,10620964,10620981,10620982,10621103,10621229,10621751,10621957,10621959,10621960,10611000,10611001,10611002,10611003,10611004,10611005,10611006,10611007,10611008,10611009,10611010,10611011,10611016,10611017,10611018,10611019,10611020,10614074,10614378,10614419,10614420,10614421,10614422,10614423,10614497,10614498,10614538,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10614558,10614592,10614619,10611855,10609120,10609122,10609123,10609124,10612313,10612343,10612344,10563556,10609406,10563557,10563558,10612480,10609709,10609913,10609955,10609957,10609961,10609962,10609963,10609964,10609972,10609973,10609974,10609975,10609976,10609977,10609978,10609979,10609980,10609981,10609982,10610022,10613023,10613027,10610272,10610295,10610315,10610316,10610317,10610318,10610319,10610320,10610335,10610336,10610337,10610338,10564549,10564550,10564551,10613403,10613636,10613637,10613639,10613640,10613641,10564838,10564839,10613799,10613800,10610837,10613935,10513970,10513971,10513972,10513973,10512171,10512172,10514830,10514831,10467115,10463592,10463827,10463896,10465899,10463906,10463923,8563554,8563555,10466340,10466347,10466406,10466413,10462424,10466427,10466443,10466446,10462475,10462486,10462508,10462509,10462537,10462540,10462581,10462617,10462627,10462756,10466854) 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'