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(10939610,10939649,10939734,10943591,10943592,10943593,10943594,10943595,4970405,4970406,4970407,4970408,4970520,4970521,10939940,10939941,10939942,10940220,10940221,10940222,10940223,10940224,10940225,10940226,10940227,10940228,10940283,10940284,10940285,10940286,10940287,4971081,4971082,10933336,10933337,10933357,4968335,4968410,4968411,8067286,8067523,10437568,8067918,10938673,8067943,10939383,10939439,10939443,8065695,8065730,8065731,8065732,8065841,8065953,8065954,8065955,8065956,8065957,8065958,10932350,10932351,10932352,8066170,8066171,10932955,10932962,10932969,10932970,10932973,10932974,10932976,10932977,4967870,4967871,4967872,10942633,8064221,8064222,8064223,8064554,8064555,8064556,10943289,8970227,8970228,8970229,8970230,8970231,8970232,3655782,10940960,10941046,10941047,10941058,3656933,3656987,10623056,10623116,10623169,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,10623665,10623713,10624131,10624132,10624133,10624552,10624553,10624554,10622864,10622865,10620076,10620079,10620080,10620082,10620183,10620289,10620290,10620291,10620292,10620302,10620303,10620335,10620764,10620765,10620766,10620767,10620768,10620769,10620770,10620771,10620772,10620773,10620774,10620775,10620776,10620777,10620778,10620779,10620780,10620781,10620782,10620783,10620784,10620785,10620786,10620787,10620788,10620789,10620790,10620791,10620792,10620793,10620794,10620795,10620796,10620797,10620893,10620894,10620895,10621034,10565127,10565144,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10565200,10565205,10565206,10565207,10565211,10565220,10565225,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565247,10565248,10565252,10565253,10565254,10565255,10565256,10565258,10565259,10565266,10565267,10565268,10565269,10565270,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565278,10565279,10565280,10565281,10565282,10565283,10565284,10565285,10565286,10565287,10565288,10565289,10565296,10565299,10565300,10565303,10565324,10565325,10565326,10565327,10565328,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10565362,10565363,10565364,10565365,10565366,10565367,10565368,10565369,10565370,10565371,10565372,10565373,10565374,10565375,10565376,10565377,10565378,10565379,10565380,10565381,10565382,10565383,10565384,10565385,10565386,10565387,10565388,10565389,10565390,10565391,10565392,10565393,10565394,10565395,10565396,10565397,10565398,10565399,10565400,10565401,10611252,10565402,10611253,10565403,10565404,10565405,10565406,10565407,10565408,10565409,10565410,10565411,10565412,10565413,10565414,10565415,10565416,10565417,10565418,10565419,10565420,10565421,10565422,10565423,10565424,10565425,10565426,10565427,10565428,10565429,10565430,10565431,10565432,10565433,10565434,10565435,10565436,10565437,10565438,10565439,10565440,10565441,10565442,10565443,10565444,10565445,10565446,10565447,10565448,10565449,10565450,10565451,10565452,10565453,10565454,10565455,10565456,10565457,10565458,10565459,10565460,10565461,10565462,10565463,10565464,10565465,10565466,10565467,10565468,10565469,10565470,10565471,10565472,10565473,10565474,10565475,10565476,10565477,10565478,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10611339,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,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,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565544,10565545,10565546,10565547,10565549,10565550,10565551,10565552,10565553,10565554,10565555,10565556,10565557,10565558,10565559,10565560,10565561,10565562,10565563,10565564,10565565,10565566,10565567,10565568,10565569,10565570,10565571,10565572,10565573,10565574,10565575,10565576,10565577,10565578,10565579,10565580,10565581,10565582,10565583,10565584,10565585,10565586,10565587,10565588,10565589,10565590,10565591,10565592,10565593,10565594,10565595,10565596,10565597,10565598,10565599,10565600,10565601,10565602,10565603,10565604,10565605,10565606,10565608,10565609,10611459,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10611470,10565621,10565622,10565623,10565624,10565625,10565626,10565627,10565628,10565629,10565630,10565631,10565632,10565633,10565634,10565635,10565636,10565637,10565638,10565639,10565640,10565641,10565642,10565643,10565644,10565645,10565649,10565650,10565651,10565652,10565653,10565654,10565655,10565656,10565657,10565658,10565659,10565660,10565661,10565662,10565663,10565664,10565665,10565666,10565667,10565668,10565669,10565670,10565671,10565672,10611523,10565673,10565674,10565675,10565676,10565677,10565678,10565679,10565680,10565681,10565682,10565683,10565684,10565685,10565686,10565687,10565688,10565689,10565690,10565691,10565692,10565693,10565694,10565695,10565696,10565697,10565698,10565699,10565700,10565701,10565702,10565703,10565704,10565705,10565706,10611560,10611578,10611583,10611586,10611605,10611611,10611615,10611623,10611640,10611643,10611646,10611647,10611648,10611649,10611659,10611782,10611789,10611830,10611833,10611834,10566061,10566062,10609035,10609036,10609099,10609100,10609309,10609356,10609369,10563570,10563574,10563575,10563581,10563582,10609845,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10610015,10610024,10610030,10610061,10610104,10610479,10610480,10610481,10610482,10610691,10610695,10610709,10610739,10564989,10564990,10610841,10564992,10564993,10564995,10610898,10610899,10610958,10517202,10517203,10517204,10517205,10517206,10517207,10517208,10517209,10517210,10517211,10517212,10517213,10517214,10517215,10517216,10517217,10517218,10517219,10517220,10517221,10517222,10517223,10517224,10517225,10517614,10517615,10517616,10517617,10517618,10517670,10517681,10517693,10517790,10517791,10517792,10517793,10517806,10517809,10518648,10518649,10518650,10518651,10518652,10518653,10518654,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,10518664,10518665,10518666,10518667,10518668,10518669,10518670,10518671,10518672,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,10518682,10518683,10518684,10518685,10518686,10518687,10518688,10518689,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10518698,10518699,10518700,10518701,10518702,10518703,10518704,10518705,10518706,10518707,10518708,10419306,10419307,10419349,10419468,10419469,10419470,10419473,10419474,10419475,10419476,10419481,10419489,10419490,10419493,10419507,10419510,10419512,10419518,10419521,10419523,10419527,10419531,10419534,10419536,10419537,10419538,10415575,10415576,10415598,10419673,10419674,10419675,10415676,10415677,10415678,10415680,10419680,10419690,10419703,10419705,10419713,10419718,10419719,10415726,10415727,10419729,10415731,10419734,10415736,10415737,10419738,10419742,10419810,10415836,10415837,10415885,10415886,10419894,10419895,10419896,10419995,10419996,10419998,10420001,10420002,10420003,10420005,10420007,10420009,10420010,10420012,10420013,10420088,10420089,10420090,10420094,10420098,10462890,10462891,10463004,10463006,10463023,10463046,10463049,10463050,10463051,10463052,10463057,10463058,10463059,10471172,10471173,10471174,10463376,10463377,10463378,10463379,10463380,10463433,10463434,10463436,10463437,10463439,10463654,10463659,10463666,10463667,10463668,10463669,10463672,10463729,10463732,10463733,10463793,10463800,10463802,10463807,10463811,10463812,10463813,10463817,10463819,10463820,8563199,8563200,8563201,8563202,8563359,8563360,10462292,10462295,10462296,10462297,10462299,10462302,10462303,10462304,10462308,10462309,10462321,10462322,10462323,10462333,10462334,10462403,10462413,10462414,10462415,10462420,10462422,10462423,10462432,10462433,10462434,10462435,10462441,10462517,10462530,10462531,10462584,10462591,10462592,10462593,10462594,10462595,10462601,10462602,10462609,10462626,10462729,10462731) 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'