Top » Catalog » ACCESSORIES » Generators/Water Pumps » Water Pumps » YP30G

  2. Yamaha YP30G Water Pump
    [YP30G]

    Our Price:  $715.00

    And when you really need to move some water, there's the YP30G, with a 171cc engine and three-inch intake that can flow up to 260 gallons of liquid per minute-with a maximum lift of 23 feet and total head of 102 feet. That's serious suction and serious power. Just like the YP20G, the YP30G is loaded with high quality, built to last components and features designed to keep this heavy duty pump going strong for years to come.

    View specs: http://www.yamahamotorsports.com/powerproducts/products/modelspecs/688/0/specs.aspx

    Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'tntgolfc_oscom.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '25055' and opa.orders_id = opb.orders_id and opb.products_id != '25055' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]