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(8630632,8630636,8630638,8630639,8630640,8630641,8630642,8630643,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630743,8630746,8630810,8630811,8630812,8630852,8630854,8630855,8630862,8630886,8630887,8630893,8630899,8630900,8630902,8630905,8630958,8630973,8630993,8631003,4970685,8631129,8631133,3229008,3229130,3229131,3229153,8631480,8631481,8631482,3229285,8631585,8631586,8631587,8631593,8631594,8631598,8631599,8631622,8631623,8631624,8631625,8631630,8631635,8631713,8631714,8631715,8631763,8631764,8631765,8631793,8631794,8631795,8631796,8631797,8631798,8631799,8631800,8631801,8631802,8631803,8631804,8631805,8631806,8631807,8631808,8631812,8631813,8631814,8631816,8631817,8631818,8631819,8631820,8631828,10963878,8631842,8631843,8631844,8631858,8575581,8575582,8575583,8575584,8575733,8575734,8575735,8632385,8632386,8632387,8632395,8632396,8632397,8632398,8632399,8632410,8632435,8632436,8632437,8632438,8632439,8632440,8632441,8632442,8632443,8632444,8632445,8632446,8632447,8632448,8632449,8632450,8632451,8632452,8632453,8632454,8632455,8632456,3230230,8632457,8632458,8632459,8632460,8632461,8632462,8632463,8632464,8632465,8632466,8632467,8632468,8632469,8632470,8632471,10844713,8067918,8067942,10930095,7201272,7201273,7201274,7201309,7201366,10842952,7201608,7201609,7201616,7201617,7201618,7201619,7201620,7201621,7201624,7201727,7201728,7201729,7201730,7201775,7201776,7201777,7201778,7201779,7201780,7201781,7201782,10960305,7201869,7201870,7201872,7201959,7201974,10960474,10843580,7202127,7202132,7202133,7202136,7202161,7202165,7202168,7202171,7202196,10843709,7202205,7202209,7202210,7202259,7202265,7202266,7202285,5654651,11000014,11000015,11000016,11000017,11000018,11000019,11000020,11000021,11000022,11000024,11000025,11000028,11000029,11000034,11000035,11000036,11000037,11000038,11000039,11000040,11000041,11000042,11000043,11000044,11000045,11000046,11000048,11000064,11000082,11000083,11000084,11000093,11000094,10844198,7065457,9794578,9794579,9794580,9794592,7202769,9794594,3237391,3237392,3237398,10959088,10102550,10985141,10102834,10102901,10100083,10944447,7198360,7198361,7198362,7198363,7198364,7198365,7198366,7198367,7198368,7198369,7198370,7198371,7198372,7198373,7198374,7198375,7198376,7198377,7198378,7198379,7198380,7198381,7198382,7198383,7198384,7198385,7198386,7198387,7198388,7198389,7198390,7198391,7198392,7198393,7198394,7198395,8908289,8908290,8908494,8615274,7198688,8908517,7198722,7198723,7198726,11009407,11009408,11009409,11009410,11009411,7199158,7199471,7199508,10101478,10101534,11048387,11048388,11048389,7199844,7200030,7200091,7200094,7200111,7200115,7200127,7200128,7200129,10102026,7196259,7196260,7196261,7196276,7196277,7196282,7196285,7196286,7196287,7196291,7196307,7196308,7196309,7196310,7196311,7196312,7196313,7196316,7196317,7196333,7196337,7196345,7196355,10618178,10618179,10618180,10618181,7196505,7196506,7196507,7196508,7196511,7196512,7196515,7196516,7196517,7196520,7196523,7196524,7196525,7196526,7196527,7196528,7196531,7196532,7196533,7196539,7196542,7196544,11007196,11007197,7197019,10838801,10838820,10838821,10838834,3234552,3234553,3234660,3234661,3234662,3234663,3234664,8907434,8907435,8907461,8907462,8907463,8907464,8907465,3234860,3235053,10619885,10619886,10619889,7198138,8541471,3232382,8541668,10954002,10954003,10954004,3232910,3232913,3232914,3232915,8905662,8905663,8542254,8612652,8905930,10614969,10951651,10951652,10951653,10951654,10620117,10620118,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620202,10951828,10964891,10964892,10847971,10615258,10615363,10615389,10425937,10965296,10965298,10965299,10615710,10426193,10615896,8540418,10426338,10426339,10426340,8540612,8540613,8540614,8540626,8540631,8540633,3231703,8611342,10616553,8611390,10616644,10616888,10610966,10610967,10610969,10610971,10610975,10610976,10610977,10610978,10610980,10610982,10610996,10614048,10565319,10611184,10611186,10611187,10611188,10611191,10614203,10614221,6669828,7059861,10614376,10611423,10611441,10611603,10611804,10611856,9214215,9214216,6666259,10612191,10612192,10612194,10612201,10612268,10609285,9171641,10609313,10612319,10612320,10612321,10612380,10612381,10612909,10612916,10612931,10612935,10612936,10612937,10612938,10612939,10612940,10612941,10612942,10612943,10613031,10613127,10613144,10613337,10613350,10613369,10613391,10613392,10613393,10558592,10558596,10613513,10613514,10613515,10613524,10613525,10613760,10610901,6677466,6677467,6677468,6673506,9169318,6673552,6673563,7055541,7055546,9169428,10515280,10515281,10515282,6673685,6673686,6673687,6673688,6673689,6673690,10117682,6673692,10117683,6673693,10117684,6673694,6673695,6673696,6673697,6673698,6673699,6673700,6673738,10117743,10117744,10117745,10117746,10117747,7055722,7055724,9169586,10117792,10515423,9169638,10117974,10515609,10515610,10515611,10515612,10515613,10118016,10517681,9169965,6674175,10118171,6674249,6674256,6674276,6674278,6674280,6674281,6674308,6674309,6674310,6674311,6674312,6674313,6674327,6674328,6674329,6674330,6674331,10118391,10118392,10516142,10516157,10516158,10516160,10516161,10516162,10516163,10516165,10516166,10512852,6672521,9192336,9192346,10417296,10417297,10417298,10417300,10419306,6672592,10417312,10417313,10417314,10417315,10417318,10417319,10417320,10417321,10417322,10417323,10417324,10415325,10417325,10417326,10417327,10417331,10415342,10419349,10419350,10419370,9168453,10417424,10419437,10419438,10419439,6672725,9168669,6672896,6672897,6672898,6672899,6672900,6672901,9168709,9168710,10417633,6673064,6673082,6673085,6673086,6673087,6673088,6673089,10418807,10418808,10418809,10418810,10418812,10418813,10419813,10418814,10419814,10419815,10419816,10418817,10419817,10419818,10419819,10419820,10418820,10419821,10418821,10419822,10418822,10418823,10419823,10418824,10419824,10418825,10419825,10419826,10418827,10419827,10419828,10419829,10418830,10419830,10418831,10419831,10418832,10419832,10419833,10418833,10419834,10418834,10418835,10419835,10419836,10418836,10418837,10419837,10418838,6673122,10419838,10418839,10419839,10418840,6673124,10419840,10418841,6673125,10419841,10419842,10418842,10419843,10418843,10418844,10419844,10418845,10419845,10419846,10418846,10419847,10418847,10418848,10419848,10419849,10418849,10418850,10419850,10418851,10418852,10418853,10418854,10418856,10418859,10418860,10418861,10418863,9169071,10117317,10469245,10123006,8550036,8550037,8550038,9175040,8916794,9175955,9175956,10468551,9168103,9168162,10888487,10888552,10888553,10893754,10893755,10893756,10893757,10893758,10893759,10893760,10893983,10889019,10889020,10889021,10884075,10884094,10884097,10884799,10884800,10885072,10885074,10885156,10885165,10885166,10885167,10880207,10880208,10880209,10885212,10885213,10885313,10885316,10885347,10885348,10885349,10885350,10885465,10885468,10885469,10632010,10632014,10627319,10627321,10883403,10161705,10885742,10161868,10886058,10886059,10886060,10891100,10162249,10886250,10891654,10626145,10891655,10886878,10886910,10886918,10631412,10631413,10631414,10631415,10631416,10631417,10631418,10631419,10631420,10631421,10631422,10631423,10631424,10631425,10631426,10631427,10631428,10631429,10631430,10631431,10631432,10631433,10631434,10631435,10631436,10631437,10631438,10631439,10631440,10631441,10631442,10631443,10631444,10631445,10631446,10631447,10631448,10631449,10631450,10631451,10631452,10631453,10631454,10167992,10887052,10887171,10626724,10626725,10882284,10882359,10598535,10598867,10590278,10590279,10590280,10590308,10590309,10590310,10590311,10644383,10647518,10590887,10590996,10582561,10588641,10591922,10525323,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529385,10529386,10529387,10529388,10529389,10529390,10529391,10529392,10529393,10529394,10529395,10529396,10529397,10529398,10529399,10529409,10529410,10529411,10529412,10529413,10529423,10528214,10522256,10522257,10522260,10528350,10542423,10542424,10542440,10542441,10542453,10534567,10534570,10534571,10534572,10534573,10534574,10534575,10534576,10534577,10534578,10534579,10534580,10534581,10534582,10534583,10534584,10534585,10534586,10534587,10534588,10534589,10534590,10534591,10534592,10534593,10534595,10534596,10534597,10542602,10542603,10528630,10528631,10528632,10528633,10528634,10528635,10528638,10528639,10528640,10528641,10542654,10522889,10527020,10543041,10543042,10498250,10498251,10498252,10498367,10498499,10486191,10408159,10408653,10408655,10408656,10476375,10408820,10408823,10408824) 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'