| 1 |
- SELECT `a`.*,`b`.`type` FROM `eb_store_coupon_user` `a` INNER JOIN `eb_store_coupon` `b` ON `b`.`id`=`a`.`cid` WHERE `a`.`uid` = 9 AND `a`.`is_fail` = 0 AND `a`.`status` = 0 AND `a`.`use_min_price` <= '100.00' AND FIND_IN_SET(, `b`.`category_id`) AND `b`.`type` = 1 ORDER BY `a`.`coupon_price` DESC
|
