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(8068800,8068801,7067833,8068852,8068853,4970736,10944053,10944054,7068598,10940517,8066891,8066901,8066902,8066903,8066904,8066916,8066917,8066918,8066919,8066920,7066042,4968638,4968639,4968640,4968641,10437259,10437329,10437330,10437334,10437339,10437340,10437341,8067526,8067531,8067554,8067561,8067562,8067563,8067564,8067565,8067566,8067567,8067568,8067569,8067570,8067571,8067572,8067573,10437498,10938478,10938511,10938512,10437753,4969289,4969290,4969291,4969292,4969293,8067978,8067979,8067980,8067981,8067982,7067009,7067050,8068040,8068041,8068098,8068099,8068100,8068101,8068102,8068103,8068104,8068105,8068106,8068107,8068108,7067175,7067176,8068190,8068191,8068192,8068193,8068194,8068195,8068196,4969550,8068197,8068198,4969551,4969552,8068199,8068200,4969553,8068201,8068202,8068203,8068204,8068205,8068206,8068207,8068208,8068209,8068210,7067228,7067229,7067230,7067231,7067232,4969570,7067240,8068272,8068273,8068274,8068275,8068276,8068277,8068278,8068279,8068280,8068281,7067317,8068303,8068419,8068540,8068541,8068542,8068543,8068544,8068545,8068546,8068547,8068548,8068549,8068550,8068551,8068552,8068553,8068554,8068555,8068556,8068557,8068558,8068611,7067635,7067636,7067637,7067638,8068651,8068652,8068653,8068654,8068655,8068656,8068657,8068658,7067677,8068689,8068706,8068707,8068708,8068720,8068721,8068752,8068772,6000145,6000146,6000147,6000148,7064102,8065177,8065178,8065179,10931556,10931557,10931901,10931903,10931905,10931906,10931977,10931978,10931979,10931980,10931981,10932002,10932003,10932004,10932005,10932007,4967162,4967163,4967164,4967165,4967166,10932274,10932281,10932422,10932423,10932424,10932425,10932426,10932476,10932484,8066279,10932650,10932651,10932652,10932653,10932654,10932655,10932656,10932657,10932658,10932659,10932660,10932673,10932674,10932675,10932676,10932677,10932678,10932679,10932680,10932681,10932682,8066316,8066317,8066342,8066361,10932777,10932808,10932811,10932812,10932836,10932862,8066517,8066518,8066519,8066561,8066583,8066584,8066585,8066586,8066587,8066588,10932964,10932965,10932980,10932981,10932982,10932983,10933006,8066682,8066683,8066684,8066685,8066686,8066687,8066688,8066689,8066690,8066691,10933097,10933098,10933099,10933100,10933101,10933102,10933103,10933104,10933105,10933106,10933107,10933149,8066789,8066790,8066791,8066792,8066793,8066794,8066795,10933165,8066849,8066850,8066851,8066852,8066853,8066854,8066855,8066856,8066857,8066858,8066859,8066860,8066883,10942631,8861000,8861007,8861008,8861009,8861010,8861011,10942823,8861012,10942824,8861176,8861177,8861315,10943152,8074307,8074308,8074309,8074310,8074311,8074312,8074313,8074314,8074315,8074316,8074317,8074318,8074319,8074320,8074321,8074322,8074323,8074324,8074325,8074326,8074327,8074328,8074329,8074330,8074331,8074332,8074333,8074334,8074335,8074336,8074337,8074338,8074339,8074340,8074341,8074342,8074343,8074344,8074345,8074346,8074347,8074348,8074349,8074350,8074351,8074352,8074353,8074354,8074355,8074356,8074357,8074358,8074359,8074360,8074361,8074362,8074363,8074364,8074365,8074366,8074367,8074368,8074369,8074370,8074371,8074372,8074373,8074374,8074375,8074376,8074377,8074378,8074379,8074380,8074381,8074382,8074383,8074384,8074385,8074386,8074387,8074388,8074389,8074390,8074391,8074392,8074393,8074394,8074395,8074396,8074397,8074398,8074399,8074400,8074401,8074402,8074403,8074404,8074405,8074406,8074407,8074408,8074409,8074410,8074411,8074412,8074413,8074414,8074415,8074416,8074417,8074418,8074419,8074420,8074421,8074422,8074423,8074424,8074425,8074426,8074427,8074428,8074429,8074430,8074431,8074432,8074433,8074434,8074435,8074436,8074437,8074438,8074439,8074440,8074441,8074442,8074443,8074444,8074445,8074446,8074447,8074448,8074449,8074450,8074451,8074452,8074453,8074454,8074455,8074456,8074457,8074458,8074459,8074460,8074461,8074462,8074463,8074464,8074465,8074466,8074467,8074468,8074469,8074470,8074471,8074472,8074473,8074474,8074475,8074476,8074477,8074478,8074479,8074480,8074481,8074482,8074483,8074484,8074485,8074486,8074487,8074488,8074489,8074490,8074491,8074492,8074493,8074494,8074495,8074496,8074497,8074498,6000033,6000034,6000035,6000036,6000037,6000038,6000039,6000040,6000041,6000043,6000044,6000045,6000046,6000047,6000048,6000049,6000050,3655777,3655778,3655837,10944698,10944699,10944700,10944701,10944891,10944926,10944927,3656440,3656441,3656442,3656629,3656682,3656824,8073078,10942170,10942171,8860402,8860423,10942285,10942309,8860560,8073530,8073532,10942528,10623256,10623257,10623336,10623430,8070846,8070847,8070975,8070976,8070987,8070988,10920230,10920231,10920232,10920233,10920234,10920235,10920236,10920237,10922502,10922503,10922504,10922505,10922516,10917557,10917558,10917559,10922600,10922604,10922605,10922618,10622426,10622427,10622428,10622429,10622430,10922948,10928148,10916021,10916022,10916151,10916152,10916153,10916154,10916155,10916156,10916157,10916158,10916159,10926160,10916160,10916161,10916162,10916163,10916164,10916165,10916166,10926167,10916167,10926174,10926186,10926194,10926198,10926207,10621074,10621075,10621296,10621297,10621298,10621299,10621316,10621317,10621318,10621319,10621321,10621397,10621398,10621399,10621425,10621435,10621436,10621437,10621456,10621457,10621458,10621513,10621514,10621537,10621538,10621539,10621540,10927069,10927075,10621569,10621575,10621584,10621639,10621648,10621671,10621672,10621673,10621674,10917196,10621696,10927223,10927224,10927225,10917231,10917232,10621722,10621723,10621724,10621725,10621726,10621727,10922279,10922280,10922281,10922300,10922306,10922324,10922325,10922326,10922353,10922354,10922355,10922356,10565190,10565191,10559327,10559328,10559329,10559330,10611186,10611318,10611319,10559633,10559634,10559709,10614566,10614567,10559728,10559729,10559752,10565893,10565894,10565895,10565896,10565897,10565898,10565899,10565900,10565901,10565902,10565903,10565904,10565905,10565906,10565907,10565979,10565980,10565981,10565982,10565983,10565984,10565985,10611835,10565986,10565987,10565988,10565989,10565990,10565991,10565992,10565993,10565994,10565995,10565996,10565997,10565998,10565999,10566000,10566001,10566040,10566041,10566042,10566055,10563426,10563427,10563428,10563429,10563430,10563431,10563432,10563433,10563434,10563435,10563436,10563437,10563438,10563439,10563440,10563441,10563442,10563443,10563444,10563445,10557514,10612526,10612651,10557821,10557822,10557823,10557824,10557825,10557826,10557827,10557828,10557829,10612853,10613079,10613080,10610258,10610318,10610319,10610375,10610395,10564627,10564628,10564629,10564630,10564631,10564632,10564633,10564634,10564635,10564636,10564637,10564638,10564639,10564640,10564641,10564642,10564643,10564644,10564699,10564700,10564701,10564702,10564703,10564704,10564705,10564706,10564707,10564708,10564709,10564710,10564711,10564712,10564713,10564714,10564715,10564716,10564717,10564718,10564719,10564720,10564721,10564722,10564723,10564724,10564725,10564726,10564727,10564728,10564729,10564730,10564731,10564732,10564733,10564734,10565047,10565048,10565049,10565050,10565051,10565052,10565053,10565054,10565055,10565056,10565057,10565058,10565059,10565060,10565092,10565093,10565094,10565095,10565096,10565097,10565098,10565099,10565100,10565101,10565102,10565103,10565104,10565105,10565106,10565107,10565108,10511112,10511113,10511114,10511149,10511150,10511151,10511158,10511159,10511160,10511161,10511162,10517319,10511463,10517550,10517617,10517618,10511633,10517707,10517708,10517709,10517710,10517711,10517712,10517713,10511730,10511731,10511734,10511735,10511970,10511971,10511972,10511973,10511974,10511975,10511976,10511977,10511978,10511979,10511980,10511981,10511982,10511983,10511984,10512071,10512143,10512148,10518641,10518642,10512751,10512752,10512765,10512773,10512774,10512775,10512776,10512777,10512778,10415237,10415238,10416336,10416629,10415818,10419908,10419909,10419910,10419911,10419912,10419913,10419914,10419915,10419916,10415918,10416920,10419957,10417020,10417028,10416102,10416103,10420162,10420163,10420180,10417181,10417182,10417183,10417184,10417185,10417186,10417187,10417188,10417189,10420189,10417190,10417191,10417192,10417193,10420194,10417194,10417195,10417196,10417197,10417198,10417199,10417200,10417201,10420201,10417202,10417203,10417204,10420207,10420211,10420214,10465757,8563205,10469888,8563282,8563283,8563284,8563285,8563286,8563287,8563288,8563289,8563290,8563291,8563292,8563293,8563294,8563295,8563296,8563357,10470064,10470069,10470075,10462330,10462331,10470644,10470645,10470648,10470649,10470650,10470651,10470653,10462772) 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'