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(11001876,8569849,4971119,4971120,3229348,3229353,3229364,8621952,3229587,10963858,10963859,8622066,8622067,8622098,8067367,8583901,8584002,8622500,10847469,7066766,7066767,10951414,10951415,10951416,8622647,7066836,10847602,4969227,7067016,10844858,10844859,10844860,10844861,10844862,10844863,10929648,7067518,7067602,7067605,7075719,7075720,7075721,7075722,7075723,10930115,10930116,10930117,10930118,10930119,10447731,7201200,7201201,7201202,7201203,7201204,7201205,7201206,7201207,7201208,7201209,7201210,7201211,7201212,7201252,7201253,7201317,7201318,7201354,7201368,8618045,8618046,8618047,8618048,8618049,8618050,8618051,8618052,8618053,8618054,8618055,8618056,8618057,8618058,8618059,8618060,8618061,8618062,7201532,7201534,10103483,10103484,10103485,10843189,10843190,10931814,10986248,10986249,10986250,10986251,10986252,10986253,10986254,8836059,10986255,8836060,7201905,7201906,7201976,7201977,7202059,7202060,7202061,7202062,7202063,7202064,7202069,10843617,10843618,7202312,7202313,7202314,7202315,7202316,7202317,7202318,7202319,7202320,7202321,7202322,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202345,7202346,7202347,7202364,7202365,8836796,8836797,8836798,8836799,7073332,7073333,7073334,7073335,7073336,7073337,10104543,7065421,7065422,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,7202695,7202696,7202697,7202698,3227197,11036621,11036622,7200607,7200608,10102537,10102538,10102645,10102646,10102647,10102648,7071554,7071555,10842334,10842335,10842336,3238011,7200874,7200875,10943256,5999936,5999937,3238114,3238115,10842483,8970226,7198325,7198327,3655659,3655660,3655661,3655662,3655663,3655664,3655665,3655666,3655667,3655668,3655669,3655670,3655671,3655672,3655673,3655674,3655675,10944756,10944757,10944758,10840138,10100601,10840241,10840242,7069502,7069707,7069708,7069709,7069710,7069711,7069712,7069713,7069714,7069715,3236231,7199077,3236301,3236302,3236304,8073009,8073010,8073011,8073012,8073013,8073014,8565123,8616249,8616268,10841195,10841337,10942322,7070772,7070847,11048772,10942512,10942513,10942514,10942515,10942516,3233373,11045714,11045715,11045716,7196291,10618229,7196524,8070064,8070080,8070116,10623485,10623486,10623487,10623488,10623489,3233945,3233946,3233947,3234107,8070882,8070883,8070884,8070885,3234573,3234574,3234575,3234576,3234577,3234578,3234579,10624203,10619237,10619238,10619239,10619240,11008173,11008174,11008175,7197899,7197900,7197901,7197902,7197903,7197904,7197905,7197906,7197907,7197908,7197909,7197910,7197911,7197912,7197913,3235114,3235115,3235116,3235117,3235118,3235119,3235120,3235121,3235122,3235123,3235124,3235125,3235126,3235127,7197955,3235128,3235129,3235130,3235131,3235132,3235133,3235134,3235135,3235136,3235137,3235138,3235139,3235140,3235141,3235142,3235143,3235144,3235145,3235146,3235147,3235148,3235149,3235150,3235151,3235152,3235153,3235154,3235155,3235156,3235157,3235158,3235159,3235160,3235161,3235162,3235163,3235164,3235165,3235166,3235167,3235168,3235169,3235170,8614587,3235171,8614588,8614589,3235172,3235173,8614590,3235174,8614591,3235175,8614592,8614593,3235176,3235177,8614594,8614595,8614596,10839653,8541538,8541539,8541647,3232686,3232687,3232688,3232689,3232690,3232691,3232692,3232693,3232694,3232695,3232696,3232697,3232698,3232699,3232700,3232701,3232702,3232703,3232704,3232705,3232706,3232707,3232708,3232709,3232710,3232711,3232712,3232713,3232714,3232715,3232716,3232717,3232718,3232719,3232720,3232721,3232722,3232723,3232724,3232725,3232726,3232727,3232728,3232729,3232730,3232731,3232732,3232733,3232734,3232735,3232736,3232737,3232738,3232739,3232740,3232741,3232742,3232743,3232744,3232745,3232746,3232747,3232748,3232749,3232750,3232751,3232752,3232753,3232754,3232755,3232756,3232757,3232758,3232759,3232760,3232761,3232762,3232763,3232764,3232765,3232766,3232767,3232768,3232769,3232770,3232771,3232772,3232773,3232774,3232775,3232776,3232777,3232778,3232779,3232780,3232781,3232782,3232783,3232784,3232785,3232786,3232787,3232788,3232789,3232790,8578989,8569917,10847694,8569918,8569919,8569920,8569921,8569922,8570027,10951716,10951717,3230511,8570107,3230586,8570144,8570147,8570167,8570168,8570169,8570170,8610067,11043084,11043085,8570409,8570433,8570447,11043163,11043164,11043165,11043166,11043167,11043168,11043169,8570466,10848386,10848463,10848464,10848465,10952531,10922168,8541188,10927416,10927417,10927418,10927419,10927420,10927421,10927422,10927423,8863825,9189614,9189615,9189616,9189617,9189618,9189619,9189633,9189635,10559692,10559693,10559694,10559695,10559696,10559697,10559698,10559699,10122095,10122096,9190235,8542562,8542563,8542564,8542565,8542566,8542567,8542568,8542569,8542570,8542571,8542631,8542632,8542633,8542634,8542635,8542636,8542637,8542638,8542639,8542640,8542773,8542774,7057878,7057913,9171761,9171783,9171796,9171797,9211802,9171811,9211827,7058144,7058145,7058146,7058147,7058148,7058149,7058150,7058170,10609714,8862765,8862766,10610030,9172412,9172413,9212484,10558317,10558318,10558319,10558320,7058805,10121023,10121024,10121025,10613547,9197121,9197122,9197123,9197124,9197125,9197126,9197127,9197128,9197129,9197130,9197131,9197132,9173142,9173143,9173176,7055933,9209933,9209934,9209935,9209936,9209937,7056191,4974969,10514062,10514063,10514064,10514065,10514066,10514067,10514068,10514069,10514070,10514071,10514072,10514073,9162342,9170489,10118901,10514643,10119200,7057198,10514893,10514894,10514895,10514896,4973161,8918182,8918183,9184632,9184811,4973769,4973770,4973771,4973772,8865127,8865128,9166874,9182953,9190991,9175071,9191095,9175108,9167139,3963467,3963468,3963469,3963470,3963471,3963472,8550352,8550353,8550354,9183314,9183315,9183316,9183317,9183318,9183319,9183320,9183321,9183322,9183323,9183324,9183325,9183326,9183327,9183328,10123577,10123578,10123579,10123580,10123581,10123582,8550584,8550585,8550586,8550587,9167441,8917249,8917250,8917251,8917252,8917253,8917254,8917255,8917256,8917257,8917258,8917259,4972614,4972615,8917532,8917533,8917534,8917535,8917536,8917537,8917538,8917539,8917540,8917541,8917542,8917543,8917544,8917545,10462588,9184054,6668091,6668092,6668093,6668094,6668095,10184487,10184673,10184730,10184746,10184749,10184753,10184764,10184834,10184857,10184922,10184951,10628446,10628447,10628448,10628449,10175127,10175128,10175129,10175130,10175131,10175132,10175133,10175134,10175135,10175136,10175137,10175138,10175139,10185140,10185165,10185166,10185181,10185206,10185228,10185251,8594301,10185405,10185445,10185462,10165491,10165516,10884549,10185566,10185626,10185628,10165658,10884729,10185766,10185813,10185818,10185865,10185885,8069245,10165934,10185935,10185968,10185969,10185971,10185978,10185980,10186010,10186021,10166024,10186028,10186029,10166033,10166042,10186043,10186045,10186054,10186078,10186095,10186104,10186106,10186107,10186115,10186116,10186118,10186119,10171121,10171122,10171123,10186123,10171124,10171125,10171126,10171127,10171128,10171129,10171130,10171131,10171132,10171133,10171134,10171135,10171136,10171137,10171138,10171139,10166446,10166462,10166471,10632002,10158531,7000889,7001000,10627324,7001182,7001183,7001184,7001185,10627663,10627775,10627803,10627816,10627817,10627818,10627819,10627820,10627851,10627852,10627853,10627854,10627855,10630238,10630239,10166796,10166818,10166906,10167266,10626111,10172752,10626297,10163025,10163028,10631655,10631656,10188216,10163317,10163318,10163319,10163320,10163321,10163322,10598445,10598446,10599015,10599016,10587135,10585469,10585470,10591922,10583049,10529374,10529375,10529376,10529377,10529378,10529379,10529380,10529381,10529382,10529383,10529384,10529400,10529401,10529402,10529407,10529409,10529410,10529411,10529412,10529413,10529416,10529417,10529418,10529419,10529420,10529421,10529423,10529424,10529425,10527828,10527829,10527830,10527831,10527832,10527833,10527834,10527835,10527836,10527837,10527838,10520827,10522890,10422354,10422403,10422404,10422405,10421482,10498448,10423738,10423739,10423740,10424875,10424943,10422167,10423173,10495889,10488292,10488293,10488294,10488295,10488296,10476424,10476425,10476426,10476427,10476428,10476429,10476430,10476431,10476432,10476433,10476434,10476435,10476436,10476437,10476438,10476439,10476440,10476441,10476442,10476443,10476444,10476445,10476446,10476447,10476448,10476449,10476450,10476451,10476452,10476453,10476454,10476455,10482844,10482845,10482846,10482847) 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'