商品検索
WordPress データベースエラー: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '< 5001))order by ph.name_kana asc limit 0, 12' at line 10]select sql_calc_found_rows
p.id as id, ph.id as product_history_id,
ph.name as name, ph.product_photo_url as photo_url,
ph.is_mieselection as is_mieselection,
ph.is_miebland as is_miebland
from wp_mie_food_db_product p
inner join wp_mie_food_db_product_history ph on p.id = ph.product_id
where p.is_public = 1
and ph.id = (select max(iph.id) from wp_mie_food_db_product_history iph
where iph.product_id = p.id and iph.status_id = 2) and (ph.name like '%%' or ph.product_features like '%%') and (((ph.sugested_retail_price * (100 + ph.tax_rate * (1 - ph.sugested_retail_price_include_tax)) / 100) > 3000 and < 5001))order by ph.name_kana asc limit 0, 12
検索結果:1件