Fishing Tripsselect distinct(main_price_attribute_id) from product_price_attributes where product_id='121' order by npkExpression #1 of ORDER BY clause is not in SELECT list, references column 'web73_db.product_price_attributes.npk' which is not in SELECT list; this is incompatible with DISTINCT
Yate Sofia Fishing - 4 Hours
We are offering the serious big game angler the chance of a lifetime to fish on board the Yate Sofia in the crystal waters of the Atlantic.
Price From € 70.00
Dotsy Fishing - 4 Hours
Try your hand at big game fishing whether you are a beginner or professional with Dotsy Too
RRP Price € 110.00
Price From € 85.00
Yate Sofia Fishing - 7 Hours
We are offering the serious big game angler the chance of a lifetime to fish on board the Yate Sofia in the crystal waters of the Atlantic
Price From € 110.00
Happy Hooker Fishing 4 hours
With a maximum six people on this fishing trip you will have the fishing experience you will never forget!
Price From € 60.00
Genuine Fishing - 4 Hours
If you want a fishing trip which combines trolling and bottom fishing then this is the trip for you.
RRP Price € 59.00
Price From € 55.00
Happy Hooker Fishing Charter 4 hours
How about having the boat to yourselves on this Private fishing charter? The Happy Hooker targets the small fish, and everybody knows there are more small fish than Big Ones!!
RRP Price € 260.00