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(7067887,4970699,4970720,4970725,7065959,7065995,7065996,7065997,7065998,7065999,7066000,7066001,7066002,7066016,10950696,10950722,10950723,10950724,10950725,8583570,7066101,10950738,7066163,7066210,7066258,7066259,7066260,7066261,7066262,7066263,7066264,8622310,3229974,3229975,8575735,8575737,8575740,8575741,8575742,8575743,10990277,10990278,10990297,8575939,10938750,8837581,8573322,8573323,8573324,8573325,8573326,8573327,8573328,8620286,10939441,10939442,7201206,7201207,7201208,7201209,7201210,7201211,7201212,7201283,7201285,7201286,7201289,7201290,7201333,7201334,7201366,7201367,7201432,7201455,7201529,7201625,7201730,7201731,7201732,7201733,7201871,7201905,7201906,7201975,7201977,8065852,7202057,7202058,7202078,7202080,7202081,7202083,7202084,7202086,7202088,7202093,7202098,7202099,7202105,7202108,7202111,7202113,7202115,7202125,7202126,7202130,7202138,7202139,7202140,7202144,7202158,7202159,7202171,7202193,7202197,7202199,7202200,7202206,7202208,7202245,7202246,7202251,7202255,7202269,7202282,7202293,7202296,7202297,7202298,7202308,7202318,10843875,7202618,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202695,7202696,7202697,7202698,7202700,7202710,7065567,7065568,3227094,3227101,3227102,3227103,3227104,3227105,7200489,7200490,7200491,7200492,7200493,7200494,7200495,7200496,7200497,7200498,7200499,7200500,7200501,7200502,7200503,7200504,7200505,7200669,7200682,7200686,7200687,7200699,7200705,7200707,7200708,7200723,7200726,7200728,7200816,8615017,8908473,8908474,8908494,8908502,8908503,10101514,10101581,8860441,8860442,8860448,8860449,8905956,8905957,8905958,8905959,10618328,10838029,10838030,10838031,10838032,10623491,10623492,10623499,8906861,8906862,8906863,8906864,8906865,8906866,8906867,8906868,8906869,8906870,8906871,8906872,8906873,8906874,8906875,8906876,8906877,8906878,8906879,8906880,8906881,8906882,10838796,10838797,8070908,10838953,10838954,10838955,10838956,10838957,10838958,10838959,10838960,10838961,10838962,10838963,10838964,8907410,10619900,10927511,10927514,10617023,10617024,10617179,10617180,10617181,10617182,10617183,10617184,10617185,10617186,10617187,10617188,10617189,10617190,10617191,10617192,10617193,10617194,10617195,10617196,10617197,10617198,10617199,10617200,10617201,10617202,10617203,10617204,10617205,10617206,10617207,10617208,10617209,10617210,10617211,10617212,10617213,10617214,10617215,10617216,10617217,10617218,10617219,10617220,10617221,10617222,10617223,10617224,10617225,10617226,10617227,10617228,10617229,10617230,10617231,10617232,10617233,10617234,10617235,10617236,10617237,10617238,10617239,10617240,10617241,10617242,10617243,10617244,10617245,10617246,10617247,10617248,10617249,10617250,10617251,10617252,10617253,10617254,10617255,10617256,10617257,10617258,10617259,10617260,10617261,10617262,10617263,10617264,10617265,10617266,10617267,10617268,10617269,10617270,10617271,10617272,10617273,10617274,10617275,10617276,10617277,10617278,10617279,10617280,10617281,10617282,10617283,10617284,10617285,10617286,10617287,10617288,10617289,10617290,10617291,10617292,10617293,10617294,10617295,10617296,10617297,10617298,10617299,10617300,10617301,10617302,10617303,10617304,10617305,10617306,10617307,10617308,10617309,10617310,10617311,10617312,10617313,10617314,10617315,10617316,10617317,10617318,10617319,10617320,10617321,8905327,8905533,8905534,10954259,10954311,10954314,10615019,10615047,10615154,10615155,10615156,10615157,10615158,10615159,10615160,10615161,10615162,10615163,10615164,10615165,10615166,10615226,10615228,10615294,10615916,10615992,10615993,10615994,10615995,10615996,10615997,10615998,10615999,10616000,10616001,10616002,10616003,10616004,10616057,10616092,10426386,10426467,10426468,10426469,10426470,10426471,10426472,10426473,8904181,8904182,8904588,8611453,10616904,10616913,10616943,10610962,10611053,10611054,10611179,10614197,10611257,10611358,10611364,10714202,10559703,10559712,10611615,10611683,10611781,10611783,10611799,3962544,10611989,10612069,10612082,10612083,10612103,10612108,10612109,7057615,7057616,7057617,10609285,10609313,10609615,8862526,10612723,10612731,10612732,10612733,10612735,10612757,10612764,10612769,10612803,10612805,10612914,10612958,10609983,10609984,10609985,10609986,10609987,10610025,9196367,9196368,9196369,10613079,10613080,10613090,10613134,10613193,10613342,10613677,10613736,10613753,10613754,10613755,10613794,7055636,7055660,7055661,7055670,7055671,7055672,7055673,7055674,9169511,7055687,10117800,9169691,9169692,9169693,9169694,9169751,10118014,10118015,10118058,9169919,9169920,9169921,9169922,9169923,9169924,9169925,9169926,9169927,9169928,9169929,9169930,9169931,9169932,9169933,9169934,9161965,10118177,7056194,10118239,10118240,10118324,10118325,10118326,10118327,10118330,10118331,10118332,10118385,10118508,10118509,10118510,10118511,10118512,10118513,10118514,10118515,10118657,10118658,10118659,10118660,10118661,10118662,10118663,10118664,10118665,10118666,10118667,10118668,10118669,10118670,10118671,10118672,10118673,10419268,10419272,10417273,10417274,10417275,10417276,10419280,10418290,10418291,10417292,10418292,10418293,10418294,10416321,10416322,10416323,10416324,10416325,10416326,10416327,10416328,10416329,10416330,9168461,10416389,10416391,10416393,10419398,10419399,10419400,10419401,10419402,10419403,10419404,10419405,10419406,10419407,10419408,10419409,10419410,10419411,10419412,10419413,10419414,10419415,10419416,10419417,10419418,10419419,10419420,10419421,10419422,10419423,10419424,10419425,10419426,10419427,10419428,10419429,10419430,10419431,10419432,10419433,10419434,10419435,10419436,10419437,10419438,10419439,10419440,10419441,10419442,10419443,10419444,10419445,10419446,10416446,10419447,10419448,10419449,10419450,10419451,10419452,10419453,10419454,10419455,10419456,10419457,10419458,10419459,10419460,10419461,10419462,10419463,10419464,10419465,10419466,10419467,10416500,10416502,10416504,10416506,10418507,10418508,10418509,10418510,10416510,10416511,10418511,10418512,10416512,10418513,10418514,10418515,10418516,10418517,10418518,10418519,10418520,10418521,10418522,10418523,10418524,10418525,10418526,10418527,10418528,10418529,10418530,10418531,10418532,10418533,10418534,10418535,10418536,10418537,10418538,10418539,10418540,10418541,10418542,10418545,10419545,10418546,10419546,10419549,10419550,10419552,10419554,10419556,10419557,10415581,10415585,10415586,10419593,9168702,9168703,9168704,9168705,9168706,9168707,9168708,10416637,10416721,10416723,10416725,10416727,9168815,10416774,10418986,10420014,10420015,10420016,10420017,10420018,10117378,10117379,10117438,9169273,9169274,10467067,10471169,10471170,10469269,10469270,10469271,10469272,10469273,10469274,10469275,10469276,10469284,10469287,8549953,8550022,10467470,10469483,10469484,10469485,10469491,10469492,10469493,10469494,8550151,8550215,8550216,8550256,8550257,8550258,8550259,8550260,8550261,8550262,10469899,10467936,9167717,10468321,10468322,9167790,9167859,9167860,9167861,10468440,9168164,10468785,10468786,10468787,10468788,10468789,10468790,10883492,10884462,10884463,10884464,10884465,10884476,10884479,10884587,10884594,10884595,10884799,10884800,10884804,10885346,10885368,10877618,10632188,10173890,10173891,10882894,10883378,10883398,10162200,10162235,10162236,10162237,10162238,10162239,10162240,10162267,10630822,10630823,10630853,10630856,10882000,10882001,10882011,10882012,10882017,10882018,10882020,10882021,10882025,10882026,10882035,10163109,10877187,10877200,10877201,10877202,10877203,10877204,10877205,10877206,10877212,10877223,10877224,10877229,10877230,10877231,10882239,10877273,10877276,10877277,10877278,10877279,10877280,10877281,10877289,10877290,10882303,10882304,10882312,10882313,10882314,10882315,10882316,10882317,10882318,10882319,10882320,10882321,10877330,10877331,10877334,10877335,10877336,10877337,10877338,10877339,10877340,10877341,10877342,10877343,10877344,10877345,10877346,10877347,10877348,10877349,10877350,10877351,10877352,10877353,10877354,10877355,10877356,10877357,10877358,10877359,10877360,10877361,10877362,10877363,10877364,10877365,10877366,10877367,10877368,10877369,10877370,10877371,10882377,10882436,10877439,10877440,10877441,10588687,10521867,10521868,10538785,10538786,10538787,10538788,10538789,10538790,10538791,10538792,10538793,10424391,10424394,10424398,10424400,10424405,10424406,10424411,10424416,10424421,10424422,10420429,10424432,10424437,10424438,10420440,10420442,10420444,10420445,10420630,10420631,10486335,10486336,10486337,10486338,10486339,10486340,10486341,10481989,10481990,10481991,10481992,10481993,10481994,10481995,10481996,10487525,10472595,10472596,10472597,10472598,10487796) 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'