468様

ご提示の方法で試してみたところ、商品情報が1件も取得できなかったです。。

SELECT count(DISTINCT d0_.product_id) AS sclr0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.product_id = d1_.product_id INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.category_id AND (d2_.del_flg = 0) INNER JOIN dtb_product_class d3_ ON d0_.product_id = d3_.product_id AND (d3_.del_flg = 0) WHERE (d0_.status = 1 AND d1_.category_id IN (2)) AND (d0_.del_flg = 0) GROUP BY d0_.product_id, d0_.product_control_number, d0_.name, d0_.note, d0_.description_list, d0_.description_detail, d0_.search_word, d0_.free_area, d0_.no_cash_on_delivery, d0_.del_flg, d0_.create_date, d0_.update_date, d0_.creator_id, d0_.status

----------------
EC-CUBE 《プラチナ》ランクパートナー
トエビス株式会社　田中 宏典
EC-CUBEの機能やデザインのカスタマイズ承ります。