# 短剧

**Repository Path**: OracleH/drama

## Basic Information

- **Project Name**: 短剧
- **Description**: test测试代码数据
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-06-06
- **Last Updated**: 2025-06-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

	SELECT `drama_order`.`id`,`drama_order`.`user_id`,`drama_order`.`product_id`,`drama_order`.`product_price`,`drama_order`.`rank_id`,`drama_order`.`user_rank`,`drama_order`.`out_trade_no`,`drama_order`.`order_price`,`drama_order`.`order_number`,`drama_order`.`pay_price`,`drama_order`.`pay_time`,`drama_order`.`pay_type`,`drama_order`.`ip`,`drama_order`.`status`,`drama_order`.`remark`,`drama_order`.`createtime`,`drama_order`.`updatetime`,`drama_order`.`deletetime`,`drama_order`.`usemoney`,`drama_order`.`useaward`,`drama_order`.`usescore`,`drama_order`.`usegiftmoney`,`drama_order`.`usedacoin`,`drama_order`.`usedmcoin`,`drama_order`.`last_fhlogid`,`drama_order`.`last_getdate`,`drama_order`.`shuhuitime`,`drama_order`.`version`,`id`,`title`,`image`,`price`,product.id AS product__id,product.category_id AS product__category_id,product.title AS product__title,product.brief AS product__brief,product.image AS product__image,product.images AS product__images,product.desc AS product__desc,product.sales AS product__sales,product.price AS product__price,product.stock AS product__stock,product.no_buy_yet AS product__no_buy_yet,product.rate AS product__rate,product.rate1 AS product__rate1,product.rate2 AS product__rate2,product.bonusway AS product__bonusway,product.bonuswaybase AS product__bonuswaybase,product.bonusrate AS product__bonusrate,product.restrict AS product__restrict,product.look AS product__look,product.real_sales AS product__real_sales,product.real_look AS product__real_look,product.switch AS product__switch,product.weigh AS product__weigh,product.updatetime AS product__updatetime,product.createtime AS product__createtime,product.deletetime AS product__deletetime,product.buy_userids AS product__buy_userids,product.buy_pids AS product__buy_pids,product.buyer AS product__buyer,`number`,`order_id`,orderproduct.id AS orderproduct__id,orderproduct.order_id AS orderproduct__order_id,orderproduct.user_id AS orderproduct__user_id,orderproduct.product_id AS orderproduct__product_id,orderproduct.number AS orderproduct__number,orderproduct.title AS orderproduct__title,orderproduct.image AS orderproduct__image,orderproduct.price AS orderproduct__price,orderproduct.bonusway AS orderproduct__bonusway,orderproduct.bonuswaybase AS orderproduct__bonuswaybase,orderproduct.bonusrate AS orderproduct__bonusrate FROM `fa_drama_order` `drama_order` LEFT JOIN `fa_drama_product` `product` ON `drama_order`.`product_id`=`product`.`id` LEFT JOIN `fa_drama_order_product` `orderproduct` ON `drama_order`.`id`=`orderproduct`.`order_id` WHERE ( `user_id` = 1817759 ) AND `drama_order`.`deletetime` IS NULL ORDER BY `createtime` DESC LIMIT 0,10