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(7067845,7075889,10943427,10943428,10943429,10943430,10943431,10943432,10939642,10962637,10939748,10939749,10939750,7076092,7076093,10963077,10963078,10963079,10963080,8569414,10944186,8569705,10963506,10963507,7065967,10977286,10977287,10938478,7066952,11001085,11001090,11001091,11001150,10939188,10939189,10939190,10939191,10939192,10939193,10939368,10998515,6000117,7064023,7064045,7064046,7064047,7064048,7064049,7064050,7064051,7064052,7064053,7064054,8065507,8065512,7072463,4967034,4967035,4967036,4967037,4967038,4967039,4967040,4967041,4967042,4967043,4967044,4967045,4967046,4967047,4967048,4967049,4967050,4967051,4967052,4967053,4967054,10932216,10932243,10986526,10960624,10960625,7064942,10960626,7064943,10960627,10960628,10960629,10960630,10960631,10960632,10960633,10960634,10960635,10960636,10960637,10960638,10960639,10960640,10960641,10960642,10960643,10960644,10960645,10960646,10960647,7064964,10960648,10960650,10960651,10960652,10960653,7064969,10960654,10960655,10960656,10960657,10960673,10960674,10960685,10960686,10960687,10960688,10960689,10960690,10960691,10960692,10960695,7073185,7073189,7073379,7065456,8063947,8063948,8063949,8063950,8063951,8063952,8063953,8063954,8063955,10942639,10942673,10942674,10942709,10958955,10958956,10958957,10958958,10958959,10958960,10958961,10958963,10958964,10958965,10958966,10958967,10958968,10959182,10959184,10959185,10959186,10959187,10998482,10998483,10998484,10998485,7069593,10941975,10958205,10958206,10958208,8860436,10942308,7070739,7070811,10928685,10928686,10928687,10928688,10928689,10928690,10928691,10928692,10928693,10928694,10928695,10967806,10967807,10618861,10618862,10617465,10993336,10615076,10925839,8570207,8570231,8570509,8570510,10930601,10930604,10991483,10991484,10991485,10930769,10991520,10991533,10991534,10991535,10991536,10991537,10991538,10991539,10991540,10991553,10930826,10991554,10616048,10616049,10616050,10616052,10991621,10991622,10991623,10991661,10991662,10952786,10952814,10952815,10952816,10952817,10952818,10952819,10952820,10952821,10952822,10952823,10952824,10616596,9165376,10562247,10562248,10562249,10562250,10562251,10562252,10562253,10562254,10562255,10611151,10611152,10611154,10611155,10611157,10611159,10611160,10611161,10559332,10559333,10559334,10559336,9165554,9165555,9173574,9173586,9173593,9165699,9165727,6665751,10614417,9165767,10562651,10562652,10562653,9165865,10559713,8864560,8864562,8864563,8864605,8864606,8864642,8864643,8864653,8864670,8864679,9166185,9166186,9166187,8864710,9166188,8864711,9166189,9166190,9166191,9166192,9166193,9166194,9166195,9166196,9166197,9166198,9166199,9166200,9166201,9166202,9166203,9166204,9166205,9166206,9166207,9166208,9166209,10612131,10612204,10612205,10560487,10563583,10563587,10563588,10563589,10563605,10563606,9171794,10563607,10563608,10563609,10563610,10563611,10563612,10563613,10563614,10563615,10563616,10563617,10563618,10563619,10563620,10563621,10563622,10563623,10563624,10563625,10563626,10563667,10563668,10563669,10563670,10563671,10563672,10563673,10563674,10563675,10563676,10563677,10563678,10563679,10563680,10563681,10563682,10563683,10563684,10557719,10557720,8862484,9172175,9172177,9172178,9172179,9172180,9172181,9172193,9172211,9172212,7058519,7058520,7058526,7058527,7058528,7058532,7058571,7058598,7058599,7058600,7058601,7058602,7058607,7058626,7058652,9172525,9172526,9164601,9172676,10561579,10561581,10561582,10561584,10561585,10561586,10558587,10561587,10561588,10558588,10558589,10561589,10558590,10561590,10561591,10558591,10561592,10558593,10561593,10561594,10561595,10561596,10561597,10561598,10561599,10561600,10561601,10561602,10561603,10561605,10561606,10561607,10561608,10561609,10561610,10561611,10561612,10561613,10561614,10561615,10561616,10561617,10561618,10561619,10561620,10561621,10561622,10561623,10561624,10561625,10561626,10561627,10561628,10561629,10561630,10561631,10561632,10561633,10561634,10561635,10561636,10561637,10561638,10561639,10561640,10561641,10561642,10561643,10561644,10561645,10561646,10561647,10561648,10561649,10561650,10561651,10561652,10561653,10561654,10561655,10561656,10561657,10561658,10561659,10561660,10561661,10561662,10561663,10561664,10561665,10561666,10561667,10561668,10561669,10561670,10561671,10561672,10561673,10561674,10561675,10561676,10561677,10561678,10561679,10561680,10561681,10561682,10561684,10561685,10561686,10561687,10561688,10561689,10561690,10561691,10561692,9172879,10561693,9172880,10561694,9172881,10561695,10561696,10561697,9172884,10561698,9172885,10561699,10561700,9172888,10561701,10561702,10561703,9172891,10561704,10561705,10561706,10561707,10561708,10561709,10561710,10561711,10561712,10561713,10561714,10561715,10561716,10561717,10561718,10561719,10561720,10561721,10561722,10561723,10561724,10561726,10561727,9172914,10561728,10561729,10561730,10561731,9172919,10561732,10561733,10561734,10561735,10561736,10561737,10561738,10561739,10561740,10561741,10561742,10561743,10561744,10561745,10561746,10558819,10558820,10558821,9165092,9173108,9173138,9173139,9173140,9173141,9173142,9173143,9173144,9173145,9173146,9173147,9173255,9170257,9170258,9170259,9170260,9170261,9170311,9170312,9170313,9170314,9170315,9170316,9170317,9170318,9170319,9170320,9170321,9170322,9170323,9170324,9170326,9170338,9170339,9170340,9170341,9170342,9170375,9170376,9170377,9170382,9170383,9170384,9170385,9170386,9170387,9170388,9170389,9170390,9170391,9170392,9170393,9170400,9170403,9170404,9170405,9170408,9170409,9170410,9170412,9170413,9170414,9170415,9170416,9170417,9170418,9170619,9170622,10516471,10516472,10514568,10514569,10514570,10514571,10514572,10514573,10514574,10514575,10514576,10514577,10514578,10514579,9170767,10514580,10514581,10514582,10514583,10514584,10514585,10514586,10514587,10514588,10514589,10514590,10514591,9170779,10514592,10514593,10514594,10514595,10514596,10514597,9170789,9170801,10518616,9170810,9170833,9170838,9170912,9170952,9170953,8861552,8861553,8861554,8861555,8861556,10516929,10516930,10516931,10516936,10516937,10516938,10516939,10516940,10516941,10516942,10516943,10516944,10516945,10516953,10516954,10516955,10516962,9163189,8861736,8861738,10515076,10515077,9160364,9160365,9160366,9160367,9160368,9160369,9160370,9160371,9160521,10416465,10417553,10417554,9168701,7055299,4974020,4974026,4974040,7055363,4974100,9166371,9166374,8864917,9166584,9166643,10467225,10467226,10467227,10467228,10467229,10467230,10467231,10467232,10467233,10467234,10467235,10467236,10467237,10467238,9166872,10465712,9167265,9167266,9167267,9167268,9167269,9167270,9167271,9167272,9167273,9167274,9167275,9167276,8917501,10462470,10462471,10462472,10462473,10462474,10466474,10462475,10466475,10462476,10466476,10462477,10466477,10462478,10466478,10462479,10466479,10462480,10466480,10462481,10466481,10462482,10466482,10462483,10466483,10462484,10466484,10462485,10466485,10462486,10466486,10462487,10462488,10462489,10462490,10462491,10462492,10462493,10462494,10462495,10462496,10462497,10462498,10462499,10462500,10462501,10462502,10462503,10462504,10462505,10462506,10462507,10462508,10462509,10462510,10462511,10462512,10462513,10462514,10462515,10462516,10462517,10462518,10462519,10462520,10462521,10462522,10462523,10462524,10462525,10462526,10462527,10462528,10462529,10462530,10462531,10462532,10462533,10462534,10462535,10462536,10462537,10462538,10462539,10462540,10462541,10462542,10462543,10462544,10462545,10462546,10462547,10462548,10462549,10462550,10628105,10628302,10154858,10160755,10160759,10153885,10153886,10153887,10153888,10153889,10153890,10153891,10153892,10153893,10153894,10153895,10153896,10153897,10159213,10626954,10626959,10568491,10568492,10568493,10568494,10566198,10566201,10566202,10566203,10566204,10566205,10566206,10566207,10566226,10566235,10566263,10566534,10566535,10566554,10566570,10566571,10566572,10566573,10566574,10566575,10566576,10566577,10566578,10566609,10566610,10566611,10566615,10566616,10566617,10566635,10566636,10566637,10566641,10566642,10566643,10566644,10566645,10566646,10567483,10567484,10567485,10567486,10567487,10567488,10567489,10567490,10567491,10567502,10567503,10567504,10567505,10567506,10568026,10568027,10568028,10568029,10568030,10568031,10568032,10568033,10568034,10568035,10568036,10568037,10568038,10568039,10568040,10568041,10568042,10568043,10568044,10568045,10568046,10568047,10568048,10568049,10568050,10568051,10568052,10568053,10568054,10568055,10522253,10522254,10522255,10522499,10522500,10522514,10522515,10522516,10522517,10520818,10522898,10420279,10420280,10420281,10420282,10420283,10420627,10473012,10473019,10473022,10473025,10473045,10473046,10473059,10473065,10473070,10473088,10477389,10477390,10473631,10473634,10476142,10472764) 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'