Harajuku Lovers - the children's division of L.A.M.B., (Love, Angel, Music, Baby), by Gwen Stefani. Harajuku Lovers is a line of clothing for kids who have "a fatal attraction to cuteness". The collection is heavily influenced by both Stefani's music and modern Japanese culture, particularly the Harajuku district of Tokyo which is the favorite hang out for Japanese artists, fashionistas and hipsters.
1054 - Unknown column 'p.products_id' in 'on clause'
select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id left join products_to_categories p2c on p.products_id = p2c.products_id left join categories c on p2c.categories_id = c.categories_id where c.categories_status = '1' and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '20'