$table = <<< __EOS__
            dtb_products AS alldtl
__EOS__;

    $searchCondition['where'] .= ' AND (stock >= 1 OR stock_unlimited = 1)';

SELECT alldtl.product_id
FROM dtb_products AS alldtl
WHERE alldtl.del_flg = 0
AND alldtl.status = 1
AND EXISTS (SELECT *
            FROM dtb_product_categories
            WHERE category_id IN (?,?)
            AND product_id = alldtl.product_id)
AND (stock >= 1 OR stock_unlimited = 1)
GROUP BY alldtl.product_id
ORDER BY ( SELECT T3.rank * 2147483648 + T2.rank
           FROM (SELECT *
                 FROM dtb_product_categories
                 WHERE category_id IN (?,?)) T2
           JOIN dtb_category T3
           ON T2.category_id = T3.category_id
           WHERE T2.product_id = alldtl.product_id
           ORDER BY T3.rank DESC, T2.rank DESC LIMIT 1 )　DESC,product_id DESC

    function findProductIdsOrder(&$objQuery, $arrVal = array()) {
        $table = <<< __EOS__
                 dtb_products AS alldtl
            JOIN dtb_products_class AS T1
              ON alldtl.product_id = T1.product_id
            JOIN dtb_product_categories AS T2
              ON alldtl.product_id = T2.product_id
            JOIN dtb_category
              ON T2.category_id = dtb_category.category_id
__EOS__;

                          ・
                          ・
                          ・

    function findProductCount(&$objQuery, $arrVal = array()) {
        $table = <<< __EOS__
                 dtb_products AS alldtl
            JOIN dtb_products_class AS T1
              ON alldtl.product_id = T1.product_id
            JOIN dtb_product_categories AS T2
              ON alldtl.product_id = T2.product_id
            JOIN dtb_category
              ON T2.category_id = dtb_category.category_id
__EOS__;
        $objQuery->setGroupBy('alldtl.product_id');
        $sql_base = $objQuery->getSql('alldtl.product_id',$table);
        return $objQuery->getOne( "SELECT count(*) FROM ( $sql_base ) as t" , $arrVal);

//      return $objQuery->count($table, '', $arrVal);

        // 分割したキーワードを一つずつwhere文に追加
        foreach ($names as $val) {
            if (strlen($val) > 0) {
                $searchCondition['where']    .= 'AND ( alldtl.name ILIKE ? OR alldtl.comment3 ILIKE ? OR T1.product_code ILIKE ?) ';
                $searchCondition['arrval'][]  = "%$val%";
                $searchCondition['arrval'][]  = "%$val%";
                $searchCondition['arrval'][]  = "%$val%";
            }
        }