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(8068815,8068818,8068819,8068820,7075844,8068847,7075885,7075909,7075930,7075954,10943519,10943520,10943521,10943522,10943523,10943524,10943525,10943526,10943527,10943528,10943529,10943530,10943531,7068228,7068247,7068248,7068255,7068256,7068283,7068288,7068289,7068295,4970646,4970647,4970648,7076320,4970659,4970660,7068333,7076393,8569399,8569400,8569401,10944011,10944012,10944013,8569551,8569580,7068612,7068613,7068614,7068615,7068616,7068617,7068618,7068619,7068620,7068621,7068622,7068623,7068624,7068625,7068626,7068627,7068628,7068629,7068630,7068631,7068632,7068633,7068634,7068635,7068636,7068637,7068638,7068639,7068640,7068641,7068642,7068643,7068644,7068645,7068646,7068647,8569623,7068648,7068649,7068650,7068651,7068652,7068653,7068654,7068655,7068656,7068657,7068658,7068659,7068660,7068661,7068662,7068663,7068664,7068665,7068666,7068667,7068668,7068669,7068670,7068671,7068672,7068673,7068674,7068675,4971077,4971078,4971079,4971080,4971084,7065858,7065859,7065893,7073971,7066168,7074291,7074316,7066365,7066369,7066376,7066384,7066391,7066435,7066436,7066437,10437397,7066467,10437558,7074772,7066784,7066822,4969178,4969179,7074898,7075174,7067182,4969548,7067233,7075233,7067234,7075234,7067235,7075235,7075236,7067236,7075237,7075238,7067241,7075256,7075280,7075334,7075498,7075514,7075541,7075542,7075543,7075544,7075545,7075546,7075547,8068612,8068613,8068614,8068615,7067639,7067640,7067641,8068659,8068660,8068661,7067678,8068662,8068663,8068664,8068665,7075682,8068666,8068722,8068723,8068724,7075741,7075742,7075743,7075744,7075745,7075746,7075747,7075748,7075749,7075750,7075759,7075760,7075761,7075762,7075763,7075764,7075796,7075798,7072068,7072077,7072107,7072111,10931582,10931640,7064214,7064215,7064216,7064217,7064218,7064219,7064220,7064221,7064222,7064223,7064224,7064225,7064226,7064227,7064228,7064229,7064230,7064231,7064232,7064233,7064234,7064235,7064236,7064237,7064238,7064239,7064240,7072301,7072302,7072303,7072304,7072305,7072306,7064401,10931896,10931897,7072473,7072474,7072482,7064490,7064491,7064531,10932186,10932221,7072877,7072878,7072879,7072880,7072881,7072882,7072883,7072925,10932472,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967451,4967452,4967453,4967454,4967455,4967456,4967457,4967458,4967459,4967460,7073194,10932711,10932785,10932786,10932809,10932931,10932946,10932950,10932966,10932967,10932968,7071014,10942750,8860979,10942795,8861032,8861072,8861073,8861074,8861190,10943105,10943106,10943107,10943108,8861347,10943198,7071520,10943255,8861470,8861498,8861499,5999932,10943424,10944384,10940685,10940686,10940687,10940772,7069185,7069186,7069340,10941117,7069409,7069410,7069412,7069413,7069414,7069415,7069416,7069419,7069420,7069421,7069422,8859514,8859515,8859516,8859517,8859518,8859519,8859520,8859521,8859522,8859523,8072560,8072561,8072588,8072589,10941835,10941836,10941931,8860336,8860400,10942320,10942321,10942322,10942323,10942324,7070620,8860529,7070668,7070669,10942410,7070727,7070780,10923538,10923539,10923540,10928641,10928642,10618282,10618283,10618284,10618285,10623345,10618360,10618361,10618362,10618363,10623439,10618721,10618956,10618957,10618958,10619104,10619105,10619228,10619360,10619361,10619831,10619884,10619885,10619886,10619887,10619896,10922485,10922486,10922488,10922489,10616987,10927556,10927557,10927558,10927581,10617087,10617095,10927614,10927632,10927633,10617119,10927637,10622123,10927641,10927644,10927645,10927658,10617144,10927674,10927680,10927698,10617201,10927761,10927762,10927763,10927767,10927773,10927774,10927777,10927778,10622273,10927840,10927920,10927921,10922938,10622427,10622429,10622447,10622448,10622449,10927968,10927969,10927970,10927971,10927972,10927973,10927974,10927975,10927976,10927977,10617635,10617746,10928337,10928338,10622871,10614983,10614991,10614993,10620005,10615013,10615065,10615236,10620238,10615437,10615438,10615501,10926036,10615543,10926098,10926099,10926100,10615591,10926111,10926161,10926162,10926168,10615883,10926411,10615896,10926439,10926442,10926443,10926444,10615928,10615943,10615952,10615957,10926476,10926535,10926536,10926537,10926550,10926551,10921556,10921557,10921558,10921559,10926565,10926598,10926605,10921607,10921608,10921612,10921613,10921619,10926656,10926657,10926658,10926659,10621163,10921956,10921957,10921958,10921959,10921960,10621444,10621459,10621460,10621461,10621462,10621463,10616548,10927072,10927073,10927074,10927075,10927076,10927110,10927111,10621620,10922153,10922154,10621640,10621641,10621642,10621697,10616707,10922225,10922226,10922230,10922231,10922232,10621728,10616733,10616734,10616735,10922270,10922271,10922329,10922330,10922331,10922332,10922333,10927358,10927361,10927465,10927466,10927467,10927468,10922468,10927469,10927470,10927471,10927472,10927473,10927474,10927475,10927476,10927477,10927478,10565187,10565188,10565190,10565191,10565194,10565197,10565198,10565199,10565200,10565201,10565202,10565203,10565204,10565205,10565206,10565207,10565208,10565209,10565210,10565211,10565212,10565213,10565214,10565215,10565216,10565217,10565218,10565219,10565220,10565221,10565222,10565223,10565224,10565225,10565226,10565227,10565228,10614078,10565229,10614079,10565230,10565231,10565232,10565233,10565234,10565235,10565236,10565237,10565238,10565239,10565240,10565241,10565242,10565243,10565244,10565245,10565246,10565247,10565248,10565249,10565250,10565251,10565252,10565253,10565254,10565255,10565256,10565257,10565258,10565259,10565334,10559467,10614493,10565673,10614567,10614568,10562870,10562871,10614787,10614788,10614857,10566009,10566024,10566025,10566026,10566027,10566028,10566029,10566030,10566031,10566032,10566033,10566034,10566035,10566036,10566037,10566038,10566043,10611985,10612050,10612107,10563590,10563591,10563592,10563593,10563594,10563595,10563596,10563597,10563598,10563599,10563600,10563601,10563602,10557614,10557615,10557616,10612490,10612491,10612492,10612499,10612501,10612505,10563657,10563658,10563659,10563660,10563661,10563662,10563663,10563664,10563665,10563666,10612516,10612578,10612601,10612666,10612667,10612668,10612679,10612680,10612699,10612704,10612753,10612754,10612755,10612771,10612781,10612803,10557970,10612824,10557980,10557981,10557982,10557983,10557984,10557985,10557986,10557987,10557988,10557989,10557990,10557991,10612842,10557992,10557993,10557994,10557995,10557996,10557997,10557998,10557999,10558000,10558001,10558002,10558003,10558004,10558005,10558006,10558007,10558008,10558009,10558010,10558011,10558012,10558013,10612864,10558014,10558015,10558016,10558017,10558018,10558019,10612869,10558020,10558021,10558022,10558023,10558024,10558025,10558026,10558027,10558028,10558029,10558030,10558031,10558032,10558033,10558034,10558035,10558036,10558037,10558038,10558039,10558040,10558041,10558042,10558043,10558044,10558045,10558046,10612939,10613057,10613096,10613145,10613259,10558478,10613350,10613369,10561579,10561580,10561581,10561585,10561588,10561589,10561590,10561591,10561596,10561598,10561605,10561607,10561616,10561617,10561618,10561619,10561620,10561623,10561624,10613475,10561628,10561629,10561630,10561635,10561636,10561637,10561638,10561639,10558819,10558820,10558821,10513118,10513119,10513120,10513121,10513122,10513123,10513124,10513125,10513126,10513127,10513128,10513129,10513130,10513131,10513132,10513133,10513220,10513221,10513222,10513223,10513224,10513225,10513226,10513261,10513262,10513263,10513264,10513265,10513266,10513267,10513268,10513269,10513292,10513309,10513311,10513312,10513313,10513314,10513315,10513316,10513317,10517320,10517546,10513574,10513575,10517620,10517621,10511651,10513740,10511747,10517749,10517750,10517751,10517752,10512018,10512019,10514027,10514083,10514095,10514107,10512141,10514155,10512221,10514227,10514271,10514272,10512347,10512348,10512349,10512350,10512351,10512352,10512353,10512354,10512355,10512356,10512357,10512358,10514364,10518453,10518454,10512495,10512496,10512497,10512498,10514586,10514587,10514588,10514589,10514590,10514605,10514606,10514607,10514608,10514802,10514824,10514834,10514870,10514871,10514872,10515024,10515025,10515026,10515027,10515028,10515029,10515030,10515031,10515032,10515078,10515079,10515080,10513083,10515096,10416262,10416274,10416275,10416337,10416341,10417360,10417367,10417377,10417378,10417385,10419392,10416411,10417474,10416494,10417522,10417523,10416545,10419941,10419968,10419973,10416986,10416987,10417016,10420164,10420165,10420182,10417186,10420190,10417194,10420195,10420196,10420200,10417202,10420208,10420212,10467247,10467248,10467249,10467250,10467251,10467462,10467463,10471497,10467786,10467787,10467788,10470065,10470070,10466246,10466247,10466384,10470535,10470649,10464807) 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'