SELECT ko.id, ko.status_id, ko.code, ko.linkname, ko.type, ko.age, ko.length, ko.quality_star, ko.price, ko.image, koc.name, koc.linkname as cat_linkname, s.image as status_image, s.alt as status_alt, s.price as status_price, ko.views, ko.sex, ko.birthdate, ko.promo_price, ko.discount_id, ko.is_countdown, ko.countdown_state, ko.countdown_end_price, ko.countdown_price, ko.countdown_step FROM koi_offer ko LEFT JOIN koi_offer_category as koc ON (ko.category_id = koc.id AND koc.language_id = 'nl') LEFT JOIN status as s ON (ko.status_id = s.id AND s.language_id = 'nl') WHERE ko.site_id = '1' AND ko.state > 0 AND (s.name = 'Nieuw' OR s.name = 'Steraanbieding') ORDER BY ko.ordering, ko.id LIMIT 0, 12 Kohaku › Archief › Koi › Interkoi Arendonk: Verkoop en import van hoge kwaliteit Japanse koi/nishikigoi

Kohaku

matsue [804600]

Verkocht
Reference
804600
Type
Kohaku
Breeder
matsue
Kwaliteit
Length
47 cm
Gender
Niet gesext

Verkocht