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(7076125,8630917,4970721,4970722,3229109,10846507,10846508,8631476,8631580,8631626,10950652,8575208,8631858,10951029,8632211,8632213,8632215,10964441,10964442,10964443,8617987,8617988,10985861,8911775,10986445,10986446,10986473,7202444,7202508,7202509,7202510,7202683,7202684,7202685,7202686,7202687,7202688,7202689,7202690,7202691,7202692,7202693,7202694,10932824,7200233,7200606,11037191,8910604,8910605,10102683,10102686,10102687,10842384,8071672,8071673,8071737,8071738,10944447,8071802,8071803,7198360,8071867,8071868,7198389,8071932,8071933,8071997,8071998,8072062,8072063,8072127,8072128,7198680,10941060,7198685,7198700,7198701,8072192,8072193,8908520,7198724,7198733,7198752,7198764,8072257,8072258,7198770,11009279,8908675,8908676,7199008,8615671,7199569,7199570,8565242,7196431,11007149,4937250,4937251,4937253,4937254,4937260,4937262,4937263,4937272,4937273,4937277,4937278,4937281,4937283,4937284,4937286,4937287,4937288,4937289,4937291,4937292,4937293,4937295,4937296,4937297,4937299,4937300,4937306,4937307,4937308,4937309,4937310,4937311,4937312,4937313,4937322,4937323,4937325,4937326,4937332,4937334,4937335,4937341,4937342,4937346,4937347,4937350,4937352,4937353,4937355,4937356,4937357,4937358,4937360,4937361,4937362,4937364,4937365,4937366,4937368,4937369,4937374,4937375,4937376,4937377,4937378,4937379,4937380,4937381,4937387,4937388,4937390,4937391,4937397,4937399,4937400,4937406,4937407,4937411,4937412,4937415,4937417,4937418,4937420,4937421,3234117,4937422,3234118,4937423,4937425,4937426,4937427,4937429,4937430,3234126,4937431,4937433,4937434,4937439,4937440,4937441,4937442,4937443,4937444,4937445,4937446,4937452,4937453,4937455,4937456,4937462,4937464,10623768,4937465,4937471,4937472,4937476,4937477,4937480,4937482,4937483,4937485,4937486,4937487,4937488,4937490,4937491,4937492,10838522,4937494,4937495,4937496,4937498,4937499,4937504,4937505,4937506,4937507,4937508,4937509,4937510,4937511,4937517,4937518,4937520,4937521,4937527,4937529,4937530,4937536,4937537,4937541,4937542,4937545,4937547,4937548,4937550,4937551,4937552,4937553,4937555,4937556,4937557,4937559,4937560,4937561,4937562,4937564,4937569,4937570,4937571,4937572,4937573,4937574,4937575,4937576,4937582,4937583,4937585,4937586,4937592,4937594,4937595,4937601,4937602,4937606,4937607,4937610,4937612,4937613,4937615,4937616,4937617,4937618,4937620,4937621,4937622,4937624,4937625,4937626,4937628,4937629,4937634,4937635,4937636,4937637,4937638,4937639,4937640,4937641,4937647,4937648,4937650,4937651,4937657,4937659,4937660,4937666,4937667,4937671,4937672,4937675,4937677,4937678,4937680,4937681,4937682,4937683,4937685,4937686,4937687,4937689,4937690,4937691,4937693,4937694,4937699,4937700,4937701,4937702,4937703,4937704,4937705,4937706,4937712,4937713,4937715,4937716,4937722,4937724,4937725,4937731,4937732,4937736,4937737,4937740,4937742,4937743,4937745,4937746,4937747,4937748,4937750,11007712,4937751,4937752,11007713,11007714,4937754,11007715,4937755,11007716,4937756,11007717,4937758,4937759,4937764,4937765,4937766,4937767,4937768,4937769,4937770,4937771,4937777,4937778,4937780,4937781,4937787,4937789,4937790,4937796,4937797,4937801,4937802,4937805,4937807,4937808,4937810,4937811,4937812,4937813,4937815,4937816,4937817,4937819,4937820,4937821,4937823,4937824,4937829,4937830,4937831,4937832,4937833,4937834,4937835,4937836,4937842,4937843,4937845,4937846,4937852,4937854,4937855,4937861,4937862,4937866,4937867,4937870,4937872,4937873,4937875,4937876,4937877,4937878,4937880,4937881,4937882,4937884,4937885,4937886,4937888,4937889,4937894,4937895,4937896,4937897,4937898,4937899,4937900,4937901,4937907,4937908,4937910,4937911,4937917,4937919,4937920,4937926,4937927,4937931,4937932,4937935,10838966,4937937,4937938,4937940,4937941,4937942,4937943,4937945,4937946,4937947,10838978,4937949,4937950,4937951,4937953,4937954,4937959,4937960,4937961,4937962,4937963,4937964,10838993,4937965,4937966,4937972,4937973,4937975,4937976,4937982,4937984,4937985,4937991,4937992,4937996,4937997,4938000,4938002,4938003,4938005,4938006,4938007,4938008,4938010,4938011,4938012,4938014,4938015,4938016,4938018,4938019,4938024,4938025,4938026,4938027,4938028,4938029,4938030,4938031,3234738,3234740,3234741,3234742,7197574,8907411,8907591,8907602,8907613,7197805,8907623,8907641,8907654,8907682,11047465,11047483,8071539,8071540,8071607,8071608,10617138,10617139,10617140,10617326,3232798,3232904,8905765,8905766,8905767,10620118,10425553,10620301,10615343,10615344,10930665,10930666,8540351,8540578,8540579,10953198,10922264,10922290,10565144,10562228,10562229,10562234,10562235,9173717,9173718,9197724,10559609,10614496,10614500,6670318,10611834,9187420,9211555,10612381,9171916,7017828,7017829,7017830,7017831,10610096,9196793,9196794,7018487,10613528,10613870,10613871,10613872,10613873,6673688,7015163,7015164,7015165,7015166,7015167,7015168,10118150,6674186,10118369,10118370,10514017,10118610,10518655,10518656,10518657,10518658,10518659,10518660,10518661,10518662,10518663,9171116,10415232,10415251,10416284,10419307,10416348,10416350,10416353,10416356,10416357,10416358,10416359,10416360,10416361,10416362,10416363,10415370,10416400,10419468,10419471,10419472,10419473,10419477,10419479,10419480,10416481,10419483,10419484,10419485,10419486,10419488,10419489,10419490,10419493,10419494,10419495,10419496,10419497,4973429,10419499,10419500,10419501,10419502,10419505,10419506,10419507,10419509,10419510,10419511,10419512,10419516,10419518,10419519,10419523,10419526,10415585,10415586,10415679,10419705,10419712,10418797,10418807,10418808,10418809,10419810,10418810,10417811,10417812,10418813,10417814,10418814,10417816,10418817,10417818,10418818,10417820,10418821,10417822,10418823,10417826,10418827,10417828,10417830,10418831,10417832,10418833,10417834,10417837,10418837,10418838,10417839,10418840,10417841,10418841,10417843,10418843,10418844,10417845,10418845,10418846,10417847,10418848,10417849,10417850,10418851,10417852,10418853,10417854,10417856,10418856,10417858,10418859,10417860,10418860,10417862,10418863,10417864,10417866,10417868,10417870,10417881,10417883,10417885,10417887,10417889,10417893,10417899,10417903,10417905,10417907,10417915,10417917,10417919,10417921,10417922,10417925,10417927,10417930,10417932,10417934,10417938,9169037,9169038,9169039,10418961,9169040,9169041,10420040,10418048,10417053,10417054,10417055,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417073,10417074,10417075,10417076,10417079,10417080,10417081,10417082,10417085,10417086,10417087,10417091,10417092,10417093,10417094,10417096,10417097,10417098,10417100,10417102,10417105,10417107,10417108,10417110,10417112,10417116,10417119,10417120,10417121,10417122,10417124,10417126,10417128,10417130,10417132,10417135,10417137,10417138,10417139,10417141,10417143,10417144,10417145,10417147,10417149,10417150,10417151,10417152,10417153,10417156,10417157,10417159,10419165,7055440,9190612,10122830,10469344,10469345,10469346,8549957,7020666,8550265,10463746,8563358,8563359,8563360,8563361,8563362,8563363,9207486,9183528,9183529,9207740,9183876,9183877,9207944,9175956,10883559,10889052,10884077,10884324,10890106,10890118,10171192,10171193,10171194,10632044,10627122,10627123,10627124,10632161,10632162,10888457,10885853,10885854,10885855,10885856,10162084,10162085,10162086,10886216,10886217,10886218,10886219,10886220,10886221,10886222,10886223,10886224,10886225,10886226,10886227,10886228,10886229,10886230,10886231,10886232,10886233,10886234,10886235,10188045,10173119,10892158,10892159,10892160,10892161,10892162,10892163,10580211,10580212,10580213,10580214,10580215,10580216,10580251,10580441,10580442,10580443,10580444,10580445,10598594,10643872,10643873,10647527,10647544,10647545,10591801,10541446,10539840,10539841,10528239,10422596,10422597,10422598,10421599,10420850,10422898,10506819,10506824,10422934,10422942,10425029,10425030,10425040,10425097,10483009,10483010,10483011,10483012,10483013,10483014,10483015,10483016,10483017,10483018,10483019,10483020,10483021,10483022,10483023,10407369,10483024,10483025,10483026,10483027,10483028,10483029,10483030,10483031,10483032,10483033,10483034,10483035,10483036,10483037,10483038,10483039,10483040,10483041,10484046,10484047,10483074,10483075,10483083,10483084,10488300,10483420,10483421,10407925,10407947,10407956,10408024,10408026,10408152,10408185,10408187,10408189,10408190,10408193,10408988) 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'