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(11027558,11027559,11027560,11027561,11027562,11027563,11027564,11027565,11027566,11027567,11027568,11027569,11027570,11027571,11027572,11027573,11027574,11027575,11027576,11027577,11027578,11027579,11027580,11027581,11027582,11027583,11014584,11027584,11027585,11014585,11014586,11001645,11014791,7076128,11002050,11015152,7068524,7068525,11002252,11002253,11002254,11002255,11002256,10989314,10989315,11041317,10976573,11002626,7065968,7073971,7073991,10963695,10963696,10963697,7074037,7074101,11002812,11002813,11002927,7074271,11003026,11042131,11042132,11042133,11042134,11003166,11003167,11003168,11003169,11003170,11003171,11003172,10990360,10990361,10990362,11003372,11003373,10961514,10961515,10961769,10961821,10961822,10961823,10961879,10987949,11013980,11013981,11013982,11013983,11013984,7067371,7067372,10939425,10939435,11001441,11001442,10972860,10972861,10931640,10972949,10972977,10986011,11025090,11025091,11025092,11025093,11025094,11025095,11025096,11025097,11025098,11025099,11025100,11025101,11025102,11025103,11025104,11025105,11025106,11025107,11025108,11025109,11025110,11025111,7064490,7064491,7072616,10999340,10999341,10999342,7072764,7072817,11012529,11012530,11012531,11012532,7072862,7072912,8066033,7072973,7072974,11012965,11012966,11013024,11013342,11013343,10961429,10961430,10961431,11023501,11023552,11023673,11023674,7071014,7071184,11023880,10943183,8064674,8064675,7071711,7071713,7071752,7071782,11021803,11021804,11021805,11021806,11021807,11021808,11021809,11021810,11021811,11021812,11021813,11021814,11021815,11021816,11021817,10969935,11034977,11034978,11034979,10970014,10970015,11035111,11035112,10970183,11035400,11035401,11035402,10970405,10970406,10970407,11035529,11035530,11035531,11035532,11035533,11035534,11022580,11022581,11022582,11022583,11022584,10970747,10970748,7070107,11022793,11022919,11022920,10997079,10997080,10971092,11023143,11023144,10971183,10971184,10997214,10997215,10997314,11023341,10997441,11023456,10918527,10918528,10918744,10967952,10918924,10967953,10918925,11019965,11019966,11019967,10623582,11007190,11020232,10919294,10968343,11020442,11020443,11033561,10994586,10994587,10968602,11033611,11033612,11033613,11033614,10968615,11033615,10919628,10919629,10919630,10919631,10919632,11033762,11033763,11033764,11020815,11020816,11020817,11020818,11020819,11020820,11020821,11020822,11020823,11034107,10969232,10969233,10969234,10969235,10969236,10969237,10969238,10969239,10917489,10917525,11031694,11031695,11031696,11031697,11031698,11031699,11031700,11031701,10917742,10922901,10922902,11018971,11032075,10918159,10954188,10954189,10954190,10918357,11032482,10990501,10990502,10990503,10990544,10990545,10920568,11003597,10920569,10920672,10920673,10920674,10920675,10920698,10920761,10920774,11029826,11029827,11029828,11029829,11029830,11029831,11029832,11029833,11029834,11029835,11029836,11029837,11029838,11029839,11029840,11029841,11029842,11029843,11029844,11029845,11029846,11029847,11029848,11029849,11029850,11029851,11029852,11029853,11029854,11029855,10964884,10964885,10620359,10915895,10915896,10915897,10915901,10920925,11017037,11017038,11017039,10921095,10921096,10921097,10921098,10921099,11004334,10921350,11004475,11004476,11004548,11004549,10921564,10921565,10921566,10921567,10921626,10921627,10921628,10921643,10921644,10965694,10965695,10965696,11004703,11004704,10921764,10921765,10921766,10921776,10921777,10921778,11004846,11004847,11004848,11004849,11030972,11030973,11030974,11030975,11030976,11030977,11030978,10616701,11031279,11031280,11031281,11005287,11005288,10616905,11031460,9189712,8864283,9190017,9190018,9166042,9190055,9190101,9166102,10557112,10557113,10557114,10557115,10557116,10557117,10557118,10557119,10557120,10612101,10609104,9195451,9195563,10609365,9195719,9195720,9195721,9187724,10557568,9195792,9195793,9195794,9187813,9187814,9187817,9187999,9188000,10612679,9172031,9196079,9196123,9188128,9172177,9172178,9172179,9172180,9172182,9172256,9172257,9172258,9172259,9172260,10610007,10610093,9196467,9196468,10613275,10613277,10613293,10613294,9172631,10613295,9172632,10613296,9172633,10613297,10613298,10613299,10613300,10613301,10613302,10613303,10613304,7058809,10613356,10613357,10613365,10613366,10613367,10613368,10558542,10558543,10558544,10558545,10558546,10558547,10558548,10558549,10558550,10558551,10558552,10558553,10558554,10558555,10558556,10558557,9189046,10610796,9189137,9193454,10511477,9193675,10555492,10511494,10511495,10511501,10511502,10511503,10511504,10511505,10511507,10511508,10511509,10511510,10511520,10511523,10511524,10511525,10511526,10511527,10511528,10511529,10511530,10555539,10511539,10555540,10555541,10555542,10555543,10555544,10555545,10511545,10555546,10555547,10555548,10555549,10555550,9193781,9193782,4974656,4974657,9193828,9193829,9193830,9193831,9193835,9193836,10511734,10511735,9186043,9186044,9186045,9194113,9194114,9194115,9194128,10514025,10514026,10512085,10512086,10512087,10512088,10512089,10512090,10512091,10512092,10512093,10512094,10512095,10512096,10512097,10512098,10512099,10512100,10512101,10512102,10512103,10512104,10512105,10512106,10512107,10512108,10514118,10514120,10514126,10514127,10514128,10514131,10514132,10514135,10514136,10514140,10514147,10514150,10514154,10514157,10514170,10514193,10514194,10514195,10514196,10514202,10514203,10514204,10514205,10514206,10514208,9194498,9194499,10556339,10556340,10514370,10514371,10514372,10514435,10514436,10514437,10514438,10514439,10514440,10514441,10514442,10514443,10514444,10514445,10514446,10514447,10514448,10514449,10514450,9194638,10514451,9194639,10514452,10514453,10514454,10514455,10514456,10514457,10514459,10514460,10514463,10514464,10514465,10514466,10514467,10514468,10514469,10514470,10514471,10514473,10514474,10514475,10514476,10514477,10514478,10514479,10514480,10514481,10514482,10514483,10514484,9170692,10556568,9194775,9194893,9195119,9195138,10515060,10515061,10515062,10515063,10515064,10515065,10515066,10557097,10557098,10515098,10557099,10515099,10557100,10515100,10557101,10515101,10557102,10515102,10557103,10557104,10557105,9195293,10557106,10557107,10557108,10557109,10557110,10557111,9176491,10416428,9176515,9184571,10417513,10417514,9176621,10419597,10419601,9168714,9168715,9168717,9176750,4973605,10418847,10418848,9176963,9193101,10417118,10417125,9169271,10417194,9174447,9174448,9182466,9174583,9174619,9174620,4971509,9182776,10469914,10469926,9175547,10468177,9175621,9175622,10468360,10470391,10470395,10470503,9167964,10470598,9184133,8917791,10174518,10164548,10164549,10164550,10164551,10164552,10164553,10164554,10628050,10628086,10179829,10174830,10628321,10179889,10179966,10164987,10179992,10180156,10180157,10180192,10180193,10180194,10180195,10180196,10165229,10165230,10165231,10180557,10180558,10180559,10180598,10180599,10180600,10180601,10180602,10180603,10180604,10180605,10165715,10165716,10165867,10180941,10180942,10180968,10180969,10629574,10181238,10181239,10181240,10166327,10166328,10166329,10629859,10629885,10629925,10629931,10629932,10629933,10164249,10629995,10629996,10167247,10167292,10172316,10177405,10177406,10177407,10177417,10177418,10177429,10172865,10631443,10178185,10178186,10178187,10178190,10178191,10178192,10178193,10571467,10571468,10574481,10574482,10574483,10577532,10577533,10568549,10568679,10568680,10568681,10568682,10568683,10568684,10574720,10574728,10574729,10574730,10577767,10577768,10574783,10574805,10568908,10568909,10571910,10571911,10571912,10571913,10571914,10571915,10571916,10574939,10574940,10574941,10574942,10574943,10574944,10574945,10574946,10574947,10574948,10581033,10578075,10578076,10578077,10578078,10578079,10581095,10581096,10581097,10581098,10575198,10578207,10578218,10578320,10569326,10578398,10578399,10566415,10566416,10566417,10566418,10566419,10566420,10566421,10566422,10575434,10575435,10575456,10575457,10575458,10566557,10566560,10566613,10566614,10566615,10566616,10566617,10578803,10578930,10573029,10573030,10573031,10573032,10576198,10576199,10576279,10570290,10570291,10582559,10576759,10576760,10576761,10576762,10576763,10573795,10571097,10521168,10521169,10521170,10521171,10521172,10521177,10521178,10521179,10521180,10521182,10521183,10519703,10519704,10519705,10529727,10530656,10530657,10530658,10530659,10530660,10530661,10530662,10530663,10530664,10530665,10530666,10530667,10530668,10530669,10530670,10530671,10530672,10530673,10530674,10530675,10530676,10530677,10530678,10530679,10530680,10530681,10530682,10530683,10530684,10530685,10520819,10528827,10425243,10424323,10498386,10423601,10424690,10424023,10477265,10477312,10477313,10481475,10473621,10481681,10481682,10481683,10481684,10481685,10481686,10481687,10481688,10481689,10481690,10481691,10481692,10481693,10481694,10481695,10481696,10481697,10481698,10481699,10481700,10477914,10477963,10478073,10478124,10478179) 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'