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(10198190,4970672,4970684,4970698,4970716,4970727,4970739,4970744,4970772,10198688,10198689,10198736,8569556,7065993,4968342,10199361,10199362,7066124,10199363,10199364,10199376,10199377,10199378,10199379,10199380,10199381,7066147,7066148,7066156,7066168,7066180,7066216,10199462,10437196,10225928,8067939,4969548,7067660,7067661,7072068,10195450,10195451,10221654,10221655,10221656,10221657,7064502,7064503,7064504,10195982,10196164,10196378,10196427,10196428,10196429,10196432,10196433,10194264,10233727,10233728,10233729,10233730,10233731,10233732,10233733,10233734,10194848,10194856,10194866,10194867,10194868,10194876,10194999,10195014,10941117,8860343,8860361,8860374,8860378,8860381,8860397,8860400,8860444,10190097,10190117,10190123,10190124,10190125,10204300,10204301,10204302,10204303,10204304,10204305,10204306,10204307,10204308,10204312,10204313,10619887,10616981,10616982,10616991,10622031,10617158,10617196,10617201,10617262,10622272,10617297,10617314,10617319,10617330,10622343,10622361,10622362,10617375,10617376,10622378,10622400,10622427,10622429,10622433,10622434,10622438,10622439,10617445,10622446,10617452,10617460,10617499,10622521,10928078,10928086,10614973,10614974,10614976,10614978,10614979,10614982,10614983,10614991,10614992,10614993,10615013,10615020,10615066,10615067,10615068,10615069,10615070,10615088,10615120,10615121,10615123,10615124,10615143,10615146,10615147,10615148,10615149,10615150,10615151,10615174,10615175,10615176,10615219,10615220,10615225,10615229,10615232,10615240,10615241,10615242,10615312,10615327,10615501,10615520,10615543,10620651,10615700,10615729,10615737,10615760,10615819,10615911,10615928,10615946,10616038,10616047,10616092,10616205,10188361,10188363,10616372,10616373,10616374,10616375,10616376,10616377,10616378,10616379,10616380,10616381,10616382,10616383,10616384,10616385,10616386,10616387,10616388,10616389,10616390,10616391,10616392,10616393,10616394,10616395,10616396,10616397,10616398,10616399,10616400,10616401,10616402,10616403,10616404,10616405,10616406,10616407,10616408,10616409,10616410,10616411,10616412,10616413,10616414,10616415,10616416,10616417,10616418,10616419,10616420,10616421,10616422,10616423,10616424,10616425,10616426,10616427,10616428,10921968,10201612,10201614,10201615,10616548,10616565,10616566,10616567,10616569,10616574,10616575,10616632,10616719,10616729,10201838,10616782,10616802,10616803,10616880,10616913,10565127,10614011,10614024,10614050,10562246,7059643,7059644,10614181,10614182,9165547,9165548,9165549,10614215,10614216,8864102,10614317,10614327,10614328,10614329,10614330,10614356,10614416,10614426,10614427,10614428,10614429,10614430,10614431,10614432,10614433,10614434,10614435,10614436,10614437,10614438,10614439,10614505,10614514,10614515,10614520,10614522,10614523,10614534,10614550,10614572,10559727,10559728,10559729,10559744,10614595,10559748,10559749,10559750,10614600,10559751,10559752,10614611,10614612,10614613,10614614,10614615,10614616,10614628,10614629,10614638,10614655,10614656,10614657,10614658,10614659,9166039,9166043,9166049,10614737,9166113,9166114,9166115,9166116,10614787,10614788,9166135,10614811,10614821,10614830,10614831,10614832,10614833,10614834,10614835,10614836,10614849,10614866,10614872,10614873,10614886,10614890,10614893,10614894,10614895,10614896,10614905,10614908,10614910,10614912,10614913,10614914,10614919,10614938,10614940,10614941,10614942,10614943,10612039,10612046,10612047,10612050,10612069,10612094,10612210,10612249,10612250,10612260,8862143,9171641,10612344,10612381,10612406,10612438,10612483,10612487,10612490,10612491,10612492,10612499,10612505,10612516,10612529,10612532,10612556,10612566,10612567,10612601,10612625,10612626,10612631,10612645,10612646,10612647,10612648,10612649,10612650,10612651,10612653,8862513,8862516,10612663,10612666,10612667,10612668,10612677,10612679,10612680,10612699,10612704,10612706,10612710,10612717,10612718,10612727,10612728,10612729,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612737,10612738,10612741,10612749,10612750,10612751,8862611,10612752,10612753,10612755,10612766,10612782,10612783,10612784,10612785,10612786,10612787,10612788,10612789,10612790,10612791,10612792,10612793,10612794,10612795,10612796,10612800,10612801,10612802,10612803,10612807,10612827,10612828,10612842,10612857,10612863,10612869,10612871,10612881,10612890,10612943,10612963,10612982,10613072,10613119,10613187,10613228,10613230,10613280,10613305,8863253,10613406,10613512,10613559,10613564,10613566,10613567,10613572,10613576,10613607,10613682,10613683,10613798,10613846,10613956,10515126,10515127,10515128,7055490,9169330,7055499,7055504,9169365,9169384,9169385,9169386,9169391,9169395,9169409,9169437,9169449,9169453,7055643,10515290,10515291,10515292,10515293,10515294,10515295,10515296,10515297,10515298,10515299,10515300,10515301,10515302,10515303,10515304,7055666,10515317,10515318,10515319,10515320,10515321,9169511,7055724,9169639,9169656,9169668,9169701,9169824,9169842,10517656,9169848,10517681,9169886,9169887,9169894,9169947,9169950,9169952,9169953,9169966,9169987,9170065,10513988,2809380,10512774,10512775,9168310,10419254,10419257,10416262,10416274,10416275,9168364,10416294,10418298,10419303,10419306,10419307,10419308,10419309,9168388,10419310,10419311,10419312,10419313,10419314,10419315,10419316,10419317,10416318,10419318,10416319,10419319,10419320,10416320,10419321,10419322,10419323,10419324,10419325,10416325,10419326,10419327,10419328,10419329,10416330,10419333,10419342,10418346,10419349,10418349,9168436,10419362,10416364,9168443,10416365,9168444,10416366,10416369,10419377,9168461,10416383,10416384,10417385,10416385,10416386,9168465,10416387,9168466,9168468,9168469,9168470,9168471,9168472,10416397,10419399,10416400,9168480,10416405,10416411,10419413,10419414,9168493,10416429,10419430,10416431,10419431,10416432,10416435,10419436,10416443,10418460,10418461,10416463,10419474,10419475,10419476,10419490,10419507,10419512,10419518,10419527,10419531,10417532,10417533,10419534,10417535,10416546,10418549,10418551,10417559,10416565,10417570,10417577,10417578,10418580,10419585,10418589,10418590,10418600,10418601,10419610,10419611,10419612,10419613,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10418625,10419626,10418626,10419627,10419628,10419630,10419631,10418631,10419632,10418632,10419633,10419634,10419635,10417635,10419636,10419641,10419642,10419643,10418643,10419644,10417644,10419645,10418649,10418650,10419651,10419652,10418653,10419661,10419662,10417663,10419663,10419664,10419665,10418673,10418675,10418685,10418686,10418687,10416720,10416721,10416722,10416723,10416724,10416725,10416726,10416727,10416728,10419763,10416772,10416791,10417807,10417809,10417810,10418864,10418865,10418879,10418880,10418881,10418882,10418893,10418894,10418911,10419913,10417920,10417921,10417922,10419922,10417923,10417924,10417925,10417926,10417927,10417928,10417929,10417930,10417931,10417932,10417933,10417934,10417935,10419935,10417936,10417937,10417938,10417939,10416956,10417978,10418989,10416992,10419018,10419019,10419029,10419030,10419031,10419032,10419033,10419046,7055298,10418064,10418065,10418079,10420088,10420089,10420090,10418121,10418140,10417143,10417144,7055389,10417145,7055390,10417146,7055391,10417147,7055392,7055393,7055398,7055401,7055403,10418162,10419162,7055411,7055414,10419174,7055423,10419185,7055449,10468901,10470966,10471055,10471082,10471085,10471158,10471160,10471172,10471201,10471202,10469254,10467260,10467262,10467265,10467268,10467269,10467271,10467272,10467273,10467274,10467279,10467280,10467284,10467285,10467287,10467289,10467290,10467294,10467295,10467296,10469296,10467298,10467299,10467301,10467302,10467303,10467306,10467308,10469363,10469437,10469450,10469459,10469535,10469552,10469553,10467617,10467618,10467620,10467621,10469654,10469657,10469674,10467675,10469676,10467677,10467678,10469688,10469693,10467709,10467712,8916797,10469760,10469761,10469762,10469763,10469764,10469765,10469845,10469846,10469847,10469859,10469860,10469863,10469864,10469865,10469866,10469867,10469868,10469883,10469889,10469892,10469907,10469958,10463979,10463983,10470092,10470112,10470113,10470114,4972395,4972396,4972397,10470209,10470210,10466246,10466274,10466275,10466276,10466277,10464368,10468465,10468470,10468471,10468519,10470672,10470682,10470691,10468738,10468739,10470746,10470750,10468752,10468753,10470806,10470807,10468845,10468846,10468847,10468848,10468849,10468850,10468851,10628155,10628156,10628321,10628768,10628769,10628770,10628771,10158643,10627313,10627316,10627321,10627772,10627773,10627789,10627790,10627791,10627792,10627793,10627927,10627929,10627932,10627933,10625239,10625240,10630264,10625372,10625487,10626099,10631884,10521564,10524866,10420260,10420261,10420262,10422290,10420294,10420300,10421681,10420741,10420742,10420805,10477210,10472516,10472556,10472590,10472594) 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'