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(10943450,8838562,11014762,11014775,11014900,10939904,10939912,11015023,11015024,11015025,11015026,11015027,11015038,10940037,10940038,10861829,8569707,11015656,11015657,11015658,11015659,11015660,11015661,11015662,11015663,11015664,11015665,11015666,11015667,11015668,11015669,11015670,11015671,11015672,11015673,11015674,11015675,11015676,8067230,10950889,10849689,10951082,8067482,11016257,11016258,11016259,11016260,11016261,11016262,11016263,11016264,11016265,11016266,11016267,11029286,11016301,11016302,11016303,11016304,11016305,11016306,11016307,11016308,11016309,11029475,11029476,11029477,11029491,11029492,11029493,11029494,11029495,10938491,10938492,10938493,11026720,11026721,11026722,11026723,11026724,11026725,11026726,11026727,11013849,7067227,11013912,11013913,10860580,11027000,11027001,11027002,11027003,11027004,11027005,11027038,11027039,11027040,11027041,11027042,11027043,11027044,11001088,11001089,11040104,11040105,11040150,11040191,11040192,7067686,10447612,11014526,11014528,10842700,10842701,7071954,10103165,7064084,11012273,11012274,11012275,11012314,11012361,11012362,11012372,11012373,11012374,11012375,11012376,11012377,11038437,11038440,11038442,8628411,8618668,8618669,8618670,8618671,11038529,11038530,11038546,11038547,11038548,11038549,11038550,11038551,11038552,11038553,11038554,11038568,11038569,11038570,11038571,11038572,4967105,11038573,11038574,11038575,11038576,10867229,10867230,10999667,8065981,3899596,3899597,3899598,11012836,7202455,11039015,11039028,10844110,8837051,8837052,8837077,11013311,11013312,11013430,11013441,11013456,11013457,11013559,11013563,11013564,8619720,8619721,7073887,7073888,11013583,11013594,11013595,11013599,11023796,11023797,3927666,10865584,10865585,11024007,11024008,11024009,11024010,3927725,11024117,11024118,11024119,10842323,10865926,4430266,11024376,11024377,11024378,11024379,11024380,11024381,11024382,11024383,11024384,11024424,11024425,11024426,11024427,11024428,11024429,11024430,11024431,11024432,11024433,11024434,11024435,11024436,11024437,11024438,11024439,11024440,11024441,7071825,11037529,10998529,10998530,10998531,10100120,8614908,3235513,8615181,8615244,10856121,11035918,11023070,11023071,11023072,11023073,10856799,3927005,8626539,8626540,11023607,11023608,11023609,11023610,11006641,11006649,11006689,11006690,11006691,7156583,8612940,10928682,11006851,11032871,11032872,11032873,11032874,11032875,11032876,10918815,10918816,8554278,8554279,3923830,11020132,11020133,11020134,11020135,3233880,11020158,11020159,11020161,11020162,11020163,11020164,11020165,11020166,11007192,11007193,11007194,11033267,11033268,11033269,10919195,11020508,11020509,11020510,11020511,11020512,11020639,7157712,7157716,10919837,10619330,10619331,10619332,10619333,7157922,10920023,10839272,11021538,11021539,11021540,11021556,11021557,11005659,11005660,11005661,11005662,11005663,11005664,11005665,11005666,11005667,11005668,11005669,11005670,11005671,11005672,11005673,11005674,11005675,11005676,11005677,11005678,11005679,11005680,11005681,11005682,11005683,11005684,11005685,11005686,11005687,11005688,11005689,11005690,11005691,11005692,11005693,11005694,11005695,11005696,11005697,11005698,11005699,11005700,11005701,11005702,11005703,11005704,11005705,11005706,11005707,11005708,11005709,11005710,11005711,11005712,11005713,11018745,11018746,11018747,11018760,11044807,11044808,11044809,11044810,11044811,11044812,11044813,8611996,8611999,11005860,11005861,10966939,10966940,10954032,11006052,11006146,10918008,10918009,3232902,3232903,11006179,8542121,8612446,11032312,11032313,11032356,11032357,11032358,11032359,11032360,11032361,11019383,11019391,11006412,11006430,11006460,11006502,11006504,11006530,11006531,3923241,11006613,3230454,8570311,10848127,10848129,10952023,10615440,8633189,11004284,10930632,10926356,11004640,11004765,10952838,3231624,3231625,3231650,3231651,3231652,10952921,3231667,9218034,11044086,10921975,8577672,11005184,11005187,10917040,10917041,8577706,10922127,8634457,11005503,11005527,11005528,11005529,10917412,11044600,11031602,11031603,11018614,11018615,11018616,11018617,10927470,9189325,6677726,6677740,9915761,6677800,6677855,8568171,8568174,8568180,10614510,9173892,9173980,6678229,6678230,6678260,9916283,10614745,10565927,10565928,9916323,10565929,10565930,9187394,8542599,8542600,8542601,7057957,7057958,9172040,9196110,9196111,9172145,9212207,8852056,9172433,9172443,9172445,9172453,6676906,9189110,9169435,9201505,9201544,9201545,4974421,10125772,7023296,7023297,9185672,9169756,9201876,9201877,9201878,10513731,9201966,9201967,9201968,9170008,9170009,9170010,7023665,10118390,9202232,10514117,10514118,6674624,9202729,7024660,9203037,10518911,10518912,10518913,9171187,9171189,9171190,8848233,8848289,9192545,9192570,6680813,9200691,10415674,6673043,10418817,9200972,10420063,10420064,8848993,10428548,8848998,10419097,6678539,8568836,6678540,6678541,6678542,6678543,6678544,6678545,6678546,6678547,6678548,6678549,6678550,6678551,6678552,6678553,6678554,6678555,6678556,6678557,6678558,6678559,6678560,6678561,6678562,6678563,6678564,6678565,6678566,6678567,6678568,6678569,6678570,6678571,6678572,6678573,6678574,6678575,6678576,6678577,6678578,6678579,6678580,6678581,6678582,6678583,6678584,6678585,6678586,6678587,6678588,6678589,6678590,6678591,6678592,6678593,6678594,6678595,6678596,6678597,6678598,6678599,6678600,6678601,6678602,6678603,6678604,6678605,6678606,6678607,6678608,6678609,6678610,6678611,10122671,6666517,6678746,6678821,10471277,10471278,6678944,10123008,10469588,10469603,8550195,9191077,9191078,9191079,6679400,9175225,9175226,9175227,9175228,9175229,9175230,9175231,9191287,6679556,6679557,6679558,9199397,10469975,10469976,10469977,9175522,6679927,9199763,6680100,9175908,9175909,9191911,6680132,10174861,10893855,10893856,10159900,10159943,10914043,8594273,10914610,10155750,10629358,10629359,10629360,10629361,10905268,10905269,10890276,10890277,10890278,10915440,10915441,10915442,10915443,10915444,10915445,10915446,10907579,10907596,10912902,10888034,10888076,10913358,10908391,10908392,10179412,10179413,10179414,10179415,10630101,10181665,10181666,10890779,10162276,10162280,10162281,10177533,10177534,10177535,10177536,10177537,10177538,10177539,10177540,10177541,10177542,10177543,10631056,10891654,10891655,10177751,10177752,10177753,10177754,10177755,10177756,10177757,10177780,10187863,10187864,10187865,10187910,10631419,10882000,10626529,10945198,10652216,10602401,10602402,10571649,10571655,10571705,10571766,10571767,10571768,10571769,10653249,10653250,10587284,10587285,10647715,10647716,10584805,10584806,10584807,10572995,10572996,10572997,10572998,10573395,10573396,10573397,10570437,10570438,10601492,10601493,10601519,10601520,10567687,10567688,10645899,10645900,10601758,10601803,10601804,10580012,10580013,10580014,10580015,10580016,10580017,10580018,10580019,10537244,10537245,10529298,10529299,10529300,10529301,10529302,10529303,10529304,10529305,10529306,10529307,10529308,10529309,10529310,10529311,10529312,10529313,10529314,10529315,10529316,10529317,10529318,10529319,10529320,10529321,10529322,10529323,10543323,10529324,10529325,10529326,10529327,10529328,10529329,10529330,10529331,10529332,10529333,10545463,10545464,10545465,10545466,10545467,10545468,10545606,10545607,10545608,10545609,10545610,10545611,10545699,10545709,10545748,10545749,10545750,10545751,10527755,10545789,10545820,10545877,10546220,10542260,10542261,10542262,10542263,10542264,10542265,10542266,10542267,10548425,10538458,10538459,10548782,10528909,10505555,10505556,10411235,10407235,8562512,8562608,10411711,10487114,10487491,10495510,10495511) 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'