IDENTIFICATION
MODEL TYPE 3-4 Passenger
DEALERS Sea-Doo Dealers
WARRANTY 12
INSURANCE
ENGINE:
ENGINE TYPE In-line
CYLINDERS 3
ENGINE STROKE 4-Stroke
DISPLACEMENT (CC/CI) 1630 / 99.4
CARBURETION TYPE Fuel Injected
STEERING:
STEERING ASSIST SYSTEM Yes
TECHNICAL SPECIFICATIONS:
LENGTH (FT) 10.88
WIDTH (IN/MM) 49.2 / 1250
HEIGHT (IN/MM) 44.8 / 1337
DRY WEIGHT (LBS/KG) 739 / 335
FUEL CAPACITY (GAL/L) 15.9 / 60
STORAGE CAPACITY (CUFT/GAL/L) 6.3 / 40.3 / 152.8
SEATS:
NUMBER OF SEATS 3
EXTERIOR:
BODY MATERIAL Polytec™ GEN2
HULL MATERIAL Polytec™ GEN2
HULL TYPE Modified V
SPONSONS Standard
BOARDING STEP Standard
INSTRUMENTATION:
DIGITAL INSTRUMENTATION Standard
DRIVE LINE:
TRIM SYSTEM Standard
CONVENIENCE:
BILGE SYSTEM TYPE Automatic Siphon
STORAGE:
UNDERSEAT STORAGE Standard
GLOVE BOX / DASH STORAGE Standard
FRONT STORAGE WELL Standard
1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'yamaha_motor.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image
from orders_products opa, orders_products opb, orders o, products p
where opa.products_id = '1004'
and opa.orders_id = opb.orders_id
and opb.products_id != '1004'
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]
