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(7067993,7068024,7068026,7068027,7068029,7068032,7068033,7068034,7068036,7068038,7068040,10447919,9214740,9214741,9214742,9214743,9214744,9214745,9214746,9214747,9214748,9214749,9214750,9214751,9214752,9214753,9214754,9214755,9214756,9214757,9214758,9214759,9214821,10845920,9214822,11001876,7076406,10940055,7068451,7068453,8631161,7068531,7068534,7068536,10846289,10846290,10846291,10846292,10846299,10846300,10846301,10846302,10846303,10846304,10846305,10846306,10846307,10846308,10846309,10846310,10846311,11041330,11041391,8569720,11041458,11041459,3229278,8631589,8631593,8631594,8631595,8631596,8631597,8631598,8631599,8631600,8631601,8631602,8631603,8631604,8631605,8631606,8631607,8631608,8631609,8631610,8631611,8631755,8631756,8631757,8631758,8631876,8631877,8631878,8631879,8631880,8631881,8631882,8631883,8631884,8631885,8631886,8631887,8631888,10846996,7074305,7066396,7066398,7066530,8632417,8632515,8632545,8632546,8632559,8632560,9216569,9216585,8629599,10844712,8067930,8629690,8629691,8629692,8629693,8561311,10872702,10872703,10872704,10872705,10872706,10872707,10872708,10872709,10872710,10872711,10872712,10872713,10872714,10872715,11040245,11040246,11040247,11040248,11040249,8630225,9214292,9214293,8620489,8620490,8620491,8620493,10845439,8620536,9214399,9214400,8838241,8838242,8630404,8630405,9214423,9214424,7067776,9214444,9214475,9214476,9214477,7067840,7067841,9214507,9214511,7064019,10103160,7201296,8594696,8594697,7064056,7064059,7064060,7064061,7064062,7201310,7064066,7064090,8594737,7201344,7064116,3238539,10842878,7064131,10842884,8627798,8627799,8627800,7064155,7064156,10842910,7064163,7064165,7064166,7064167,7064172,7064174,7064175,7064176,7064177,7064178,7064179,7064180,7064181,7064182,7064183,7064184,7064185,7064186,7064187,7064188,7064189,7064191,7064192,7064193,7064194,7064195,7064196,7064197,7064198,8627889,8627890,8627891,8627892,8627893,8627894,8627895,8627896,8627897,8627898,8627899,8627900,8627901,8627902,8627903,8627904,8627905,8627906,8627907,8627908,8627909,8627910,8627911,8627912,8627913,8627914,8627915,8627916,8627917,8627918,8627919,8627920,8627921,8627922,8627923,8627924,8627925,8627926,8627927,8627928,8627929,8627930,8627931,8627932,8627933,7064316,7064499,7064500,7064501,8628215,10843447,10843459,10843460,10103964,10103972,10103973,10103980,10103981,10103982,8836372,8836373,10104019,10104020,10104021,10104043,10104044,10104045,7202163,8628574,7202201,7202202,7202203,10843756,10843757,10843758,3899509,3899510,10104196,10104197,10104198,7065118,7065119,7073161,10104330,10104332,10104333,8628902,8628903,8628904,10104456,7202582,10844191,10844217,10844218,10104595,10104597,10104612,10844308,10844309,8629221,7073603,10844411,3227088,8629471,8616849,8616850,8616851,8626710,10997794,3927531,8626840,8626841,8626842,8626843,8626844,8626845,8626846,7200610,7071460,7071570,7071571,7071572,7071573,7071579,7071580,7071581,7071582,7071583,7071584,7071585,10102863,8627425,8627426,8627427,8627428,8627429,8627430,8627431,8627432,8627433,8627434,8627435,8627436,8627437,8627438,8627439,8627440,8627441,8627442,8627443,8627444,11037509,10102986,10102995,10839704,10839824,10100265,8624782,8624783,8624784,8624785,10839993,8624925,3235796,3235797,7198678,7198679,7198680,7198681,7198683,7198685,7198690,7198695,7198696,7198697,7198698,7198699,7198701,7198702,7198703,7198704,7198705,7198706,7198707,7198709,7198710,7198711,7198712,7198713,7198714,7198716,7198717,7198719,7198720,7198721,7198722,7198723,7198724,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198742,10957182,7198743,10957183,10957184,7198746,7198747,7198750,7198751,7198752,8625155,7198757,7198759,7198762,7198763,7198764,7198765,7198766,8625167,7198769,7198771,7198772,8625364,8625371,3656296,10100919,3236231,10840612,10101067,10840846,10840847,8625779,10840910,11035927,11035928,10101373,11035929,10841001,10841002,10841005,8625916,8625917,8625918,8625919,8625920,8625921,10841049,10841072,10841073,8625966,10841078,10841080,10841090,11036137,11036138,11036151,11036152,11036153,11036154,11036155,10101601,7070477,8626126,11036180,11036181,11036182,11036183,8626198,10101715,8626253,11036507,11036508,11036509,11036519,11036520,11036539,11036540,10101991,10102055,10102057,11036618,11036619,7196217,10967768,10967769,10967770,8613011,3233618,10928820,3233719,10968055,10968056,10968148,10968149,10838299,10838300,7196981,10968428,10838608,8555315,8555316,10839229,10839238,10839239,10839240,7197854,7197855,7197856,8624406,8624433,8624434,11047549,11047550,10839637,8634615,8634616,8634617,8634618,8634619,8634620,8634621,8634622,8634623,8634624,8634625,8634626,8634627,8634628,8634629,8634630,8634631,8634632,8634633,8634670,8634671,10617053,8634672,8634673,8634674,8634675,8634676,11044766,10622187,10836916,10837019,10837063,10837424,10837425,8542389,8542392,7196139,7196141,7196144,7196145,8579110,8579111,8579112,8632720,10951720,10620139,8632765,8632766,8632767,8632768,8632769,8632770,8632771,8632772,8632773,8632774,8632775,8632776,8632777,8632778,8632779,8632780,8632781,8632782,8632783,8632784,8632785,8632786,8632787,8632788,8632789,8632790,10615179,8632811,8632812,8632813,8632814,8632815,8632816,8632817,8632818,8632819,8632820,8632821,8632822,8632823,8632824,8632825,8632826,8632827,8632828,8632829,8632830,8632831,8632832,8632833,8632834,8632835,8632836,8632837,8632838,8632839,8632840,8632841,8632842,8632843,8632844,10615315,10848116,10848117,10848138,10848139,10848140,10848176,8633114,8633134,10848396,10615683,3231088,8633509,8633510,8633511,8633512,8633513,8633514,8633515,8633516,8633517,8633518,8633519,8633520,8633521,8633522,8633523,8633524,8633525,8633526,8633527,8633528,8633529,8633530,8633531,8633532,8633533,8633534,8633535,8633536,8633537,8633538,8633539,8633540,8633541,8610769,3231384,8540577,8540579,9217801,9217802,9217803,9217804,9217805,9217806,9217807,9217808,9217809,9217810,9217811,9217812,9217813,9217814,9217815,9217816,9217817,9217818,9217819,9217820,9217821,9217822,9217823,9217824,9217825,9217826,9217827,9217828,9217829,9217830,9217831,9217832,9217833,9217834,9217835,9217836,9217837,9217838,9217839,9217840,9217841,9217842,9217843,9217844,9217845,9217846,9217847,9217848,9217849,9217850,9217851,9217852,9217853,9217854,9217855,9217856,9217857,9217858,9217859,9217860,9217861,9217862,9217863,9217864,9217865,9217866,9217867,3231695,3231697,8634316,8634345,8634346,8634347,8634348,8634349,8634350,8634432,8541371,10616888,8634559,8634560,6665726,6665727,6665751,10614532,10614857,9214197,10122408,8864794,7057471,8851137,8851166,8851202,8851220,8851229,8851230,8851236,8851242,8851246,8851290,8851317,8851331,8851334,8851340,8851357,8851362,10119741,8851371,8851372,8851382,8851393,8851394,8851395,8851401,10612264,8851496,8851500,8851501,10612356,7057913,3652963,3652964,3652965,3652966,3652967,3652968,3652969,10613077,3653623,9164603,9164648,7058840,7058841,9164685,9164690,9164720,9164745,10613475,9204918,8852771,9189007,4974664,4974665,4974666,7056213,9186152,3651937,3651938,3651939,3651940,3651941,3651942,3651943,8850658,8850672,8850677,8850679,8850687,8850688,8850692,8850702,8850711,8850716,8850720,8850724,8850729,8850738,8850740,8850742,8850750,8850752,8850762,8850767,8850768,8850776,8850786,8850789,8850795,8850803,8850808,8850815,8850816,8850817,8850884,8850937,8850949,8850954,8850971,8850973,8850977,8850981,8850994,8851004,8851008,8851034,8851041,8851042,8851050,8851057,8851061,8851065,8851069,8851078,8851081,8851089,9160306,9160307,10124571,10124576,9176419,9168494,7055193,7055195,7055199,7055200,7055203,7055215,7055220,7055223,9193254,10122496,6670624,8865199,9206722,9191080,6667193,6667356,6667357,6667358,6667359,6667360,6667361,6667380,10115652,9167509,9167515,6667857,9184095,9192114,10116329,10116335,10116336,9168151,8917821,10893590,10893591,10628324,10632166,10632189,10627415,10162047,10626298,10631546,10631549,10163289,10631885,10601175,10605445,10605446,10579481,10521337,10521338,10521914,10521915,10528069,10522601,10522602,10522609,10498237,10498238,10423646,10423647,10423648,10423649,10423650,10423651,10423652,10423653,10423654,10423655,10423656,10423657,10507802,10494992,10494993,10494994) 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'