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(8630461,8630462,8630464,8630465,8630466,8630467,8630468,8630514,8630515,8630516,8630517,8630518,8630519,8630520,8630521,8630522,8630523,8630524,8630525,8630526,8630527,8630528,8630529,8630530,8630531,8630532,8630533,8630534,8630535,8630536,8630537,8630538,8630539,8630540,8630541,8630542,8630543,8630544,8630545,8630546,8630547,8630548,8630549,8630550,8630551,8630552,8630553,8630554,8630555,8630556,8630557,8630558,8630559,8630560,8630561,8630562,8630563,8630564,8630565,8630566,8630567,8630568,8630569,8630570,8630571,8630572,8630573,8630574,8630575,8630576,8630577,8630578,8630579,8630580,8630581,8630582,8630583,8630584,8630585,8630586,8630587,8630588,8630589,8630590,8630591,8630592,8630593,8630594,8630595,8630596,8630597,8630598,8630599,8630600,8630601,8630602,8630603,8630604,8630605,8630606,8630607,8630608,8630609,8630610,8630611,8630612,8630613,8630614,8630615,8630616,8630617,8630618,8630619,8630620,8630621,8630622,8630623,8630624,8574467,8574469,8574474,8574489,8574491,8574495,8574498,8574511,8574513,8574514,8574519,8574523,3228953,3229177,3229178,3229179,3229180,7065932,8631617,7065983,8583479,8583480,8583481,8583482,8583483,8631677,8631678,8631679,8631680,8631681,8631682,8631683,8631684,8631685,8631686,8631687,8631688,8631689,8631690,8631691,10950684,8631735,8631736,8631737,8631738,8631739,8583565,7066123,7066143,8631822,8631823,8631824,8631825,8631826,8631827,8631860,8631861,8631863,8631864,8631865,8631866,7066226,10939393,8630457,8630458,8630459,8630460,8627470,8627503,8627511,8627512,8627518,7201339,7201340,7201341,7201342,7201343,10960474,7202059,7202060,7202061,7202062,7202063,8628628,8628751,5654637,5654638,7202763,8629433,8629434,8629435,8629436,8629437,8627221,8627222,8627223,8627224,8627225,8627226,8627227,8627228,8627229,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627239,8627240,8627241,8627242,8627243,8627244,8627245,8627246,8627247,8627248,8627249,8627250,8627251,8627252,8627253,8627254,8627255,8627256,8627257,8627258,8627259,8627260,8627261,8627262,8627263,8627264,8627265,8627266,8627267,8627268,8627269,8627270,8627271,8627272,8627273,8627274,8627275,8627276,8627277,8627278,8627279,8627280,8627281,8627282,8627283,8627284,8627285,8627286,8627287,8627288,8627289,8627290,8627291,8627292,8627293,8627294,8627295,8627296,8627297,8627298,8627299,8627300,8627301,8627302,8627303,8627304,8627305,8627306,8627307,8627308,8627309,8627310,8627311,8627312,8627313,8624473,8909071,7199307,7199308,7199309,7196378,10623508,7197051,8613644,7197075,10619177,10838803,10838816,10838884,10838885,3234574,3234576,10838919,10838920,10838921,10838922,10838923,10838924,7197604,3234855,8624450,8624451,8624452,8624453,8624454,8624455,8624456,8624457,8624458,8541502,10617151,10617159,8541532,8905201,8905202,8905203,10617473,10617474,10954140,8905812,8905813,10615202,10615446,3231144,3231146,10848536,10616044,10616045,10616057,10616072,10616073,10616074,10616075,10616076,10616077,10616078,10616079,10616175,8540634,8540635,8540636,10616911,10616939,10616940,10616941,10616942,10616943,10614185,10614186,10614187,10614188,10614189,10614190,10614191,10614192,10614193,10614194,10614195,10614196,10614197,10614198,10611374,10611375,10611376,10611377,10611378,10611379,10611380,10611381,10611382,10611383,10611384,10611385,10611386,10611387,10611388,10611389,10611390,10611391,10611392,10611393,10611394,10611395,10611396,10611397,10611398,10611399,10611400,10611401,10611402,10611403,10611404,10611405,10611406,10611407,10611408,10611409,10611410,10611411,10611412,10611413,10611414,10611415,10611416,10611417,10611418,10611419,10611420,10611421,10611422,10611423,10611424,10611425,10611426,10611427,10611428,10611429,10611430,10611431,10611432,10611433,10611434,10611435,10611436,10611437,10611438,10611439,10611440,10611441,10611442,10611443,10611444,10611445,10611446,10611447,10611448,10611449,10611450,10611451,10611452,10611453,10611454,10611455,10611456,10611457,10611458,10611459,10611460,10611461,10611462,10611463,10611464,10611465,10611466,10611467,10611468,10611469,10611470,10611471,10611472,10611473,10611474,10611475,10611476,10611477,10611478,10611479,10611480,10611481,10611482,10611483,10611484,10611485,10611486,10611487,10611488,10611489,10611490,10611491,10611492,10611493,10611494,10611495,10611496,10611497,10611498,10611499,10611500,10611501,10611502,10611503,10611504,10611505,10611506,10611507,10611508,10611509,10611510,10611511,10611512,10611513,10611514,10611515,10611516,10611517,10611518,10611519,10611520,10611521,10611522,10611523,10611524,10611525,10611526,10611527,10611528,10122062,10611529,10611530,10611531,10611532,10611533,10611534,10611535,10611536,10611537,10611538,10611539,10611540,10611541,10611542,10611543,10611544,10611545,10611546,10611547,10611548,10611549,10611550,10611551,10611552,10611553,10611554,10611555,10611556,10611557,10611558,10611559,10611560,10611561,10611562,10611563,10611564,10611565,10611566,10611567,10611568,10611569,10611570,10611571,10611572,10611573,10611574,10611575,10611576,10611577,10611578,10611579,10611580,10611581,10611582,10611583,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611591,10611592,10611593,10611594,10611595,10611596,10611597,10611598,10611599,10611600,10611601,10611602,10611603,10611604,10611605,10611606,10611607,10611608,10611609,10611610,10611611,10611612,10611613,10611614,10611615,10559766,10611616,10611617,10611618,10611619,10611620,10611621,10611622,10611623,10611624,10611625,10611626,10611627,10611628,10611629,10611630,10611631,10611632,10611633,10611634,10611635,10611636,10611637,10611638,10611639,10611640,10611641,10611642,10611643,10611644,10611645,10611646,10611647,10611648,10611649,10611650,10611651,10611652,10611653,10611654,10611655,10611656,10611657,10611658,10611659,10611660,10611661,10611662,10611663,10611664,10611665,10611666,10611667,10611668,10611669,10611670,10611671,10611672,10611673,10611674,10611675,10611676,10611677,10611678,10611679,10611680,10611681,10611682,10614755,10614756,10614757,10614758,10614759,10614760,10614761,10614762,10614763,10614764,10611800,10609313,10612320,10612321,10609392,8566542,10609839,10609946,10610025,10610030,10610054,10610167,10610168,10613212,10613326,7018447,7018448,7018449,7018450,10613643,10610684,10610685,10610686,10610687,10610688,10610689,10610690,10610691,10610692,10610693,10610694,10610695,10613804,10613805,10613806,9169363,9169364,7055530,10117609,10117610,10117647,10117648,10117649,10117650,10117651,10117652,10117653,10117654,9169506,10117708,10117808,10118167,6674248,6674285,10118523,10419370,6672683,9168495,10419440,10419441,10416460,10419473,10419474,10419477,10419479,10419480,10419481,10419484,10419485,10419487,10419489,10419491,10416533,10416534,10416535,10416536,10416537,10416538,10416539,10416540,10416541,10416542,10416543,10416544,10416545,10416546,10416547,10416548,10416549,10419666,10419667,10418735,10418736,10418756,10419768,10419769,10419770,10419771,10419772,10419773,10419774,10419775,10419776,10419777,10419778,10419779,10419780,10419781,10415930,10415932,10415934,10415935,10415936,10415937,10415938,10415939,9169159,9169160,7055449,7055450,7055451,7055452,7055453,8550037,8550038,10469483,10469484,10469485,10469486,10469487,10469488,10469489,10469490,10469528,10469529,10469530,10469531,10469532,10469533,10469534,10469535,10469536,10469537,10469538,8550116,8550117,8550118,10469684,10467917,10467918,10467919,10467920,10467921,10467922,10467923,10467924,10467925,10467926,10467927,10467928,10467929,10467930,10467931,10467932,10467933,10467934,10467935,10467936,10467937,10467938,10467939,10467940,10467941,10467942,10467943,10467944,10467945,10467946,10467947,10467948,10467949,10467950,10467951,10116203,10116206,10116207,9168010,10116208,9168011,10116209,9168012,10116210,9168013,10116211,9168014,10116212,9168015,10116213,9168016,10116214,9168017,10116215,9168018,10116216,9168019,10116217,9168020,10116218,9168021,10116219,10116220,10116221,10116222,10116223,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470811,10470812,9168290,10888477,10883672,10883673,10883674,10883675,10883676,10883677,10883678,10883679,10889249,10889250,10889251,10889252,10889253,10889254,10628746,10628769,10628771,10628785,10884436,10884474,10884499,10889988,10889989,10890165,10890166,10880341,10877572,7000847,10887725,10887726,10887727,10153866,10888290,10888437,10885634,10630287,10886062,10886063,10882025,10882026,10590192,10647424,10647425,10483177,10483178,10483179,10483180,10483181,10483182,10483183,10483184,10483185,10483186,10483187,10483188,10483189,10483190,10483191,10483192,10483193,10483194) 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'