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 = 80No such file or directory
-
Bicycle helmet Tersus RIDER white dino
480₴Children's bicycle helmet with flasher in the adjusting roller, which increases the safety of the child in the twilight or darkness.
-
Bicycle helmet Tersus RIDER white rainbow
480₴Children's bicycle helmet with flasher in the adjusting roller, which increases the safety of the child in the twilight or darkness.
-
Bicycle helmet Tersus ROCKET matt black-azure-coral
772₴A bicycle helmet with flasher in the adjusting roller, which increases the safety of the cyclist in the twilight or darkness.
-
Bicycle helmet Tersus ROCKET matt dark-blue metallic
772₴A bicycle helmet with flasher in the adjusting roller, which increases the safety of the cyclist in the twilight or darkness
-
Bicycle helmet with visor Tersus ROCKET
859₴A bicycle helmet with flasher in the adjusting roller, which increases the safety of the cyclist in the twilight or darkness.
-
Велосипедный шлем Tersus RACE matt black-graphite
1020₴Велосипедный шлем с мигалкой в регулировочном ролике, которая повышает безопасность велосипедиста в сумерках или темноте