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 '%State of Art%') and c.tab2_id<>34 GROUP BY a.id DESC LIMIT 0, 48
The highest level of development, which is gained in a technical or scientific fields in a certain amount of time. And I can assure, with absolute certainty, that the Dutch clothes company State of Art – well known high-quality childrens and adult clothing manufacturer - fully justifies its name.
Albert Westerman’s and his sister’s family enterprise was founded in 1936. Originally the company produced knitwear for newborns and children, and from 1936 to 1980 there were over 40 million textiles in total, procuded for children. In the middle of the 70s of he 20th century the management fo the family business was taken over by the current company leader Albert Westerman junior, and soon after production of adult clothing begun.
At the moment, the State of Art brand creates 8 new clothing collections each year and considers active lifestyle supporters their target audience. The brand values are based on love for the classics and passion for motorsports. But the brand State of Art has a unique ability to enclothe the classical values into a modern, stylish performance, as well as a truly excellent clothing quality guarantees a constant love and commitement from the purchaser for many years to come.
In addition to the show-room situated in Antwerp, Helsinki, Copenhagen, Lichtenvoorde, Oslo and Stockholm, the company has 28 brand stores and more than 1,000 official dealers all over the world. The newest and current State of Art clothing collection will always be available to you in the clothing store KOKOS - State of Art sweaters, cardigans, jackets, jeans, T -shirts, shirts, jackets, shoes, leather jackets, coats, trousers, shorts, polo-shirts and others.
That way you will have the opportunity to evaluate the excellent quality and the unique style and comfort offered to you by this brand State of Art.