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