Аккумуляторы для MAZDA MX-5 1998-2005

Array ( [q] => akkumulyator-dlya/mazda/mx-5/1998-2005/ [mark_alias] => mazda [model_alias] => mx-5 [model_id] => 15495 [year_id] => 34429 [from] => 1998 [to] => 2005 )

1

YEARSELECT suit_polarity,efb_only FROM modx_akb_auto_model m WHERE m.id = 15495Array ( [suit_polarity] => r [efb_only] => 0 ) 1SELECT suit_capacity,REPLACE(suit_dimensions,'x','х') AS suit_dimensions,efb_only FROM modx_akb_auto_years y WHERE y.id = 34429Array ( [suit_capacity] => 50-70 [suit_dimensions] => 231х171х220||231х172х220||258х172х220||207х175х175 [efb_only] => 0 ) 1EMPTY SELECT u.*, v.name AS vendor_name FROM (SELECT * FROM modx_akb_accum_model a WHERE TRIM(REPLACE(a.dim,'x','х')) IN ('231х171х220','231х172х220','258х172х220','207х175х175') AND a.capacity >= 50 AND a.capacity <=70 AND LOWER(a.polarity) = 'обратная') u LEFT JOIN modx_akb_accum_company v ON u.accum_vendor_id = v.id ORDER BY vendor_name ASC