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(10962691,10962692,7076041,7076122,7076125,7076128,10939792,10943628,7076287,7076289,7076290,7076296,10940017,7068402,8569414,7068497,4970723,4970733,7068523,4970775,10940301,10976451,10976452,10976453,10976454,10933357,7066111,4968337,4968338,4968412,7066266,8067255,8067256,8067257,7074301,10964031,8067757,7066882,7066883,7066884,10437751,10964581,10964606,8067918,8067943,8067951,7067425,10962461,7067898,8065088,8065089,7072148,7072149,7072150,7072151,7072152,10931689,10960222,10960223,10960224,10960225,10960226,10960227,10960228,10960229,10931902,10960308,10960336,8065791,7064822,7064856,7064863,8065842,8065853,10932351,10932352,7073283,7065352,10932803,10932820,10932821,10932822,10932823,10932824,10933000,7065694,7065695,7065830,7065831,7065832,7065833,7065834,7065835,7065836,7065837,7065838,7065839,4968076,4968077,4968078,7065873,10958965,10958988,10959087,10959092,8064656,8064672,8064673,7071810,10959562,10959564,10944478,10944645,10944646,10940960,10941120,7069592,10941251,10941265,10941266,10941268,10945101,11047587,7069788,7069911,10941690,10941694,10941696,10941697,10941698,10941699,10941700,10941702,10941713,10941724,10941725,10941726,10941734,10941740,10941741,10941751,10941752,10941753,10941754,10941755,10941756,10941762,10941767,10941768,10941770,10941772,10941775,10941779,10941783,10941838,10942028,11048379,11048387,11048388,11048389,11048461,11048578,11048598,11048599,7070793,10928557,10623063,10623113,10623114,10623115,10623116,10928703,10928704,10954938,10618281,8070171,8070172,10623491,10623492,10623493,10623715,10623729,10623735,10624121,10624122,10624123,10619229,8070947,8070948,8070949,8070950,8070951,8070952,8070953,8070954,8070955,8070956,8070957,8070958,8070959,10619328,10624582,10624632,10624633,10619840,10619842,10619843,10619896,10617035,10927576,10927577,10927578,10953951,10617326,10617333,10617334,10617335,10617342,10617343,10617347,10617348,10617355,10617358,10622360,10617367,10617368,10617370,10617371,10954031,10617377,10617378,10617380,10617381,10617382,10617383,10617384,10617390,10617391,10617392,10617399,10617400,10617401,10622402,10617402,10617403,10617406,10617407,10622408,10617408,10617410,10617411,10617412,10617413,10617414,10617415,10617416,10617417,10617424,10617426,10622429,10617430,10617431,10617432,10617433,10617450,10617451,10617452,10617453,10617456,10617464,10617511,10954173,10622516,10954257,10928352,10622864,10622865,10614969,8569932,8569933,8569934,10615036,8570020,10620096,10615108,10615109,10620208,10615222,10615229,10620298,10620303,10615339,10615340,10615344,10620427,10620438,10620439,10620440,10926204,10930631,10930721,10620794,10620795,10615819,10930776,10615895,10615896,10930834,10930835,10930851,10615933,10615938,10615939,10615962,10616002,10616003,10616005,10616033,10616045,10616059,10616097,10952791,10616173,10616228,10616229,10952921,10616265,10616267,10616268,10616302,10616303,10616311,10616323,10616324,10616332,10616348,10616350,10616351,10616353,10616404,10616407,10616410,10616411,10616412,10616416,10616417,10616453,10616454,10616459,10922074,10922075,10922078,10922139,10922140,10922141,10922142,10922264,10922267,10922285,10922286,10922287,10922290,10616856,10616862,10616872,10616880,10610963,10610965,10613971,10613972,10613973,10613974,10613975,10613976,10613977,10613978,10613979,10613980,10613981,10613982,10613983,10613984,10613985,10613986,10613987,10613988,10613989,10613990,10613991,10613992,10613993,10613994,10610994,10613995,10613996,10613997,10565155,10565158,10565205,10565206,10565207,10614064,10565253,10565254,10565255,10565256,10565259,10611184,10611187,10611188,10611191,10611193,10611194,10614338,10611340,10611341,10611406,10611431,10611456,10611457,8864327,10614495,10614499,10614500,10614502,10611519,10614521,10614522,10614523,10614547,10614548,10559715,10559716,10559717,10611568,10611590,10559756,10611649,10611658,10611660,10611758,10611782,10611831,10611969,10611970,10612106,10612132,10612194,10612380,10612381,8862480,8862481,10609834,10609839,10609845,8862762,10612935,10612936,10609939,10612940,10609940,10609941,10609942,10609946,10612972,10609988,10613018,10610024,10610044,10613056,10610056,10613057,10610057,10613058,10613066,10613133,10613135,10558317,10613235,10610333,10610337,10613342,10610352,10610353,10613369,10613372,10610418,10613421,10613431,10613432,10610480,10610481,10613504,10613729,10610729,10613739,10613750,10610791,10610850,10610874,10610890,10610918,10610919,10610954,10515328,10513552,10513556,10513557,10513558,10513562,10513563,10513564,10515609,10515610,10515611,10515612,10515613,10517798,10518102,10518103,10518104,10518105,10518106,10518107,10518111,4975242,4975243,10512530,10518570,10518648,10518669,10518670,10518671,10518672,10518674,10518681,10512852,10516866,10513076,4973238,4973239,4973240,10416346,10419350,10416353,10416360,10416361,10416365,10416366,10416383,4973319,10416400,10416433,10416434,10419437,10419438,10419439,10417443,10417445,4973379,10419452,10419468,4973399,4973400,4973401,4973402,4973403,4973404,4973405,4973406,4973407,4973408,4973409,4973410,4973423,4973424,10419493,10419494,10419502,10419508,10419513,10419519,10417534,10418545,10415600,10415601,10415606,10415607,10415675,10419676,10415679,10419679,10415680,10419683,10419684,10419686,10419687,10419688,10418691,10418692,10419695,10419713,10419716,10419719,10419722,10419723,10419726,10419727,10419728,10419729,10415731,10415732,10415737,10419740,10419741,10419742,10419751,10419752,10415791,10415792,10418805,10415828,10419834,10419835,10419836,10419841,10419842,10419843,10418843,10418844,10418849,10418850,10419891,10419892,10419893,10419905,10419906,10420015,10420018,10420036,10420045,10417057,10417074,10417075,10417083,10417084,10417089,10420095,10420096,10420097,10420098,10417101,10417110,10419112,10417133,10417139,10417140,10417148,10418149,10417154,10417155,10417156,10417157,10419168,10419191,10419192,10420200,10420201,10420202,10463031,10463034,10463044,10467069,10467070,10467093,10467101,10467105,10467108,10467110,10467111,10467112,10467125,10467141,10467145,10467152,10471171,10467174,10467217,10467218,10467219,10467220,10467221,10463313,10463314,10469364,10469365,10469366,10469367,10469368,10469369,10469370,10469371,10463398,10463429,10463432,10467442,10467449,10467458,10467459,10467474,10467475,10463554,10463555,10469573,10463588,10463594,10463595,10463596,10469618,10463649,10463665,10463671,10465681,10465682,10465683,10463691,10463694,10465697,10465701,10465702,10465708,10465737,10463737,10465738,10463757,10463758,10463759,10465760,10463763,10463769,10463780,10465781,10465783,10465786,10465787,10463789,10465796,10465799,10465800,10467821,10463823,10465823,10463824,10463827,10463831,10467831,10467838,10465843,10465844,10465868,10465880,10463885,10465887,10465894,10465895,10465896,10463897,10465911,10465913,10463914,10467918,10463919,10467919,10463920,10467920,10465920,10467921,10465921,10467922,10467923,10467924,10467925,10467926,10467927,10467928,10467929,10467930,10467931,10467932,10467933,10467934,10467935,10463948,10463949,10469949,8563299,10463997,10463998,8563358,8563361,8563363,10464042,10470084,10466206,10466207,10466210,10466232,10466233,10468236,10468237,10466241,4972565,4972566,4972567,4972568,10466309,10466318,10466319,10466321,10466322,10466323,10462325,10466325,10462328,10466328,10462329,10466329,10466345,10466370,10466375,10466401,10462406,10462409,10462410,10462411,10466414,10462424,10462427,10464427,10466432,10466433,10462436,10462437,10466439,10466440,10466444,10462449,10462451,10462454,10462455,10462458,10462462,10462463,10466471,10466472,10462472,10462487,10462488,10462501,10462502,10462503,10466504,10462504,10462505,4972787,4972788,4972789,10462518,10462544,10462579,10462580,10462589,10462590,10462599,10462618,10462619,10466850,10466851,10466855,10628326,10628527,10628528,10628536,10627319,10627406,10627584,10627586,10627665,10627710,10627713,10627714,10627715,10627716,10627717,10627718,10627719,10627720,10627721,10627722,10627723,10627749,10627750,10627751,10627752,10627753,10627754,10627755,10627756,10627757,10627758,10627759,10627760,10627761,10627762,10627763,10627764,10627765,10627766,10627767,10627768,10627769,10627770,10627775,10627793,10626126,10626133,10626231,10626232,10626233,10626234,10626237,10626242,10626243,10626248,10626291,10626375,10626446,10626447,10626449,10626450,10626451,10626452,10626454,10626602,10626720,10626724,10626815,10626842,10626906,10626907,10626908,10626909,10626910,10626911,10626912,10626913,10626914,10626915,10626916,10626917,10626918,10626919,10626920,10568118,10568120,10568125,10568558,10566149,10567621,10567625,10568110,10568111,10520769,10520776,10520781,10520797,10420254,10420259,10420267,10420268,10420424,10420426,10420427,10420439,10420440,10420443,10420444,10420445,10420629,10420676,10420712,10420763,10420764,10420851,10421037,10472756,10472757,10472758,10472759,10472760) 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'