電池屋(smartdenchi.com)
  • ホーム
  • バッテリー
    • 携帯電話のバッテリー
        select UPPER(cs) AS normalized_cs,pcode,category,pid,id,jianjie1,jianjie2,count(*) as num from product where stock='ok' and category like '%battery%' and pcode like '%_Te%' group by normalized_cs order by num desc limit 15