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(8595134,10873885,10873960,10237459,4970684,10843643,10843644,10843645,10843646,7076367,7076368,5654715,10277157,10277158,10277178,10277179,10277180,10277181,10277182,10277198,10277199,10277200,10277201,10277202,10277203,10277204,10928835,10844579,10844580,10277548,10277549,10277550,10277551,8837773,8837774,8837775,8837776,10102556,7200804,10857905,10857906,10857907,10857980,10275522,7075336,10236713,10236714,10236715,10275790,8594724,8911147,8594758,10197943,10275962,10275963,10275964,10275965,10275966,10275967,10275968,10103467,7072091,7072095,7064341,7064372,7064400,7064466,8615830,7064468,7064469,3236442,3236443,3236444,3236445,3236446,10208905,10195950,8625974,8625975,8625976,3236904,10870216,10274774,10274775,10274871,10248881,8558122,3234789,10194254,10868016,3235161,8861399,3925453,10839833,8563842,8615069,5999993,3235663,10270266,10270267,10270268,10270269,10270270,10270271,10270272,10270273,10270274,10270275,10270276,10270277,10270278,10270279,10270280,10270281,10270282,10270283,10270284,10270285,10270286,10270287,8542192,8542224,8553725,7069327,7069328,7069329,8542378,8542379,7196240,10245068,10245069,10232087,10232088,10232118,10206237,3923964,10941901,10941902,3234498,10867495,10850727,10850728,10863751,3230910,3230911,10433121,10281308,10281309,10281310,10851052,10623492,9217617,9217619,9217631,9217634,3231530,10426508,9218014,9218017,9218042,8577721,8577722,8541197,8541198,8552640,8552641,8552642,8552643,10230442,10230443,10852044,8552713,10865365,10865375,3232544,8541736,10852544,10927534,10927535,10927536,10927537,10927538,10927539,10927540,10927541,10927542,10927543,10927544,10927545,10849720,10927609,10849783,10849833,10849834,8632463,8632465,10847626,10189862,10189863,10189864,10189865,10189874,10189875,10189876,10189877,10189878,10189879,10189880,10189881,10189882,10189883,10189884,10189885,10189886,10920643,10615134,10930023,8630429,8630442,8630446,3228428,10200759,10845866,8838613,9214819,9214902,10615906,10848660,10279085,10279096,10253189,10253190,10253191,10253192,10253193,10253194,10253195,10253196,10253197,10253198,10253199,10253200,10253201,10253202,10253203,10253204,10253205,10253206,10253207,10253208,10253209,10448384,10459201,8621489,8621490,8621516,10240402,10240403,8621538,10459413,10459414,10862148,10862149,8631569,8622119,10849604,10862625,10559296,10939745,10562351,9189603,7019347,10614441,8853662,10122168,10562790,10562791,10562792,10562793,10562794,10562795,10562796,10562797,10562798,10562799,10562800,10562801,10562802,9198012,9214047,9913533,10612023,7017053,7017054,7017055,7017056,7017057,7017058,7017059,7017060,7017061,7017062,7017063,7017064,8851365,8851427,8851433,8851457,8851489,6675913,6675914,6675915,6675916,6675917,6675918,6675919,6675920,6675921,6675922,10612423,9211777,9195953,8851807,6676259,6676260,9914377,9914378,10120370,9180206,9188214,9188215,9188216,9188217,9188220,9188234,10564137,10564138,10564186,10564187,10938723,10938724,8852326,9915048,9915049,8567411,8567412,8567416,7018733,7018734,7018735,7018736,9915308,8853095,7018934,7018935,7018936,7018937,7018938,10125542,10125543,9911677,9169483,9161483,9161484,9161530,9161531,9161532,10515473,10515474,10515475,10515476,10515477,10515478,10515479,10515480,10515481,10515482,10125953,10125954,7056054,7056055,10126119,8849805,8849849,7023697,9210097,9210098,9210100,7023823,7023891,9210248,10118584,10118824,9170636,9170637,7016405,7016406,10516576,10516577,10516578,10516579,10516580,10516581,10516582,10516583,10516584,10516585,10516586,10516587,10516588,10516589,10516590,10516591,10516592,10516593,10516594,10516595,10516596,7024445,7016499,7016500,7016501,7016502,7016503,7016504,7016505,7016506,7016507,7016508,7016509,7016510,7016511,7016512,7016513,7016514,7016515,7016516,7024526,8552188,9171044,9171045,9171046,9179183,8851011,6675403,8851091,10427777,10427778,6680848,10418677,9208846,9208847,9208848,9176942,9177164,9177165,9177166,9177167,9177168,9177169,9177191,9177192,10417215,4971314,4971315,4971318,8864988,9206620,9206624,10467256,8549909,3656071,3656072,3656092,9175166,9191247,9191251,9191252,9191253,9191254,9191255,9183265,8855353,976374,9207597,9207671,8917362,9207853,10116146,8551245,9168248,10629127,10889656,10889657,10884715,10165918,10165919,10874925,10884931,10890050,10895389,10895396,10895397,10163805,10168835,10168939,10168940,10168941,10168942,10168943,10168999,10169164,10169165,10169166,10169374,10169375,10883400,10169462,10169463,10169464,10169465,10169466,10169467,10169468,10169469,10900674,10176841,10176842,10181881,10181882,10181883,10181884,10176904,10187645,10631292,10187847,10187848,10187850,10877060,10877064,10877092,10877093,10877094,10877096,10877097,10877098,10877099,10877181,10882267,10882268,10882269,10882270,10882271,10882272,10882273,10882274,10882275,10882276,10601136,10652655,10586637,10586638,10586639,10586640,10586641,10586642,10586649,10586650,10586651,10586652,10586653,10586654,10586655,10586656,10586668,10586669,10586670,10586671,10586672,10586673,10586674,10586675,10586676,10586677,10586678,10586679,10586680,10586681,10586682,10586683,10602534,10586684,10586686,10586687,10586688,10586689,10586690,10586711,10586712,10586713,10586714,10586715,10586716,10586717,10586718,10586719,10586720,10586721,10586722,10586723,10586730,10586731,10586733,10586736,10586737,10586738,10586739,10586740,10586747,10586748,10586749,10586750,10583756,10583772,10583773,10583774,10583775,10605726,10584127,10584128,10584129,10584130,10587279,10587280,10587281,10644381,10644382,10587432,10587433,10587439,10587440,10587441,10587449,10587450,10587451,10587452,10587453,10587454,10587455,10587456,10587461,10587462,10587463,10587464,10587465,10587466,10587467,10587468,10587469,10587477,10587478,10587479,10587480,10587481,10587482,10587483,10587484,10587485,10587486,10587487,10587497,10587498,10587502,10587503,10587504,10587505,10587506,10587507,10587508,10587509,10587510,10587511,10587512,10587513,10587514,10587522,10587523,10587524,10587525,10587526,10587527,10587528,10587531,10584636,10584637,10584638,10584639,10584640,10584641,10584642,10584643,10584644,10584645,10584646,10584647,10584648,10584649,10584650,10584651,10584652,10584653,10584654,10584655,10584656,10584702,10584703,10584704,10584705,10584706,10584707,10584708,10584709,10584710,10584714,10584715,10584716,10584717,10584718,10584719,10584720,10584721,10584722,10584723,10584724,10584725,10584726,10584727,10584734,10584735,10584736,10584737,10584738,10584739,10584740,10584741,10584744,10584745,10584759,10584760,10584778,10584779,10584780,10584781,10584782,10584791,10584792,10584793,10584794,10584795,10584796,10584797,10584798,10584808,10584809,10584810,10584811,10584812,10584813,10584835,10584839,10584840,10584841,10584842,10584860,10584862,10584864,10584868,10584869,10584870,10584890,10584892,10606745,10584898,10584899,10584900,10584901,10584902,10584926,10584927,10584928,10584951,10584952,10584953,10584954,10584955,10584956,10584957,10606903,10606904,10606943,10606965,10654297,10654304,10645398,10567357,10567358,10567359,10585379,10588379,10585380,10588380,10585381,10588381,10585382,10588382,10585383,10588383,10588384,10588385,10588386,10588387,10588388,10588389,10588390,10585391,10588391,10588392,10588393,10588394,10588395,10588396,10588397,10588398,10588399,10585400,10585401,10585403,10585404,10588404,10585405,10588405,10585406,10588406,10588407,10588408,10588412,10588413,10588414,10588415,10588416,10588417,10588418,10588419,10588423,10588424,10588425,10588426,10588427,10588428,10588429,10588430,10588431,10588432,10588433,10588435,10588436,10588437,10588438,10588439,10588440,10588441,10588442,10588443,10567546,10601410,10585891,10545356,10545357,10545358,10529500,10529501,10529502,10529503,10529504,10521632,10521633,10531804,10531805,10531806,10531807,10531808,10531809,10531810,10531811,10531812,10531813,10531814,10531823,10547912,10546002,10546003,10546004,10546045,10546093,10546094,10546095,10546128,10546129,10546130,10546131,10546132,10546133,10546134,10546135,10546136,10546180,10546181,10546209,10546469,10544495,10544496,10544497,10544498,10544499,10546508,10546509,10546510,10546511,10546512,10546513,10546514,10546515,10546516,10546517,10546518,10546519,10546520,10546521,10546522,10546523,10546524,10546525,10546526,10546527,10546528,10546529,10546530,10546531,10546532,10546533,10546534,10546535,10546536,10546537,10546538,10546539,10546540,10546541,10546576,10538821,10520899,10543058,10543059,10543060,10543061,10543062,10420282,10424513,10506510,10506511,10420665,10510065,10407314,10407342,10486126,10486127,10407981,10463686,10463687,10412489,10412490,10412491,10495165,10412566,10478549,10478550,10478551,10406923,10406947,10407169) 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'