TEL : 045-582-0117 MAIL : info@iwasaki0117.co.jp 営業時間 : 10:00 - 18:00 休み : 土日祝日
SELECT count(DISTINCT P.ID) AS co FROM (((wp9f295dposts AS P INNER JOIN wp9f295dterm_relationships AS TR ON P.ID = TR.object_id) INNER JOIN (wp9f295dterms AS T INNER JOIN wp9f295dterm_taxonomy AS TT ON T.term_id = TT.term_id) ON TR.term_taxonomy_id = TT.term_taxonomy_id) INNER JOIN wp9f295dpostmeta AS PM ON P.ID = PM.post_id) WHERE P.post_password='' AND P.post_status='publish' AND T.slug='old_newarrivals' AND TT.taxonomy='bukken' AND PM.meta_key='kakaku'