Current News
We strive to keep our stock full with shipments from around the world, and we regularly allow customer pre-orders instore. Check out the news section below for the next shipments and the pre-ordering cut-off dates.
1054 - Unknown column 'sf.fish_family_name' in 'field list'
select p.`products_id`, p.`product_name`, p.`products_date_available` as date_expected, sf.`fish_family_name`, sg.`fish_genus_name`, sd.`fish_species_name`, sd.`fish_type_name`, p2c.`categories_id` from `species_description` sd left join `products` p on sd.`products_id` = p.`products_id` left join `scientific_family` sf on sd.`fish_family_id` = sf.`fish_family_id` left join `scientific_genus` sg on sd.`fish_genus_id` = sg.`fish_genus_id` left join `products_to_categories` p2c on sd.`products_id` = p2c.`products_id` where to_days(products_date_available) >= to_days(now()) order by p.`products_date_available`, sf.`fish_family_name`, sg.`fish_genus_name`, sd.`fish_species_name`, sd.`fish_type_name`
[TEP STOP]
select p.`products_id`, p.`product_name`, p.`products_date_available` as date_expected, sf.`fish_family_name`, sg.`fish_genus_name`, sd.`fish_species_name`, sd.`fish_type_name`, p2c.`categories_id` from `species_description` sd left join `products` p on sd.`products_id` = p.`products_id` left join `scientific_family` sf on sd.`fish_family_id` = sf.`fish_family_id` left join `scientific_genus` sg on sd.`fish_genus_id` = sg.`fish_genus_id` left join `products_to_categories` p2c on sd.`products_id` = p2c.`products_id` where to_days(products_date_available) >= to_days(now()) order by p.`products_date_available`, sf.`fish_family_name`, sg.`fish_genus_name`, sd.`fish_species_name`, sd.`fish_type_name`
[TEP STOP]