SELECT count(`keyno`) AS `counter` FROM xoops_ipit_shopping_data WHERE (((`model_list` REGEXP ',(81|82|83|84|85|86|87|88|89|90|91|92|93|94|95|96|97|98|99|100|101|102|103|104|105|106|107|108|109|110|111|112|113|114|115|116|117|118|119|120|121|122|123|124|125|126|127|128|129|130|131|132|133|134|135|502|504|511|524),') 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