SELECT count(`keyno`) AS `counter` FROM xoops_ipit_shopping_data WHERE (((`model_list` REGEXP ',(1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31|32|33|34|35|36|37|38|39|40|41|42|43|44|45|46|47|48|49|50|51|52|53|54|55|56|57|58|59|60|61|62|63|64|65|66|67|68|69|70|71|72|73|74|75|76|77|78|79|80|513|515|522|526|527),') 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