[SELECT * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants, CASE normalised_name WHEN 'Husa cu protectie camera pentru Iphone 11 Pro Max Orange Pink' THEN 1 WHEN 'Apple iPhone 7 128 GB Black Foarte bun' THEN 2 WHEN 'Televizor LED Akai LT 3233SM 81 cm Smart TV HD Ready Negru' THEN 3 WHEN 'Ceas RETRO INSPIRED 7334' THEN 4 WHEN 'Subler digital 150Ñ…0.01mm cutie depozitare Topmaster 280301' THEN 5 WHEN 'CEAS BARBATESC MATTEO FERARI MF019' THEN 6 WHEN 'Boxa Portabila Soundlink Revolve II Argintiu' THEN 7 WHEN 'Ghete Dama Imblanite Negre din Piele Ecologica Ruby X7369' THEN 8 WHEN 'Ghete Dama Imblanite Negre din Piele Ecologica Ruby X7369' THEN 9 WHEN 'Acumulator compatibil Acer Aspire One Cloudbook 11 AO1 132Swift 1 SF113 31 P2CPmodel AP16A4K' THEN 10 WHEN 'Bratara Metalica Argintie Otel Inoxidabil 18mm 20mm 22mm 24mm 26mm WZ1501' THEN 11 WHEN 'Cana Fimo decorata cu 2 Fete ce tin o inimioara cadou pentru sora mama prietena YODB21206' THEN 12 WHEN 'Ceas Barbati Michael Kors Layton MK8782' THEN 13 WHEN 'Ceas Barbati Michael Kors Layton MK8782' THEN 14 WHEN 'Galaxy A03s Dual Sim Fizic 64GB LTE 4G Negru 4GB RAM' THEN 15 END AS sequence FROM `pt_products` WHERE normalised_name IN ('Husa cu protectie camera pentru Iphone 11 Pro Max Orange Pink','Apple iPhone 7 128 GB Black Foarte bun','Televizor LED Akai LT 3233SM 81 cm Smart TV HD Ready Negru','Ceas RETRO INSPIRED 7334','Subler digital 150Ñ…0.01mm cutie depozitare Topmaster 280301','CEAS BARBATESC MATTEO FERARI MF019','Boxa Portabila Soundlink Revolve II Argintiu','Ghete Dama Imblanite Negre din Piele Ecologica Ruby X7369','Ghete Dama Imblanite Negre din Piele Ecologica Ruby X7369','Acumulator compatibil Acer Aspire One Cloudbook 11 AO1 132Swift 1 SF113 31 P2CPmodel AP16A4K','Bratara Metalica Argintie Otel Inoxidabil 18mm 20mm 22mm 24mm 26mm WZ1501','Cana Fimo decorata cu 2 Fete ce tin o inimioara cadou pentru sora mama prietena YODB21206','Ceas Barbati Michael Kors Layton MK8782','Ceas Barbati Michael Kors Layton MK8782','Galaxy A03s Dual Sim Fizic 64GB LTE 4G Negru 4GB RAM') GROUP BY normalised_name ORDER BY sequence][Table 'webnutr1_pret.pt_products' doesn't exist]