SELECT count(`keyno`) AS `counter` FROM xoops_ipit_shopping_data WHERE (((`model_list` REGEXP ',(338|339|340|341|342|343|344|345|346|347|348|349|350|351|352|353|354|355|499|537),') AND (((CONCAT( IFNULL(`title`,''),IFNULL(`ys_code`,''),IFNULL(`parts_number`,''),IFNULL(`explanation`,''),IFNULL(`parts_category`,''),IFNULL(`item_name`,''),IFNULL(`maker`,'')) LIKE '%アクスル%') OR (genuine_parts_number LIKE '%(アクスル)%'))))) AND `ys_display`=1