Top » Catalog » SPECIALTY VEHICLES » YT2 BEV 2

  2. NEW 2015 Yamaha Fairway Lounge-Deluxe Model
    [YT2 BEV 2]

    Our Price:  $18,299.00

    Available Options:

    Yamaha Built 357F Gasoline Engine

    Filterless Oil System

    4-Wheel Brakes

    Display Case

    Cambro Beverage Dispenser

    Cash Drawer

    Cup Dispenser

    Tortuga Canvas Top

    Upper Display Cases

    Cold Storage Compartment

    Cold Storage Chest Drain

    Low Oil Warning Light

    Low Cost of Ownership

    Maintenance-Free Rack-and-Pinion Steering

    Bumper

    Bucket Seat

    Heavy Duty Suspension

    2" Receiver

    Horn

    Removable Floorboard Access Panel

    Virtually Greaseless Chassis

    Headlights & Tail Lights

    Durable, Easy-To-Clean One-Piece Floor Mat

    Cup Holders

    Easy-Grip Steering Wheel

    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 = '25343' and opa.orders_id = opb.orders_id and opb.products_id != '25343' 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]