Аккумуляторы Hoppecke - серия grid | power V M в Красноярске

SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,ak_batarei.`akb_producer`,ak_batarei.`akb_marka`,ak_batarei.`akb_contry`,ak_batarei.`akb_foto`,ak_batarei.`akb_voltage`,ak_batarei.`akb_emkost`,ak_batarei.`akb_weight`,ak_batarei.`akb_height`,ak_batarei.`akb_length`,ak_batarei.`akb_height_clem`,ak_batarei.`akb_cycle`,ak_batarei.`akb_garantia`,ak_batarei.`akb_type_clemm`,ak_batarei.`akb_haracherist`,ak_batarei.`akb_razryad`,ak_batarei.`akb_razryad_5min`,ak_batarei.`akb_razryad_10min`,ak_batarei.`akb_razryad_15min`,ak_batarei.`akb_razryad_30min`,ak_batarei.`akb_razryad_1chas`,ak_batarei.`akb_razryad_3chasa`,ak_batarei.`akb_razryad_5chasov`,ak_batarei.`akb_razryad_8chasov`,ak_batarei.`akb_razryad_10chasov`,ak_batarei.`akb_razryad_20min`,ak_batarei.`akb_razryad_40min`,ak_batarei.`akb_razryad_50min`,ak_batarei.`akb_razryad_25min`,ak_batarei.`akb_razryad_35min`,ak_batarei.`akb_razryad_45min`,ak_batarei.`akb_razryad_55min`,ak_batarei.`akb_razryad_1_5chasa`,ak_batarei.`akb_razryad_2_5chasa`,ak_batarei.`akb_razryad_2chasa`,ak_batarei.`akb_razryad_4chasa`,ak_batarei.`akb_razryad_6chasov`,ak_batarei.`akb_razryad_7chasov`,ak_batarei.`akb_razryad_9chasov`,ak_batarei.`akb_razryad_12chasov`,ak_batarei.`akb_razryad_24chasa`,ak_batarei.`akb_producer_rus`,ak_batarei.`akb_weght`,ak_batarei.`akb_series`,ak_batarei.`akb_type`,ak_batarei.`akb_voltage_10`,ak_batarei.`akb_voltage_5`,ak_batarei.`akb_voltage_1`,ak_batarei.`akb_self_discharge`,ak_batarei.`akb_internal_resistance`,ak_batarei.`akb_old_model`,ak_batarei.`general_akb_emkost`,ak_batarei.`general_akb_max_vih_power`,ak_batarei.`general_akb_work_temperature`,ak_batarei.`akb_voltage_3`,catalog.`h2`,catalog.`close_power`,catalog.`catalog_garanty`,catalog.`general_features`,catalog.`general_applications`,catalog.`general_etc`,catalog.`catalog_short_descr`,catalog.`short_description_autofill`,catalog.`brothers_block_autofill`,catalog.`show_in_yml`,catalog.`id_similar_food` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub, pr.priority as good_priority FROM `tbl_ecommerce_cat_setting` s JOIN `tbl_ecommerce_goods` g ON g.`id` = s.`good` LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`) LEFT JOIN `tbl_good_cat_priority` pr ON (pr.good_id=g.id and pr.cat_id='1405') left join tbl_ecommerce_cat c on (s.cat=c.id and c.rate>0) LEFT JOIN `tbl_ak_batarei_ecommerce_fields` as ak_batarei ON ak_batarei.good_id = g.id LEFT JOIN `tbl_catalog_ecommerce_fields` as catalog ON catalog.good_id = g.id WHERE s.`cat` IN (1405) AND ((g.`status` = 'enable' AND g.`good_off`=0 AND (g.in_archive is null or g.in_archive=0) AND 1=1 AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 )) LIMIT 30