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(10962664,10962665,10962666,10962667,10939611,7075988,7075989,10962676,10939616,7075994,10962690,10962692,7076045,7076046,7076047,7068070,7068071,10943527,4970340,10943583,10943584,10943585,4970383,10943701,7068296,7068371,10940082,4970677,8569465,10943933,4970755,7068705,10944191,10944200,10963496,10944263,10944321,10944345,8066965,8067104,7074223,7066232,8067290,8067292,8067356,7074379,8067357,8067358,7074383,10437244,8067427,8067449,8067462,7074535,7066561,8067553,10437433,7066580,8067689,10437569,10437573,4968962,7066824,7066876,10437745,10938619,7067003,8067911,8067912,10961708,10961717,10961802,10961955,10961956,10961957,10961963,7067425,7067457,7067458,10962150,10962165,7075551,7067617,7075662,7075663,7075664,7075665,7067667,7067668,7067669,7067670,7067671,7067672,7067673,7067674,8068581,4969938,7067739,7067740,7067741,7067742,10962438,10962440,7067775,8068668,7067783,10962474,10962556,7067887,7075904,10959623,10959632,6000232,6000234,6000236,6000237,10959653,10959676,10959678,10959682,7072016,10959712,10959723,7072040,7072041,7064071,10959819,10959829,10959854,10959857,7064230,7064231,7072248,7064326,10960053,7064370,10960064,10960071,10960072,10960078,10960079,10960092,10960105,10960119,10960120,10960121,10960135,10960140,10960142,10960156,7064521,7064550,7064580,10931959,8065618,10960348,8065653,8065691,10960456,10960472,7073140,7073141,10960830,7073198,10960922,4967455,4967456,7073292,7073293,7065332,10961029,7065389,7073409,8066432,7065457,7065549,7065591,10932949,10932950,7065611,7065615,7073616,4967840,7073626,10961356,10961357,7065691,8066678,10933053,10933054,10933055,10933056,10933057,10933058,7073714,10933071,10961412,10933075,10933090,10933096,7065754,7065755,7065756,7065757,7065758,8066740,7073764,7065786,7065787,7065788,7065789,7065790,7065791,7065798,7065799,7065800,7073820,7073827,10933176,7073862,7065862,7073864,7073865,7073882,8066861,10961570,7073886,10961573,7073890,7073895,7073915,7065916,7073922,10942632,7071094,7071247,7071248,10958942,11049200,8064280,8064281,8064282,8064283,8064284,8064285,11049273,10959103,8064479,8064480,8064481,8064482,7071546,7071579,7071585,7071638,10959350,7071676,10943308,10943324,10959386,10959413,10959414,6000012,6000013,6000014,6000021,6000024,10959443,10959473,6000156,7071886,7071887,7071888,7071889,6000200,6000202,6000203,6000206,6000208,6000211,10959614,6000212,10959615,6000213,6000215,10944371,10944372,10944373,10944475,7069067,10940698,10944508,10940721,10940741,10940767,10944610,7069295,7069402,3655997,10941053,10944855,10944882,10944883,10941130,10941131,10957270,10957278,7069679,11047608,11047618,11047619,7069757,3656367,3656368,7069895,7069975,8072774,3656687,3656688,3656689,3656690,3656691,3656708,8072921,8072928,7070211,3656808,3656809,3656810,3656811,3656812,3656813,3656814,11048303,10942029,10942030,10942139,10942140,7070520,10958253,11048533,7070672,11048641,8073491,7070774,7070780,10942511,10623001,10923699,10928716,10928737,10928738,10928739,10618265,10618271,10618288,10618289,10618290,10923809,10923862,10618370,10923932,10923936,10923938,10623492,10623493,10924023,10924026,10623587,10623588,10623589,10623590,10924214,10924215,10924244,10924270,10623872,10623873,10623903,8070799,8070856,10624169,10624170,10624171,10624172,10924838,10924842,10624403,10924945,10924957,10924961,10924963,10924964,10925069,10925079,10925081,10925085,10925086,10925087,10925088,10925091,10619590,10619591,10925201,10925203,10925340,10925354,10925358,10925362,10619896,10621967,10621969,10621989,10622000,10622001,10622002,10622003,10922518,10622011,10622037,10622038,10622039,10617048,10622048,10622049,10617049,10622050,10617050,10622051,10622052,10622070,10622093,10622094,10622098,10917613,10917629,10617193,10922842,10917855,10622363,10617470,10617483,10928109,10928154,10928200,10620006,10620009,10615168,10615200,10615223,10920739,10920838,10615390,10921021,10615516,10921027,10926028,10926150,10926151,10926152,10926153,10921158,10921170,10926270,10616017,10916569,10916570,10916571,10916578,10916579,10916580,10916581,10916582,10916583,10916584,10916585,10916586,10916593,10916594,10916599,10916600,10916601,10916602,10916603,10916604,10916605,10916614,10916615,10916616,10916617,10916618,10916622,10916623,10916624,10916625,10916627,10916628,10916629,10916630,10916631,10916641,10916642,10916643,10916644,10916645,10916646,10916647,10916650,10916660,10616151,10916661,10616152,10916662,10616153,10616154,10616155,10616156,10916670,10916672,10621164,10916674,10916676,10916677,10916678,10916687,10916688,10916689,10916691,10916692,10916693,10916694,10916695,10916696,10916699,10916700,10916701,10916702,10916707,10916711,10916712,10916713,10916714,10616211,10916724,10616217,10616218,10616227,10616228,10616229,10616230,10616234,10616235,10616248,10616249,10616250,10616251,10616252,10616253,10616254,10616255,10616256,10616261,10616265,10616266,10616267,10616268,10616269,10616270,10616287,10616288,10616305,10616306,10616311,10616312,10616313,10616314,10616315,10616316,10616319,10616332,10616335,10616336,10616345,10616346,10616350,10616351,10616352,10616353,10616378,10926889,10616381,10616382,10616383,10616405,10616409,10616410,10921923,10616430,10616431,10616432,10616434,10926947,10616447,10921962,10921963,10616572,10927115,10616827,10616836,10616837,10616838,10917348,10616923,10922459,10565195,10614202,10611203,10614211,10562423,10614280,10614316,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10611345,10565496,10611346,10565497,10611347,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10611386,10565537,10565538,10565539,10565540,10565541,10565542,10611392,10565543,10565544,10565545,10565546,10565547,10565548,10614414,10562577,10562578,10562579,10562580,10562581,10611438,10559594,10559595,10559596,10559597,10559598,10559599,10559600,10559601,10614464,10611504,10611506,10611507,10611508,10611559,10559735,10559736,10559737,10611615,10614643,10614644,10611655,10566110,10566111,10611986,10612054,10609118,10609132,10609162,10612167,10612324,10612326,10612346,10612352,10609374,10609382,10609388,10609389,10609393,10609481,10609489,10557816,10612706,10557866,10557867,10609732,10609733,10609734,10609735,10609855,10612885,10612910,10612911,10612931,10612971,10613006,10610041,10610055,10610059,10613079,10613111,10613112,10610178,10613189,10610323,10610328,10610329,10610331,10613703,10564882,10610748,10613753,10613778,10613779,10613780,10613781,10613782,10613783,10613808,10515123,10515124,10517145,10517146,10517147,10517148,10517170,10517171,10517172,10517173,10517174,10517175,10517176,10517177,10517178,10517287,10517288,10517660,10517661,10517662,10517663,10517664,10517665,10517666,10517667,10517668,10515844,10515845,10515846,10515847,10515848,10515849,10515850,10515851,10515852,10515853,10515854,10515855,10515856,10515857,10515858,10515859,10515860,10515861,10515862,10515863,10515864,10515865,10515866,10515867,10515868,10515869,10515870,10515871,10515872,10515873,10515874,10515875,10515876,10515877,10515878,10515879,10515880,10515881,10515882,10515883,10515884,10515885,10515886,10515887,10515888,10515889,10515890,10515891,10515892,10515893,10515894,10515895,10515896,10515897,10515898,10515899,10515900,10515901,10515902,10515903,10515904,10515905,10515906,10515909,10515910,10515911,10515912,10515913,10515914,10515915,10515916,10515917,10515918,10515919,10515920,10515921,10514015,10516056,10516057,10516122,10512210,10512211,10512213,10514235,10512380,10512382,10512387,10512389,10512415,10516476,10516478,10516479,10516480,10516481,10516484,10512846,10512847,10512848,10514882,10514884,10516909,10516910,10516911,10516912,10516913,10516914,10516915,10516916,10515043,10417251,10419317,10419350,10418369,10418406,10416489,10419641,10419642,10419643,10419644,10419645,10416648,10416649,10416650,10416671,10415688,10415690,10417726,10417727,10417728,10416847,10416848,10416849,10416850,10416851,10419923,10419020,10420200,10466902,10468913,10466914,10466955,10466968,10463035,10469043,10469058,10467118,10467124,10467131,10467133,10467136,10467137,10467139,10467143,10467146,10467156,10467158,10463199,10463200,10463348,10467373,10467374,10469487,10467488,10471566,10467579,10465727,10463762,10463765,10465793,10465795,8563298,10464043,10464045,10468179,10468232,10466336,10466341,10466401,10468411,10468412,10468449,10468459,10464527,10464528,10464529,10464647,10466705,10468823,10468825,10466855,10466863,10466864,10466865) 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'