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(10975620,10975621,10975622,10975623,10975624,10975625,10975626,10975627,10975628,10975629,10975630,10975631,10975632,10975640,10975641,10975642,10975643,10975644,10975645,10975646,10975647,10975648,10975649,10975650,10975684,10975685,10975686,10975687,10975688,10975689,10975690,10975691,10975692,10975693,10975694,10975695,10975696,10975697,10975698,10975699,10975700,10975701,10975702,10975703,10975704,10975705,10975706,10975707,10975708,10975709,10975710,10975711,10975712,10975713,10975714,10975715,10975716,10975717,10975718,10975719,10975720,10975721,10975722,10975723,10975724,10975725,10975726,10975727,10975728,10975729,10975748,10975749,10975750,10975751,10975752,10943574,10988856,7068175,7068176,7068242,7068296,7076333,7076334,7076335,10976039,10976040,7068371,10976084,10976085,10976086,10976087,10976088,10976095,10976096,10976097,10976098,10976099,10976100,10976101,10976102,10940100,4970750,10976271,10963278,10976285,10976290,10976317,10976318,10976347,10976349,10976350,10976353,10976354,10976355,10976356,10976357,10976358,10976359,10976360,10976361,10976362,10976363,10976366,10976367,10976368,7068795,7068798,4971024,4971025,8067252,7066659,7066660,7066665,8067692,7074730,10964581,10961625,10974633,10974634,10974635,10974636,10974673,10974689,10974690,10974691,10974692,10974693,10974694,10974695,10974696,10974697,10974698,10974733,10961748,10961792,7075278,7075279,10975001,10962082,10962113,10975125,10975126,10975127,10975128,10975129,7067453,7067544,7067545,8068532,10975367,10975368,10988369,10975369,10975400,10975401,10975402,10975403,10975404,10975422,10975423,8068668,10939424,7075847,10975541,10975542,10975543,10975579,10975580,10975581,10975582,10975583,10975619,6000287,6000288,8065081,8065087,8065088,8065089,8065091,8065094,7064297,7064298,10931784,10931785,7072455,7072456,10986199,10986200,7064600,10973348,10973364,10973376,10973378,10973380,10973381,10973382,10973386,10973398,10973399,10973404,10973405,10973406,10973407,10973418,10973421,10973422,10973423,10973424,10973425,10973426,10973430,10973431,10973442,10973443,10973444,10973445,10973446,10973466,10973473,10973474,10973475,10973476,10973483,10973484,10973491,10973495,4967032,10973512,10973513,10973514,10973515,10973546,10973551,10986587,10986590,10986591,10973633,10973641,10973922,10973931,10973992,10973993,10973994,4967553,4967560,7065357,4967577,10974165,4967703,10974176,10974178,8066474,10974187,4967743,4967744,4967745,4967746,4967747,4967752,4967753,4967767,4967768,4967769,10932906,4967819,10961287,4967820,10961288,4967821,10961289,4967822,4967823,4967824,4967825,4967826,10974332,10974333,10974334,10974335,10974336,10974337,10974338,10974339,10974340,10974341,10974342,10974343,10974344,10974345,10974346,10974347,10974348,10974349,10974350,10974351,10974352,10974358,7073681,10974397,10974398,10974399,10974400,10974401,10974402,10974403,10974404,10974405,10974406,10974407,10974408,10974409,10974410,10974411,10974412,10974413,10974414,10974415,10974416,10974417,10974418,10974419,10974420,10974421,10974422,10974423,10974424,10974425,10974426,10974427,10974428,10974429,10974430,10974431,10974432,10974433,10974434,10974435,10974436,10974437,10974438,10974439,10974440,10974441,10974442,10974443,4967983,4967984,10961460,10961485,8066820,8066838,8066850,10974574,10974575,10974576,10974577,10974578,10974579,10974580,10974581,7073897,10974582,10974583,10974584,10974585,10974586,10974587,10974588,10974589,10974590,10974594,10974595,10974596,10974597,10974598,10974599,10974600,10974601,10974602,10974603,10974604,10974605,10974606,10974607,10974608,10974609,10974610,10961614,7071015,10942800,11049192,8064364,8064374,8064394,10943085,11049392,8064478,8064479,8064480,8064481,8064482,10959210,8064520,8064521,8064522,8064525,5999942,10943316,6000022,6000023,6000024,6000126,7068982,7068996,10940721,7069233,7069236,7069239,7069332,7069333,7069334,11047616,11047617,11047618,11047619,11047622,11047627,11047628,11047629,11047630,11047633,8072669,3656657,10970919,10941971,10941972,10984341,10984342,10984344,10984345,10984346,10984359,7070822,7070857,10923545,10923653,10923655,10918764,10918832,10923880,10923944,10923969,10923978,10924051,10924052,10924057,10924119,10924124,10924143,10924341,10924366,10619027,10919560,10981724,10981725,10924600,10924606,10924796,10924853,10924860,10924868,10924876,10924881,10924887,10924971,10924994,10924995,10925006,10982288,10982289,10982290,10982291,10982294,10982295,10982305,10982306,10982307,10982308,10982309,10982310,10982317,10982318,10982319,10982320,10982321,10982322,10982323,10982324,10982325,10982326,10982327,10982341,10982342,10982353,10982354,10982355,10982356,10982357,10982358,10982359,10982360,10982361,10982362,10982363,10982364,10982365,10982366,10982367,10982368,10925225,10982387,10982388,10982389,10925241,10982390,10982391,10982392,10982393,10925246,10982401,10982404,10982405,10982406,10982407,10982408,10982409,10982410,10982411,10982412,10982413,10982414,10982415,10982416,10982417,10982418,10982419,10982432,10982433,10922480,10621989,10622011,10917727,10922754,10922762,10917818,10922822,10622348,10622349,10622350,10622543,10928062,10617602,10954508,10617943,10615083,10915606,10915607,10915608,10915609,10615103,10915620,10915621,10915622,10915623,10915626,10915627,10915628,10615127,10615130,10615131,10925842,10920933,10920961,10926157,10926158,10926159,10926160,10926161,10926162,10926163,10926164,10926165,10926166,10926167,10926168,10926169,10926170,10926171,10926173,10926178,10620701,10965390,10965391,10615833,10615860,10930972,10616211,10616216,10616217,10616218,10978881,10965881,10616265,10616266,10616267,10616268,10616269,10616270,10616284,10616285,10616286,10616287,10616288,10953194,10917051,10917053,10953202,10953240,10953252,10953254,10953259,10953263,10953275,10953288,10953307,10953313,10953319,10953321,10953322,10953323,10953325,10953327,10953328,10953329,10953348,10966352,10953426,10953427,10953428,10953429,10966436,10966438,10953589,10953590,10953591,10953592,10953593,7059606,10614123,10614124,10614125,10611203,10611361,6665759,8864296,10562633,10562634,10562635,10562636,10562637,10562638,10562639,10562640,10562641,10562642,10562643,10562644,10562645,10562646,10562647,10611699,10611702,10611705,10611706,10611707,8864667,10560003,10560007,9166213,10560056,7057503,10609356,10609357,8862848,8862849,10613097,10613099,10613101,10613103,10613105,10613106,10613107,10613108,10613109,10610300,8863239,10610488,8863365,8863446,8863448,8863451,9161319,9161320,9161321,4974286,4974288,10513386,4974712,4974809,4974830,7056248,7056249,7056250,7056274,7056279,7056285,2809138,7057010,7057012,7057013,7057014,7057015,8861728,10513071,10513072,10513073,10513074,8861799,9160962,9160963,9160982,4973866,9161023,9161056,9161057,9161135,9161136,9161137,9161138,9161139,9161140,9161141,8864838,8864904,8864905,8864906,8864907,8864915,8864916,8864918,8864920,8864921,8864922,10463023,10463025,10463026,10463027,10463035,10463045,10463046,10463050,10463051,10463052,10463054,10463075,10463099,10463116,10463158,10463162,10463184,10463185,10463187,10463188,10463189,10463192,10463199,10463200,10463221,10463308,10463309,10463310,8916402,10469438,10469439,10463575,10463576,10463577,6666999,10463578,10463579,10463580,10470271,10468355,10628012,10628013,10628014,10628015,10154659,10154718,10154747,10154760,10154780,10154827,10628328,10628329,10628335,10628336,10154858,10628337,10628338,10154865,10154914,10154984,10155016,10155023,10155024,10155025,10155026,10155027,10155028,10155030,10155031,10155032,10155034,10155035,10155058,10628578,10628579,10155111,10155171,10155182,10155232,10155338,10155339,10155340,10155341,10155342,10155343,10629339,10629343,10629344,10629345,10627007,10627008,10627009,10627010,10627011,10158719,10629971,10630050,10630311,10630456,10630503,10631040,10626195,10631238,10631239,10631240,10631241,10631242,10631243,10631244,10631245,10631885,10571283,10571284,10568357,10574441,10570275,10570276,10570281,10570282,10570283,10573460,10573461,10573462,10573463,10573464,10573465,10573466,10573467,10573468,10573469,10573470,10573471,10573472,10570501,10570502,10570503,10570504,10570505,10570506,10570507,10570508,10570509,10570510,10570511,10570512,10570547,10567720,10567721,10567722,10567723,10567724,10567725,10567726,10567727,10567728,10567729,10567730,10567731,10567732,10567733,10567734,10567735,10567736,10567737,10567738,10567739,10567740,10567741,10567742,10567743,10567744,10567745,10567746,10567747,10571017,10571062,10523116,10523117,10523118,10523119,10523120,10523121,10521291,10521292,10521848,10522214,10520827,10520836,10523098,10523099,10523100,10523101,10523102,10523103,10523104,10420861,10420862,10420863,10421970,10422002,10422007,10422008,10422038,10422039,10422050,10422064,10422121,10475703,10474660,10474661,10474662,10474663,10474664,10474665,10474716,10474717,10474718) 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'