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 '%Takeshy Kurosawa%') and c.tab2_id<>34 GROUP BY a.id DESC LIMIT 0, 48
Takeshy Kurosawa is modern Italian fashion brand with rich history. Its beginning can be found in 70s when Giuseppe Langella, senior, talanted tailor, sold jackets he made out of parachutes, left by American soldiers in the mountains of Avellino during the war. Using American version of his name - Joseph Lang - he opened a small store and started to sell jeans. For three generations the family of Langella has been working hard to develop their business of fashion design.
In year 2004, Giuseppe Langella Jr, founded Takeshy Kurosawa brand. While being a big fan of Japanese culture he chose the name of the company to honor two famous Japanese movie directors: Takeshi Kitano and Akiro Kurosawa. At first Takeshy Kurosawa produced clothing for men only, but since year 2009 there are collections created for women as well - pants, shirts, jackets, handbags and fashionable accessories.
Takeshy Kurosawastyle is rebellious, original and functional at the same time - it is a must-have in a wardrobe of every fashion gourmet. Italian design in combination of Japanese fabric treatment technologies allows to create effective and memorable style. The wide selection of clothing provides for every situation - great suits, stylish t-shirts, sweaters, shoes and even warm jackets and coats. But the real calling card of Takeshy Kurosawa are jeans - hand crafted with extraordinary quality and unique design. Almost every collection of Takeshy Kurosawa is limited edition and that makes every fashion product extremely desirable.