Helmets
SELECT DISTINCT(tags_terms.slug), tags_terms.name, cats_terms.term_id as cat_id FROM wp_terms as tags_terms, wp_term_taxonomy as tags_taxonomy, wp_posts as tags_posts, wp_term_relationships as tags_relationships, wp_terms as cats_terms, wp_term_taxonomy as cats_taxonomy, wp_posts as cats_posts, wp_term_relationships as cats_relationships WHERE 1 AND tags_terms.term_id = tags_taxonomy.term_id AND tags_taxonomy.taxonomy = "product_tag" AND tags_posts.ID = tags_relationships.object_id AND tags_relationships.term_taxonomy_id = tags_taxonomy.term_id AND cats_terms.term_id = cats_taxonomy.term_id AND cats_taxonomy.taxonomy = "product_cat" AND cats_posts.ID = cats_relationships.object_id AND cats_relationships.term_taxonomy_id = cats_taxonomy.term_id AND cats_posts.ID = tags_posts.ID AND cats_posts.post_status = "publish" AND cats_terms.term_id = 79No such file or directory
-
Helmet Polisport BABY
-
Helmet Polisport BLACK THUNDER
-
Helmet Polisport BLAST
-
Helmet Polisport GUPPY XS
-
Helmet Polisport GUPPY XXS
-
Helmet Polisport IRIS
-
Helmet Polisport JUNIOR P3
-
Helmet Polisport KIDS
-
Helmet Polisport MYTH
(Русский)
Polisport производит велосипедные шлемы для всех стилей и направлений – детские, взрослые шлемы, для города и MTB, Downhill.