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(8630751,8630755,8630758,8630759,10861401,8630760,8630766,8630767,8630768,8630769,8630770,8630771,8630772,8630773,8630774,8630775,8630776,8630777,8630778,8630779,8630780,8630781,8630782,8630783,8630786,8630847,8630853,8630854,8574513,8630993,8631003,8631031,8631032,8631033,8631034,8631035,8631036,8631037,8631038,8631039,8631040,8631041,8631042,8631043,8631044,8631045,8631119,8631120,8631121,4970738,3228953,10861921,3229077,3229078,3229171,8631598,8631609,8631611,8631617,8631622,8631623,8631624,8631625,8631635,8631677,8631678,8631679,8631856,8631857,8631858,8631859,10862625,10862653,8575733,8575734,8575735,10849869,8632395,8632396,8632397,8632398,8632399,8632410,8632498,8632499,8632514,8632517,8632520,8632545,8632546,8632559,8632560,8629581,8629582,8629583,8629584,8629621,8629622,10860323,10860325,10860331,10860332,10860341,10860342,10860347,10860364,10860370,10860372,10860373,10860374,10860383,10860385,10860386,10860389,10860390,8629759,10860404,10860413,10860414,10860422,10860423,10860438,10860442,8573335,8573336,8573337,10860456,10860463,10860466,10860468,10860478,10860479,10860480,10860483,10860490,10860491,10860494,10860518,10860531,10860543,8630172,8630173,8630420,10861074,8630459,8630462,8630463,8630465,8630466,8630467,8630468,10930095,7201195,7201196,8627651,8627652,8627653,8627654,8627655,8627656,7201309,7201366,7201415,7201420,7201432,10866611,10866613,8628118,8628119,8628120,8628121,8628122,8628123,8628139,8628140,8628141,8628142,8628143,8628144,8628145,8628146,8628147,8628148,8628149,8628150,8628151,8628152,8628153,8628154,8628155,8628156,8628157,8628158,8628159,8628160,8628161,8628162,8628163,8628164,8628165,8628166,8628229,8628230,8628258,8628259,7201861,8628265,7201901,10858946,8628351,8628352,7201959,7201974,10859258,8628633,8628634,8628641,8628654,8628662,8628665,8628666,8628667,8628668,8628669,8628673,8628676,8628678,8628679,8628680,8628686,8628688,8628689,8628691,8628692,8628693,8628694,8628696,8628698,8628699,8628700,8628701,8628702,8628703,8628705,8628706,8628707,8628708,8628709,8628710,8628711,8628712,8628713,8628716,8628717,8628718,8628719,10859576,7065457,9794578,9794579,9794580,9794592,7202769,9794594,3227094,8629325,8629434,8629435,3227207,8629514,8629522,8629578,8629579,8629580,10857225,3237362,3237396,10865412,10857461,10857462,10857648,8627012,8627013,8627017,8627019,8627022,8627024,8627026,8627027,8627030,8627033,8627035,8627039,8627042,8627044,8627046,8627047,8627048,8627049,10959088,8627051,8627053,8627059,8627060,8627061,8627064,8627065,8627066,8627150,8627151,8627163,8627164,7200765,8627176,8627177,8627188,8627189,8627206,8627207,8627221,8627223,8627224,8627225,8627227,8627228,8627230,8627237,8627238,8627241,8627247,8627253,8627255,8627258,8627262,8627263,8627264,8627266,8627267,8627268,8627269,8627283,8627287,8627310,10865954,8627312,10865955,8627313,10865956,10865957,8627468,8627469,8627471,8627472,10866115,8627473,8627474,8627475,8627476,8627478,8627479,7201080,8627487,8627488,8627489,8627490,8627492,8627493,8627494,8627495,8627496,8627497,8627498,8627499,8627502,8627510,8627515,8627516,8627517,8627525,8627526,8627527,8624722,8624723,8624724,8624725,8624726,8624727,8624741,8624742,8624743,8624744,8624745,8624746,8908277,8908278,10855512,10855513,10855514,10855515,7198680,7198722,7198723,7198726,8625142,7198784,7198785,10863864,10863865,10863866,10863867,10863875,10863876,10863877,10863878,10863881,8625248,8625249,8625250,8625255,8625262,8625269,8625270,8625271,8625272,8625273,8625274,8625275,8625276,8625277,8625278,8625279,8625280,8625281,8625282,8625283,8625284,8625285,8625286,8625287,8625288,8625289,8625290,8625291,8625292,8625293,8625294,8625295,8625296,8625297,8625298,8625299,8625300,8625301,8625302,8625303,8625304,8625305,8625306,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,8625318,8625319,8625320,8625321,8625322,8625323,8625324,8625325,8625326,8625327,8625328,8625329,8625330,8625331,8625332,8625333,8625334,8625335,8625336,8625337,8625338,8625339,8625340,8625341,8625342,8625343,8625344,8625345,8625346,8625347,8625348,8625349,8625350,8625351,8625352,8625353,8625354,8625355,8625356,8625357,8625358,8625359,8625360,8625361,8625362,8625363,8625364,8625365,8625366,8625367,8625368,8625369,8625370,8625371,8625372,8625382,8625383,8625384,8625386,8625387,8625388,8625389,8625390,8625391,8625392,8625393,8625394,8625395,8625396,8625397,8625398,8625399,8625400,8625401,8625402,8625403,8625404,8625405,8625406,8625407,8625408,8625409,8625410,8625411,8625412,8625413,8625414,8625415,8625416,8625417,8625418,10856248,10856250,7199449,8625871,8625880,10101492,8626021,8626047,10856862,8626221,8626222,10856867,10856979,10856980,10857088,7200087,10853411,7196378,3923593,7196457,7196464,8554296,8554297,10623490,7197051,8613644,7197075,10854367,3234660,3234661,3234730,8624401,8624424,8624439,10855091,8624454,8624455,8624456,8624457,10619895,10619896,10619898,10619899,10619900,8624522,8624551,8624553,8624554,8634677,8634678,8634679,8634680,8634681,8634682,8634683,8634684,10617071,8634695,8634697,8634699,8634701,8634702,8634703,8634705,8634708,8634710,8634716,8634718,8634720,8634721,8634722,8634723,8634724,8634725,8634727,8634728,8634800,8541668,8634801,8634804,8634805,8634807,8634808,8634810,8634811,8634813,8634816,8634818,8634823,8634826,8634827,8634828,10622257,10622258,10622264,10622265,10622266,10622267,10622268,10622360,8612185,10622402,10622405,10622408,10622428,10622431,10622445,10622447,10622460,10622514,10622516,10622523,8905663,8542165,8905711,8632626,8632627,8632628,8632629,8632630,8632631,10615024,8632722,8632724,10850371,8632800,8632810,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10615338,10615363,8633158,8633159,10425910,3581937,10425937,8633235,8633236,8633237,8633238,8633239,8633240,8633241,8633252,10615709,10615710,3582170,8540418,10616058,10426445,8540612,8540613,8633953,8633954,8633955,8633956,8633957,8633958,8633959,8633960,8633961,8633962,8633963,8633964,8633965,8633966,8633967,8633968,8633969,8633970,8633971,8633972,8633973,8633974,8633975,8633976,8633977,8633978,8633979,8633980,8633981,8633982,8633983,8633984,8633985,10616476,10616479,10616644,10427106,8634421,8634423,10616888,10610965,10614048,9165550,6669828,10614338,10614376,10614593,10611856,8549450,10612102,10612104,10612105,10612106,10612107,10612191,10612192,10612194,10612201,10609285,10612380,8851990,8852017,10612916,9196366,9196371,9196372,9196373,10610347,10613393,10613421,10613431,10613432,10613434,10613504,10613505,10613513,10613514,10613525,10613527,10613531,10613732,10613733,10610901,9169318,9169319,6673563,7055541,7055546,9169428,9169453,9169748,9161895,9161897,9912227,9912437,9912438,9912439,9912521,8850224,9912888,6672514,6672515,10417296,10417297,10417298,10417300,10417312,10417313,10417314,10417315,9168394,10417318,10417319,10417320,10417321,10417322,10417323,10417324,10417325,10417326,10417327,10417331,10415342,10419494,9168669,9168774,9168818,6673122,6673124,6673125,6673126,7055241,10117478,8550018,8550023,8550036,8550065,8550100,6671809,976476,6671903,6671917,10888565,10888566,10888637,10888638,10888639,10888640,10888641,10888642,10888656,10893983,10889019,10889020,10889021,10884086,10884087,10884324,10884420,10884421,10884652,10889707,10155731,10884799,10884800,10874953,10874954,10889997,10890085,10890165,10885212,10885213,10880325,10880326,10887553,10887554,10887607,10887608,10888013,10883358,10883359,10883378,10883396,10883397,10883401,10883404,10883405,10883408,10883409,10883410,10883411,10883412,10883432,10161705,10885751,10162249,10626145,10886850,10886878,10886910,10167992,10896985,10882007,10882008,10897008,10882009,10882010,10887052,10897082,10877181,10882356,10882357,10882358,10882359,10608607,10608610,10582561,10545324,10547913,10547998,10528214,10544310,10548747,10548748,10548751,10548885,10508175,10507670,10507671,10507988,10411336,10411338,10407370,10413461,10411774,10411780,10411839,10411840,10411929,10414016,10414637,10414652,10414661,10414662,10414664,10414669,10414670,10414673,10410678,10410679,10410680,10410681,10414682,10414685,10414686,10414687,10414688,10414690,10414692,10414693,10414705,10414714,10414719,10414720,10414733,10414739,10414745,10414749,10414750,10414751,10414757,10414758,10414759,10414760,10414762,10414766,10414770,10414771,10414774,10414779,10414812,10414824) 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'