select a.* from prod_table4 a
LEFT JOIN prod_table5 b on (b.tab4_id=a.id)
LEFT JOIN prod_table3 c on (c.id=b.tab3_id)
WHERE (a.brand like '%Rinascimento%') and c.tab2_id<>34 GROUP BY a.id DESC LIMIT 0, 48
Rinascimento – renaissance, rebirth (Italian lang.) - is Italian fashion brand which started to gain shape in 60s when a simple accountant Vittorio Tadei decided to develop a small knitting store in the city of Riccione. Business evolved and in year 1988 a company named Teddy Srl (nowadays known as Teddy group) was founded. Teddy Srl includes several brands: Calliope, Terranova and Rinascimento. With an incredibly fast growing turnover numbers (in year 2013 it was more than 505 million EUR) Teddy group has proved itself as a significant player in the fashion world.
Rinascimento has been running since 70s and since 2001 it has been registered as an international trademark. Its an Italian fashion icon for women who knows what they want and loves being in the spotlight. Every single detail has been crafted to perfection and guarantees that with Rinascimento You will always be noticed! Vast range of clothing – starting from dresses, blouses and skirts up to shoes and accesssories – it all highlights the feminine beauty and creates an aura of a confident personality. Even in brumous weather You can stand out of the crowd with an elegant coat, sweater and dressy pants. With Rinascimento You will always be one of the most fashionable people around because with 8 collections every year this brand is taking a good care to include all the latest fashion trends. More than 5 million women choose Rinascimento.
Extraordinary quality and affordable prices is the lucky combination that opens up the world of Italian fashion for every woman. Yes, for every woman – in year 2002 Rinascimento created a special fashion line for women with more feminine body shapes - Kitano by Rinascimento. You dont have to transform Yourself to fit the fashion world – Rinascimento is taking care that a good style is available for various women. Pep Your day with gorgeous Rinascimento accessories – properly selected scarf, hat or handbag can be a great accent to your image. Skilled designer work is ensuring that clothing will highlight the very best lines of Your body – surprise everyone with well thought out style of Rinascimento!