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(3228357,10845698,7075974,8561924,7075982,8838494,10943431,9214676,9214679,10943446,8561978,9214692,8620886,3228489,7068098,10943526,8620945,8620949,8620951,8620955,8620956,8594634,8620962,8594635,8620964,10943563,10943569,10943612,3228765,10448227,8838880,7068393,8838883,8838915,10943854,8838961,10943906,10448369,9215171,9215173,8621358,8621359,10943954,8569614,10944084,10944109,10944135,7068718,10976411,10950357,10849031,10849032,10950390,9215427,8569772,7068815,8569793,3229246,10846634,10846641,3229305,4971136,3229352,10933319,3229400,10846757,3229426,10846770,10933366,7074029,3229458,10849332,10846815,3229507,8583630,8583694,7066362,8622206,7074384,7074435,10951071,10951073,7074457,7066472,8583943,7074494,7066525,8622364,7066533,10847372,10951257,3230118,3230119,10437556,8584190,10847589,10847590,10847655,9216557,10844711,11026666,8067903,8560962,8560963,7075106,7075157,8837721,3227664,10929629,8620246,3227833,8837928,3227899,7075523,7075524,7075526,10988227,3228017,7075604,7075609,7075633,8573855,8561640,10447585,3228131,7075735,10447636,10930035,10930062,8838287,3228228,7067854,8838397,3228343,9214582,8617823,8835484,6000283,6000284,6000285,6000286,7072071,3238498,7064109,10931566,10931569,7064222,7064245,7064250,7072260,8618131,7064344,10843132,10843133,10931729,10843149,3898915,3898916,8065477,10986203,8559483,10843313,10843397,10932016,7072676,8836257,8836258,8559762,8836306,10843571,8595486,10843615,10932257,10843670,10999603,10999604,10843713,10843714,10843718,10843719,10843720,10843721,10843725,10843728,10843729,10843730,10843731,8836471,10843735,10843736,10843737,10843742,7065015,8559971,8836535,8618923,10932436,10932465,7065281,7065282,10844034,8595932,10844070,8560299,8560301,10104493,10104496,8560329,7202630,7065409,7202662,10932764,10844287,7073573,10844326,8560555,10928905,10932982,7065691,4967944,4967945,4967946,4967947,4967948,4967949,10497623,7065834,8619670,3227257,8619689,10929132,7073918,7073934,3237364,3237365,7071005,3927399,7071054,3237473,7071058,10841813,8558035,10841868,8834657,10841938,7071203,3237625,8834772,8834773,11024045,10842126,3927827,10842207,10943122,8835013,3237998,4430226,8064604,8064605,8064606,8064607,8064608,8064609,7071632,8064610,8064611,8064612,10842406,10842501,10842556,10842571,8835313,3238316,3238317,3238323,8835424,10839693,3925336,3925337,10944396,8563786,10944499,10944525,3235543,10100257,7069129,7069130,8563910,3235691,3235694,10944700,10944705,10944722,3235723,10944755,3235760,7069342,8615202,10840174,8564135,10944940,3235940,8564232,10944950,11009218,10957257,10945009,10840359,10945061,8564359,10840464,8564429,10840474,10840489,10840504,10840517,3236187,7069773,3656365,3656386,7069819,10840572,10840577,7069837,10840615,10100998,3236299,3236316,10840703,7069981,10840742,10840746,10840754,10840755,10840759,8564737,3926421,8564740,3926487,8615944,8615946,7070163,7070215,8072974,8072975,8072976,7070243,8072977,8072978,8072979,11035929,8072980,8072981,10841005,7070263,7070264,3926671,7070284,7070286,7070293,7070319,8565035,7070351,10841106,7070364,7070407,8626053,7070412,10942039,10942040,10841180,8565144,10841212,8616359,8616364,7070558,7070564,8565278,10841472,8834219,8834220,11049626,3927243,3927244,3927245,10841618,10993620,10993621,10993622,10993623,10993624,10993625,10993626,10993627,10993628,10993629,10993630,10993631,10993632,10993633,10993634,10993635,10993636,10993637,10993638,10993639,10993640,10993641,10993642,10993643,10993644,10993645,10993646,10993647,10993648,10993649,10993650,10993651,10993652,10954708,7156691,7156692,7156693,7156694,3233610,3923680,11007000,8613158,3233758,3233781,10623398,3923863,3233988,10981426,8613589,3924153,3924204,7197097,7197098,7197099,3924296,3234343,3234358,8613783,3924406,8613865,3234512,3924560,10839006,8614089,8614093,8614095,8614102,3924663,3924664,3924667,3234696,10839035,3234707,3924702,3924719,3924721,3924771,3924777,3924805,3924820,3924826,3924846,10839256,8614429,3235045,3925049,3925143,8614597,3925291,4938623,4938624,4938625,4938626,4938627,4938628,8611779,10836839,3232512,10917687,11005840,11005841,8578504,8578574,8578630,3922852,8578657,8578732,3232978,3233005,8612511,3233200,3233270,10993603,10993604,10993605,10993606,10993607,10993608,10993609,10993610,10993611,10993612,10993613,10993614,10993615,10993616,10993617,10993618,10993619,8569926,10951579,10847710,10847732,10425373,10847811,10425434,8570068,8570117,8570118,8570122,8570127,10951840,3230667,3230696,3230700,3230701,10925822,10425681,8570409,11004125,3230996,10930569,10952244,10848384,10930612,3231093,10848446,10930655,10952329,11043439,11043440,10930744,11043508,11043509,10930846,10952551,10930889,10952558,8610782,3231462,3231463,3231465,8540627,10978810,3231554,3231658,8540853,3231778,8577661,3232086,8611643,3232256,8904909,8904910,11018541,11018542,11018543,11018544,10953549,10953550,10953551,10953552,10953553,10953554,9213320,7059515,9165357,9213368,8863897,7059602,9197460,8864056,10565348,7059749,7059767,7059772,8864140,8864144,10121900,9205739,8864281,8864359,8864384,8568368,9165932,9181937,9181938,6678177,9198016,9182079,3962426,8864632,8864653,8864682,8864690,8864721,3962520,3962521,3962522,3962523,9206260,8864792,10566083,9166290,8861832,8861905,9187417,8542604,8565951,7057637,8565980,8566004,9179520,8862043,10119727,8862071,7057727,8542738,9203604,8566112,8566140,8862184,10609333,9179671,10609334,10609335,10609336,9163679,8862218,9179702,8862288,9211799,8862333,9179849,9195861,8862406,8862424,9179909,10612594,9211964,9211965,9211966,9211967,10612650,7058205,8862602,9164082,9220135,10609829,6676403,6676404,9220183,8862750,8862804,8862810,8862816,9212299,9172326,9172332,8862973,7058653,9196518,9196528,9220507,9196598,9204605,8863131,9204619,8863185,8863187,8863221,7058879,9164714,8863256,10561570,8863319,8863460,7059120,9220933,7059154,7059164,7059184,8863553,9221067,9221083,10613793,10613794,9197139,7059309,7059311,7059319,9189191,9165218,8863807,9165288,9185307,9209314,4974213,7055851,4974598,9177758,9177804,9161810,9161894,9161895,9161896,9161897,9185929,7056103,9209972,7056148,7056149,9209984,7056153,9162202,7056436,8551570,8551571,8551572,9178289,7056468,9210325,7056657,2809145,7056751,9178591,9210610,9202622,7056789,9202657,9202675,9202856,9202857,9186872,9186873,9186874,9210881,9178929,9170937,9179041,9211071,7057291,8552505,8861734,8861744,9187224,8861754,9211283,9179284,9208308,9176440,9208491,10116735,9208552,9160568,9160688,9184694,9160819,9184837,9160878,9160896,7055083,10418859,10418860,9184949,9192951,10125309,9201130,7055315,10117412,10117413,10117414,10117415,9161255,9161256,9185261,9209290,9206300,9198346,9206373,3962700,9174444,10467063,9166492,9166569,8865147,9166627,6670851,6670852,9198683,8569221,8569273,3963095,9166793,9166794,9166795,10463459,10463460,10463461,10463462,10463463,10463464,10463465,10463466,10463467,10463468,10463469,10463470,10463471,10467477,9198952,6667007,6667015,9167047,9183074,9207113,9207129,9207192,9207193,9191335,8563251,8563261,8563271,8563272,8563274,8563291,8563312,10115632,8563392,9175596,8563505,9183639,8550811,9175668,9183685,6667702,9183724,9199745,8917398,9183774,9207789,9183837,10116050,9175866,9175921,6667925,9199931,9183997,9184016,9200041,9200074,9200075,9200095,9200103,9200117,9200128,9200148,8847991,9200190,9200245,9200246,9200257,9208298,10946409,10946410,10946411,10946412,10946413,10946414,10946415,10946416,10174618,10946417,10946418,10946419,10946420,10179631,10175159,8594196,10155505,10155506,10155507,10155508,10155509,10155510,10155511,10155512,7000675,10877551,10877553,10877556,10877570,10877574,10877589,10877592,10877605,10183790,10627308,7001041,7001113,7001114,10893014,10174247,10174248,10174249,10179367,10179368,10156701,10171746,10886033,10886034,10177256,10187472,10167546,10876690,10876691,10876692,10876693,10876694,10876695,10876696,10876697,10876698,10876699,10162966,10631451,10631452,10882244,10882245,10950071,10882362,10882363,10882364,10568527,10568528,10568529,10568530,10568531,10568532,10652896,10572243,10569673,10570052,10585336,10585337,10585338,10585339,10585340,10588348,10588349,10588350,10588351,10588352,10588353,10588354,10588355,10588356,10654481,10654482,10654483,10654484,10654485,10654486,10654487,10654488,10654489,10652115,10529424,10529425,10538441,10536677,10533089,10533090,10533091,10533092,10533093,10533094,10533095,10533096,10498365,10420554,10409759,10496583,10487307) 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'