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(7076390,4970737,7066128,8067932,10938937,10938938,10938939,10938940,11001186,10939155,10939156,10939458,10939536,11048957,11048958,11048959,11048960,11048961,11048962,11048963,11048964,7071203,7071204,7071205,7071206,7071207,7071208,7071209,7071210,7071211,7071212,7071213,7071214,7071215,7071216,7071217,7071218,7071219,7071220,7071221,11047587,10941835,10941836,10942063,10942064,10942065,10942066,10942067,10942068,10942069,10942070,10942071,10942072,10942073,10942074,10942075,10942076,10942077,10942078,10942079,10942080,10942081,10942082,10942083,10942084,10942085,10942086,11048402,11048403,11048404,11048440,11048490,11048491,10622976,10618300,10618301,10623494,11007738,10994879,10994880,10994881,10994882,10994883,10994884,10994885,10994886,10994887,10994888,10994889,10994890,10994891,10994892,10994893,10994894,10994895,10994896,10994897,10994898,10994899,10994900,10994901,10994902,10994903,10994904,10994905,10994906,10994907,10994908,10994909,10994910,10994911,10994912,10994913,10994914,10994915,10994916,10994917,10994918,10994919,10994920,10994921,10994922,10994923,10994924,10994925,10994926,10994927,10994928,10994929,10994930,10994931,10994932,10994933,10994934,10994935,10994936,10994937,10994938,10994939,10994940,10994941,10994942,10994943,10994944,10994945,10994946,10994947,10994948,10994949,10994950,10994951,10994952,10994953,10994954,10994955,10994956,10994957,10994958,10994959,10994960,10994961,10994962,10994963,10994964,10994965,10994966,10994967,10994968,10994969,10994970,10994971,10994972,10994973,10994974,10994975,10994976,10994977,10994978,10994979,10994980,10994981,10994982,10994983,10994984,10994985,10994986,10994987,10994988,10994989,10994990,10994991,10994992,10994993,10994994,10994995,10994996,10994997,10994998,10994999,10995000,10995001,10995002,10995003,10995004,10995005,10995006,10995007,10995008,10995009,10995010,10995011,10995012,10995013,10995014,10995015,10995016,10995017,10995018,10995019,10995020,10995021,10995022,10995023,10995024,10995025,10995026,10995027,10995028,10995029,10995030,10995031,10995032,10995033,10995034,10995035,10995036,10995037,10995038,10995039,10995040,10995041,10995042,10995043,10995044,10995045,10995046,10995047,10995048,10995049,10995050,10995051,10995052,10995053,10995054,10995055,10995056,10995057,10995058,10995059,10995060,10995061,10995062,10995063,10995064,10995065,10995066,10995067,10995068,10995069,10995070,10995071,10995072,10995073,10995074,10995075,10995076,10995077,10995078,10995079,10995080,10995081,10995082,10995083,10995084,10995085,10995086,10995087,10995088,10995089,10995090,10995091,10995092,10995093,10995094,10995095,10995096,10995097,10995098,10995099,10995100,10995101,10995102,10995103,10995104,10995105,10995106,10995107,10995108,10995109,10995110,10995111,10995112,10995113,10619876,10619881,10619882,10966643,10966644,10966645,10966646,10622269,10927886,10927888,10617479,10617480,10617481,10617482,10617483,10617484,10928117,10928118,10928121,10928122,10928123,10928124,10928125,10928126,10928127,10928128,10928129,10928130,10928131,10954390,10619979,10615075,10615076,10620129,10620203,10620204,10620205,10620206,10615625,10930832,10930833,10616050,10616052,10616704,10616888,10614358,10614359,10614360,10614361,10614362,10614363,10614364,10614365,10614366,10614367,10614368,10614369,10614370,10614371,10614372,10614373,10614374,10614375,10614376,10614377,10614378,10614379,10614380,10614381,10614548,10611696,10611854,10611855,10611856,10611857,10611858,10611859,10611860,10611861,10611862,10611863,10612074,7057638,7057639,7057640,7057641,7057642,7057643,7057644,7057645,7057646,7057647,7057648,7057649,7057650,10612229,10612230,10612234,10612235,10612236,10612275,10609313,10563567,7057954,7058143,7058144,7058145,7058146,7058147,7058148,7058149,7058150,8862538,8862539,8862540,8862541,8862542,8862543,8862544,8862545,8862546,8862547,8862548,8862549,8862550,8862551,8862552,10609835,10613196,10613211,10613213,10613254,10613335,10613343,10613741,10610777,7059342,10517287,10517288,7055660,9169539,9169716,9169717,9169718,10513548,9169801,7057165,7057166,2809653,10416260,10416269,10416270,10416271,10416272,10416273,10416274,10416275,10415312,10415313,10415314,10418316,10418317,10418318,10418319,10418320,10416321,10418321,10416322,10418322,10416323,10416324,10416325,10416326,10416327,10416328,10416329,10415329,10416330,10415330,10415331,10415332,10415345,10415346,10415347,10415348,10415349,10415350,10415351,10415352,10415353,10415354,10415355,10415356,10415357,10415358,10415359,10415360,10415361,4973293,10415362,4973294,10415363,4973295,10415364,4973296,10415365,4973297,10415366,4973298,10415367,4973299,10415368,4973300,10415369,4973301,10415370,4973302,8918096,10415371,4973303,8918097,10415372,4973304,10415373,4973305,10415374,4973306,10415375,4973307,10415376,10415377,10415378,10415379,10415381,10415387,10415388,10415389,10415390,10415391,10416497,10416498,10418553,10418554,10418555,10418556,10418557,10418558,10418559,10418560,10418563,10418564,10418565,10418566,10418567,10418568,10418569,10418570,10417570,10418571,10418572,10418573,10418574,10418575,10418576,10418577,10418578,10417756,10417757,10417758,10415791,10415792,10415793,10415794,10415795,10415822,10415827,10415828,10415829,10415830,10415831,10415832,10415833,10415834,10415835,10415836,10415837,10418864,10418865,10415873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,10415887,10415888,10415889,10415896,10415897,10415898,10415909,10415910,10415911,10415913,10415914,10418990,10420037,10419108,10419109,10419110,10419111,10419112,10419113,10419114,9169210,9169211,9169212,9169213,9169214,9169215,9169216,9169217,9169218,9169219,9169220,9169221,9169222,9169223,9169224,9169225,9169226,9169227,9169228,9169229,9169230,9169231,9169232,9169233,9169234,9169235,9169236,10416182,10416183,10416184,10416185,10416186,10416187,10416189,10416190,10416191,10416192,10416193,10416194,10471251,10471252,10471253,10469539,10469540,10469541,6667204,6667205,6667206,6667207,6667208,6667209,6667210,6667211,6667212,6667213,6667214,9175486,9175487,8563559,8563560,10159544,10628152,10155591,10629209,10170903,10170904,10170906,10170911,10171145,10632106,10632107,10632108,10632109,10632110,10627113,10627114,10627115,10632209,10627278,10627279,10627280,10627281,10627282,10627283,10627284,10627285,10627286,10627287,10627289,10627290,10627291,10627292,10627293,10627294,10632310,10632311,10632312,10627326,10627724,10627725,10627726,10627772,10627773,10627776,10627782,10627783,10627784,10627786,10630023,10630024,10630025,10630026,10630027,10630028,10630029,10630030,10630031,10630032,10630033,10630034,10630035,10630036,10630037,10630038,10630039,10630040,10630041,10630043,10630044,10630045,10630046,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630068,10630069,10630070,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630078,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630089,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10630099,10630100,10630101,10630102,10630103,10630104,10630105,10630175,10167028,10167029,10167030,10162030,10167031,10162031,10162032,10162033,10162034,10162037,10162038,10167040,10167041,10167042,10167045,10167046,10167047,10167048,10167049,10167050,10167052,10167053,10167055,10167056,10167059,10167060,10167061,10167063,10167066,10167067,10167068,10167069,10167070,10167075,10167076,10167083,10167084,10167085,10167090,10167094,10167096,10167099,10167101,10167107,10167110,10167111,10167114,10167115,10626268,10626509,10626510,10626511,10626512,10626513,10626514,10626515,10626516,10626517,10626518,10626519,10626520,10626521,10626522,10626523,10626524,10626525,10626526,10626527,10626528,10626529,10626530,10626531,10626532,10626533,10626534,10626535,10626536,10626537,10626538,10626539,10626540,10626541,10626542,10626543,10626544,10626545,10626546,10626547,10626548,10626549,10626550,10626551,10626552,10626553,10626554,10626555,10626556,10522603,10522604,10522605,10522606,10522607,10522608,10522610,10522611,10524881,10524882,10524883,10524884,10524885,10422256,10422257,10422258,10422259,10422260,10422261,10422262,10422263,10422264,10422265,10422266,10422267,10420712,10423923,10423924,10423925,10423926,10423927,10423928,10423929,10423930,10423931,10421947,10421948,10421949,10421950,10421951,10421952,10421953,10421954,10421955,10421956,10423089,10423090,10423091,10423092,10423093,10423094,10423095,10423096,10423097,10423098,10423099,10423100,10423101,10423102,10423103,10423104,10423105,10423106,10476424,10476426,10476427,10476428,10476429,10476443,10476444,10476447,10476448,10476449,10476450,10476451,10476452,10476453,10476454,10476455) 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'