SELECT k.bmbh, b.spbs, b.isbn, b.tm, k.sm, b.zyz, c.cbsmc, b.cbrq, k.dj, k.jylsj, FUN_GET_KYKC(? ,b.spbs) AS kcs, fun_get_hdzk(b.spbs, ?) discount FROM XHSD_JCD.JCD_PUB_BMKCB k LEFT JOIN XHSD_JCD.BM_JBXXK b ON k.SPBS = b.SPBS LEFT JOIN XHSD_JCD.BM_CBSBMB c ON b.BB = c.BB WHERE k.BMBH = ? AND b.isbn = ?