SELECT count(`keyno`) AS `counter` FROM xoops_ipit_shopping_data WHERE (((`model_list` REGEXP ',(136|137|138|139|140|141|142|143|144|145|146|147|148|149|150|151|152|153|154|155|156|157|158|159|160|161|162|163|164|165|166|167|168|169|170|171|172|173|174|175|176|177|500|508|509|517|519|535),') 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