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(11001551,11001552,11001553,11001554,11001555,11001556,11001557,11001558,11001559,11001560,8574071,11001687,11001688,11001689,11001690,10845909,10845910,8838688,8838690,8838692,8838693,8838734,8838735,10846105,10846131,10846132,10448302,4970933,11002352,11002353,11002534,11028600,11028601,11028602,11028603,11028604,11028605,11028606,11028607,11028608,11028609,11028610,11028611,11028612,11028613,11028614,8621794,8621795,8575154,8575164,11002685,8067196,7074127,11002850,8583654,7074261,11002957,11003061,8067496,8575618,10951167,11029230,11003263,11003264,11003411,11003412,10961564,10961565,10961566,10961567,10961568,8573090,7074969,8619815,7075018,10961705,10961706,8619875,8619892,8619925,10961791,10961792,10961793,10961794,8573312,8620025,8837688,8837689,8837690,8620089,8620090,8620229,11040082,8620249,11014111,11040111,11014112,8837918,11014113,8837924,8837925,8620284,8837973,8837991,11040190,11040199,11040200,11040213,8068529,8573758,8573759,11014300,11014301,11014302,11014303,11014304,11014364,11014365,8838172,8573861,8838173,8573862,8573907,8838224,8617692,8910931,8617746,10842683,10972831,10972888,10986014,11012127,11012128,11012129,11012130,11012131,10973154,11012218,8836024,7072645,7072733,7072989,7073026,8836652,8836659,8836695,11026094,11026095,11026096,11026097,11026098,11026099,11026100,11026101,11026102,11026103,11026104,11026105,11026106,11026107,11026108,11026109,11026110,11026111,11026112,11026113,11026114,11026115,11026116,11026117,11026118,11026119,11026120,11026121,8066510,8619457,11036532,11023546,8910001,8910008,8910009,8910010,10102169,11023742,11023743,7071210,8617066,11023957,11023958,8617227,8861309,8617284,7071469,8617315,8910543,8910544,8617406,8617506,8617543,8617575,10972442,8617607,8617610,7071789,8617642,10969532,10969533,10969534,10969535,10969536,10969537,10969538,10969539,10969540,10969541,10969542,10969543,11034583,11034584,11034585,8908001,8908002,11034722,11034723,8614983,8614984,8615011,10970061,10970062,8615317,11022235,11022236,11022237,11022238,11022239,11022240,10941336,10970344,10970345,10970346,10970445,11035632,11035633,11035634,11035635,11035636,11035637,11035638,11035639,11035640,11035641,11022700,11022701,11022702,11022703,8909153,10970821,8909418,8909419,10101495,8909426,8909427,8909428,8909429,10971106,10997140,10997141,7070463,8616320,10997268,10997269,8909652,8909661,11023354,11023355,11023356,11023357,11023358,11023359,11023360,11023361,10997392,10942428,8909832,8909836,8909837,8909838,8909839,8909840,8909841,10997479,10997480,10918567,10918568,10618090,10918685,8906108,8906109,11032823,11032824,11032825,8906259,8906266,8906267,8613091,11020063,11020064,11020065,11020066,11020067,11020068,11020069,8906444,8906452,10919092,10919093,11020330,10919399,10919400,11020477,8906956,10994625,10994735,10994736,10919731,10919732,10919733,10919734,10919747,10919748,10838883,11033835,11033836,11033837,11033838,10968876,10968877,10968878,10968879,10968880,10968881,10919883,10919884,10919885,10919886,11021175,11021176,11021177,11021178,11021179,11021180,11034296,8907687,8907720,11031517,11031518,11031519,11031520,11031521,11031522,11031523,11031524,11005628,11005774,11031852,11031853,11032202,11032203,11032204,11032205,8905742,10918432,10925515,8576051,8576078,8609755,11003626,11003627,10920683,10615229,10615245,10920830,10920831,11003921,10920900,11004074,11004075,11004151,8576700,8576701,8576702,8576703,8576705,10952248,8576834,8576878,10921366,11004425,11030447,11030448,11030449,11030450,11030451,11030452,11030453,11030454,11030455,11030456,11030457,11030458,11030459,11030460,11030461,11030462,11030463,11030464,11030465,11030466,11030467,10921449,10921491,11004595,11004596,8577095,10921604,8577200,8577201,10921692,10921693,8577269,11030785,11030786,11030787,11030788,11030789,11030790,11030791,11030792,11030793,11030794,11030795,10921817,10921818,10921819,10921820,10921821,10921822,10921824,10921825,10921826,10921827,10921828,10921829,10921830,10921831,10921832,8904255,8904304,10426630,10921922,10921949,11005004,8577498,11005005,8577508,8577509,8577510,8577511,8904391,8577512,11031076,11031077,11031078,11031079,11005100,10922188,10922189,10922190,10922197,10922198,8577761,8577793,8577851,11031366,11031367,11031368,11031369,11031370,11031371,11031372,11031373,11005429,11005430,10614236,8864233,8864234,9190066,8864725,8864752,9195335,9195336,9195337,9195338,9195360,10557229,10557230,10557231,9203421,9203422,9195471,9195510,9195511,9195512,9195515,10557403,9195597,9195598,9203602,9203603,9203615,9203616,9187669,9195689,9195690,9203709,9203710,9203711,9203712,9203722,9203723,9195741,9195742,9187753,9203765,9195841,9195842,9187842,9187843,9187948,9187949,9203969,9203973,9203974,9188033,9204058,9196060,9204065,9204066,9196143,9188263,9204284,10612954,9204305,9204365,7058734,7058817,7058818,7058819,9204716,9189057,10610745,10555119,10555120,10555121,7055539,9193421,9193424,9193466,9193655,10555690,10555691,10555692,9194008,9194009,9194010,9194011,9194012,10515837,10515838,9202026,10515839,10515840,9202074,9202152,9202159,9202161,9194233,9194234,9194235,9194242,9194243,9194244,9194245,9202346,9202348,9202352,10556169,10556170,10556171,10556172,10556173,10556174,10556175,10556176,10556177,9194409,9194410,9194415,9194416,9202495,9202497,10556380,10556393,10556394,10556475,10556477,10556478,10556479,9194670,9194671,9194784,9202787,10556611,10556612,10556613,10556614,10556615,10556616,10556617,9202905,9195001,9195002,9195003,9195004,9195005,10556879,10556880,10556881,10556882,10556883,10556884,9195203,9195204,9195213,9195214,9195215,9195216,9176475,9176476,9200545,9200546,9200548,9184561,9176636,9200643,9176689,9176768,9200791,9200869,9200870,9176968,9169277,10471187,10471203,10471204,4971571,10469583,10469596,10470028,8917276,10470414,10470417,10470418,10470421,9199895,9199896,9199897,10116120,10116121,10470539,10470542,10470546,10470606,10470607,10470608,10466856,10466857,10466858,10466859,10466860,10466861,10466862,10466863,10466864,10466865,10466866,10628044,10883576,10628071,10628177,10164704,10164705,10164706,10164707,10164708,10164709,10164710,10164711,10164712,10174792,10164831,10174845,8593870,10179913,10179949,10179974,10179976,10165115,10165116,10165117,10165118,10165301,10165302,10180316,10180324,10180325,10180326,10180327,10180328,10180329,10180330,10180331,10628903,10165619,10165620,10165621,10180738,10180759,10180760,10180761,10180762,10165803,10165897,10165898,10629471,10181058,10181059,10181060,10181069,10181070,10181071,10181072,10629698,10629699,10181340,10181341,10181342,10629863,10629864,10629865,10629890,10629950,10629951,10629952,10626980,10626984,10626985,10183554,10183555,10183696,10183699,10183776,10183778,10627704,10164321,10166534,10166583,10166584,10181585,10181586,10181594,10181595,10181718,10166724,10181743,10181744,10181745,10166763,10166902,10166991,10162105,10182113,10182114,10182115,10182119,10162184,10177242,10177243,10177244,10177245,10177246,10182275,10182281,10172358,10182415,10182421,10177424,10177425,10182510,10182514,10182703,10182704,10182707,10172847,10182878,10183018,10183025,10183103,10183106,10183191,10183195,10183221,10183275,10183276,10183359,10183362,10183400,10577156,10577157,10580161,10580162,10580163,10577259,10577260,10571581,10571582,10571583,10571584,10571585,10571586,10571588,10574769,10574770,10574771,10574772,10574773,10574774,10574775,10574776,10577794,10568811,10568812,10568813,10568814,10568815,10568816,10572105,10572106,10572107,10572108,10572109,10572115,10572116,10578116,10572117,10578117,10578118,10578119,10578120,10569192,10578233,10578234,10590275,10572284,10575317,10575318,10578327,10578328,10578478,10578479,10578480,10578481,10575504,10578508,10578509,10578510,10578535,10575609,10575613,10578702,10575720,10575931,10575932,10579189,10579190,10576281,10579408,10579409,10579410,10579411,10579412,10579413,10579443,10579444,10579445,10579446,10579447,10579448,10579449,10579539,10579540,10579541,10579542,10579543,10579544,10579573,10576874,10576875,10577045,10577046,10577047,10577048,10535112,10535113,10535114,10535115,10535116,10535652,10535653,10535654,10535655,10535656,10535657,10535658,10535659,10535660,10529660,10535661,10529661,10535662,10535663,10535664,10535665,10535666,10535667,10536212,10534218,10536231,10536232,10536233,10536488,10536489,10536490,10536491,10536492,10528718,10540729,10528756,10534762,10534763,10534764,10534765,10534766,10528779,10540780,10540781,10540782,10540783,10540784,10528811,10540857,10540918,10540943,10541078,10535105,10535106,10535107,10535108,10535109,10535110,10535111,10487884,10488057,10479240,10486576,10479951,10477984,10478086,10478087,10478088,10478148,10478245,10493428,10493430,10493432,10478740,10482777,10482792,10493799,10493804) 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'