Overige fitness productenTop 5
[
select
products.id,
products.name,
products.description,
products.normalised_name,
products.brand,
products.image_url,
site_merchants.name as merchant,
site_merchants.normalised_name as merchant_normalised_name,
price_new as minPrice,
products.category_id
from products
left join site_merchants on products.merchant_id = site_merchants.id
where
products.normalised_name = 'Giro G10 Overige Groen'
and products.category_id = '281'
order by price_new ASC
limit 0,2][][
select
products.id,
products.name,
products.description,
products.normalised_name,
products.brand,
products.image_url,
site_merchants.name as merchant,
site_merchants.normalised_name as merchant_normalised_name,
price_new as minPrice,
products.category_id
from products
left join site_merchants on products.merchant_id = site_merchants.id
where
products.normalised_name = 'enkelbrace links 272538784'
and products.category_id = '281'
order by price_new ASC
limit 0,2][][
select
products.id,
products.name,
products.description,
products.normalised_name,
products.brand,
products.image_url,
site_merchants.name as merchant,
site_merchants.normalised_name as merchant_normalised_name,
price_new as minPrice,
products.category_id
from products
left join site_merchants on products.merchant_id = site_merchants.id
where
products.normalised_name = 'Molten V5B1500 Ballen Rood'
and products.category_id = '281'
order by price_new ASC
limit 0,2][][
select
products.id,
products.name,
products.description,
products.normalised_name,
products.brand,
products.image_url,
site_merchants.name as merchant,
site_merchants.normalised_name as merchant_normalised_name,
price_new as minPrice,
products.category_id
from products
left join site_merchants on products.merchant_id = site_merchants.id
where
products.normalised_name = 'adidas Performance ACTIVE L Handdoeken Rood'
and products.category_id = '281'
order by price_new ASC
limit 0,2][][
select
products.id,
products.name,
products.description,
products.normalised_name,
products.brand,
products.image_url,
site_merchants.name as merchant,
site_merchants.normalised_name as merchant_normalised_name,
price_new as minPrice,
products.category_id
from products
left join site_merchants on products.merchant_id = site_merchants.id
where
products.normalised_name = 'schijf 1 x 15 kg 422114448'
and products.category_id = '281'
order by price_new ASC
limit 0,2][]