神奇的SQL---天財(cái)商龍

天財(cái)商龍到底是一個什么公司

有些事情真是活久見，做了技術(shù)10年+赚哗，在今年對接天財(cái)商龍她紫，由于需要建立數(shù)倉，問他們要了一些他們目前展示報(bào)表的查詢sql屿储，我貼出來犁苏，大家可能都會覺得簡直是神奇了，我看完直接語無倫次了扩所，十幾個文件，每個文件一條sql朴乖，每個sql最少1500行+祖屏，坐等如何處理助赞。。袁勺。

詳見下雹食，大家覺得這樣的SQL會有多少問題

SELECT SQL_CACHE

workDate,

deliverDate,

rdcCode,

rdcName,

rdcHouseCode,

rdcHouseName,

oppoCode,

oppoName,

oppoHouseCode,

oppoHouseName,

sum(costMoney) AS costMoney,

sum(costMoneyWithTax) AS costMoneyWithTax,

sum(noTaxMoney) AS noTaxMoney,

sum(grossProMoney) AS grossProMoney,

grossProTaxes,

sum(grossProMoneyWithTax) AS grossProMoneyWithTax,

sum(taxMoney) AS taxMoney,

sum(moneyWithTax) AS moneyWithTax,

supplierType,

supplierCode,

supplierName

FROM

(

SELECT

*

FROM

(

SELECT

outbill.workDate,

outbill.deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

rdcHouse.id rdcHouseId,

rdcHouse. CODE rdcHouseCode,

rdcHouse. NAME rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

outBill.costMoney - IFNULL(rtnBill.costMoney, 0) costMoney,

outBill.costMoneyWithTax - IFNULL(rtnBill.costMoneyWithTax, 0) costMoneyWithTax,

outbill.noTaxMoney - IFNULL(rtnBill.noTaxMoney, 0) noTaxMoney,

outbill.mlMoney - IFNULL(rtnBill.mlMoney, 0) grossProMoney,

CONCAT(

CAST(

ROUND(

CASE

WHEN outbill.noTaxMoney - IFNULL(rtnBill.noTaxMoney, 0) = 0 THEN

0

ELSE

(

outbill.mlMoney - IFNULL(rtnBill.mlMoney, 0)

) / (

outbill.noTaxMoney - IFNULL(rtnBill.noTaxMoney, 0)

)

END * 100,

2

) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

outBill.mlMoneyWithTax - IFNULL(rtnBill.mlMoneyWithTax, 0) grossProMoneyWithTax,

outBill.taxMoney - IFNULL(rtnBill.taxMoney, 0) taxMoney,

outbill.moneyWithTax - IFNULL(rtnBill.moneyWithTax, 0) moneyWithTax,

'' supplierType,

'' supplierCode,

'' supplierName,

'' supplierId,

'' supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.shopId rdcId,

sb.otherPartyId,

sb.houseId outHouseId,

sbd.shopHouseId inHouseId,

SUM(sbd.noTaxOutMoney) costMoney,

SUM(sbd.outMoneyWithTax) costMoneyWithTax,

SUM(sbd.sendMoney) noTaxMoney,

SUM(

sbd.sendMoney - sbd.noTaxOutMoney

) mlMoney,

SUM(

sbd.sendMoneyWithTax - sbd.outMoneyWithTax

) mlMoneyWithTax,

SUM(sbd.sendTaxMoney) taxMoney,

SUM(sbd.sendMoneyWithTax) moneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '32'

AND sb.id = sbd.billId

AND sb.billState = 1

AND sb.shopId = '4028874361e1be3b0161e1c0466c0003'

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.shopid,

sb.houseId,

sb.otherPartyId,

sbd.shopHouseId

) outBill

LEFT JOIN jc_shop rdc ON outbill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON outbill.otherPartyId = shop.id

LEFT JOIN jc_house rdcHouse ON outBill.outHouseId = rdcHouse.id

LEFT JOIN jc_house shopHouse ON outBill.inHouseId = shopHouse.id

LEFT JOIN (

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.otherPartyId,

sb.houseId,

sbd.shopHouseId,

SUM(sbd.inMoney) costMoney,

SUM(sbd.inMoneyWithTax) costMoneyWithTax,

SUM(sbd.sendMoney) noTaxMoney,

SUM(sbd.sendMoney - sbd.inMoney) mlMoney,

SUM(

sbd.sendMoneyWithTax - sbd.inMoneyWithTax

) mlMoneyWithTax,

SUM(sbd.sendTaxMoney) taxMoney,

SUM(sbd.sendMoneyWithTax) moneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '35'

AND sb.id = sbd.billId

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

sb.rdcId,

sb.houseId,

sb.otherPartyId,

sbd.shopHouseId

) rtnBill ON outBill.rdcId = rtnBill.rdcId

AND outBill.otherPartyId = rtnBill.otherPartyId

AND outbill.inHouseId = rtnBill.shopHouseId

AND outbill.outHouseId = rtnBill.houseId

UNION ALL

SELECT

inBill.workDate AS workDate,

inBill.deliverDate AS deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

'' rdcHouseId,

'' rdcHouseCode,

'' rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

inBill.costMoney - IFNULL(rtnBIll.costMoney, 0) costMoney,

inBill.costMoneyWithTax - IFNULL(rtnBIll.costMoneyWithTax, 0) costMoneyWithTax,

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0) noTaxMoney,

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0) mlMoney,

CONCAT(

CAST(

ROUND(

CASE

WHEN inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0) = 0 THEN

0

ELSE

(

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0)

) / (

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0)

)

END * 100,

2

) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

inBill.mlMoneyWithTax - IFNULL(rtnBIll.mlMoneyWithTax, 0) mlMoneyWithTax,

inBill.TaxMoney - IFNULL(rtnBIll.taxMoney, 0) taxMoney,

inBill.moneyWithTax - IFNULL(rtnBIll.moneyWithTax, 0) moneyWithTax,

supplier.typeName supplierType,

supplier. CODE supplierCode,

supplier. NAME supplierName,

supplier.id supplierId,

supplier.typeId supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId AS rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId,

sum(sbd.centerCostMoney) costMoney,

sum(sbd.centerCostMoneyWithTax) costMoneyWithTax,

sum(sbd.inMoney) noTaxMoney,

sum(

sbd.inMoney - sbd.centerCostMoney

) mlMoney,

sum(

sbd.inMoneyWithTax - sbd.centerCostMoneyWithTax

) mlMoneyWithTax,

sum(sbd.taxInMoney) taxMoney,

sum(sbd.inMoneyWithTax) moneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '20'

AND sb.stockType = 1

AND sb.billState = 1

AND sb.id = sbd.billId

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.rdcId,

sb.shopId,

sbd.inHouseId,

sb.supplierId

) inBill

LEFT JOIN jc_shop rdc ON inBill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON inBill.shopId = shop.id

LEFT JOIN jc_house shopHouse ON inBill.inHouseId = shopHouse.id

LEFT JOIN (

SELECT

a.id,

a. CODE,

a. NAME,

b. NAME typeName,

b.id typeId

FROM

jc_supplier a,

jc_supplier_type b

WHERE

a.supplierTypeId = b.id

) supplier ON supplier.id = inBill.supplierId

LEFT JOIN (

SELECT

rtn.workDate,

rtn.deliverDate,

rtn.rdcId,

rtn.shopId,

rtn.shopHouseId,

rtn.supplierId,

sum(

(

inb.centerCostMoney / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

) costMoney,

sum(

(

inb.centerCostMoneyWithTax / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

) costMoneyWithTax,

sum(rtn.noTaxOutMoney) noTaxMoney,

sum(

rtn.noTaxOutMoney - (

(

inb.centerCostMoney / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

)

) mlMoney,

sum(

rtn.outMoneyWithTax - (

(

inb.centerCostMoneyWithTax / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

)

) mlMoneyWithTax,

sum(rtn.taxOutMoney) taxMoney,

sum(rtn.outMoneyWithTax) moneyWithTax

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.shopId,

sb.supplierId,

sbd.outHouseId shopHouseId,

sbd.goodsId,

sbd.batchCode,

sbd.mainUnitOutAmount,

sbd.noTaxOutMoney,

sbd.taxOutMoney,

sbd.outMoneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '21'

AND sb.stockType = 1

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

) rtn

LEFT JOIN (

SELECT

sbd.batchCode,

sbd.goodsId,

sbd.mainUnitInAmount,

sbd.centerCostMoney,

sbd.centerCostMoneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '20'

AND sb.stockType = 1

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

) inb ON rtn.batchCode = inb.batchCode

AND rtn.goodsId = inb.goodsId

GROUP BY

rtn.rdcId,

rtn.supplierId,

rtn.shopId,

rtn.shopHouseId

) rtnBIll ON inBill.rdcId = rtnBIll.rdcId

AND inBill.shopId = rtnBIll.shopId

AND inBill.inHouseId = rtnBill.shopHouseId

UNION ALL

SELECT

inbill.workDate,

inbill.deliverDate AS deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

'' rdcHouseId,

'' rdcHouseCode,

'' rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

inBill.costMoney - IFNULL(rtnBIll.costMoney, 0) costMoney,

inBill.costMoneyWithTax - IFNULL(rtnBIll.costMoneyWithTax, 0) costMoneyWithTax,

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0) noTaxMoney,

0 mlMoney,

CONCAT(

CAST(

ROUND(0 * 100, 2) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

0 mlMoneyWithTax,

inBill.TaxMoney - IFNULL(rtnBIll.taxMoney, 0) taxMoney,

inBill.moneyWithTax - IFNULL(rtnBIll.moneyWithTax, 0) moneyWithTax,

supplier.typeName supplierType,

supplier. CODE supplierCode,

supplier. NAME supplierName,

supplier.id supplierId,

supplier.typeId supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId AS rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId,

sum(sbd.inMoney) costMoney,

sum(sbd.inMoneyWithTax) costMoneyWithTax,

sum(sbd.inMoney) noTaxMoney,

sum(sbd.taxInMoney) taxMoney,

sum(sbd.inMoneyWithTax) moneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '42'

AND sb.billState = 1

AND sb.id = sbd.billId

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.otherPartyId,

sb.shopId,

sbd.inHouseId,

sb.supplierId

) inBill

LEFT JOIN jc_shop rdc ON inBill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON inBill.shopId = shop.id

LEFT JOIN jc_house shopHouse ON inBill.inHouseId = shopHouse.id

LEFT JOIN (

SELECT

a.id,

a. CODE,

a. NAME,

b. NAME typeName,

b.id typeId

FROM

jc_supplier a,

jc_supplier_type b

WHERE

a.supplierTypeId = b.id

) supplier ON supplier.id = inBill.supplierId

LEFT JOIN (

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.shopId,

sbd.outHouseId shopHouseId,

sb.supplierId,

sum(sbd.noTaxOutMoney) costMoney,

sum(sbd.outMoneyWithTax) costMoneyWithTax,

sum(sbd.noTaxOutMoney) noTaxMoney,

sum(sbd.taxOutMoney) taxMoney,

sum(sbd.outMoneyWithTax) moneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '43'

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

GROUP BY

sb.rdcId,

sb.supplierId,

sb.shopId,

sbd.outHouseId

) rtnBIll ON inBill.rdcId = rtnBIll.rdcId

AND inBill.shopId = rtnBIll.shopId

AND inBill.inHouseId = rtnBill.shopHouseId

AND inBill.supplierId = rtnBill.supplierId

UNION ALL

SELECT

inBill.workDate,

inBill.deliverDate AS deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

rdcHouse.id rdcHouseId,

rdcHouse. CODE rdcHouseCode,

rdcHouse. NAME rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

inBill.costMoney - IFNULL(rtnBIll.costMoney, 0) costMoney,

inBill.costMoneyWithTax - IFNULL(rtnBIll.costMoneyWithTax, 0) costMoneyWithTax,

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxoutMoney, 0) noTaxMoney,

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0) mlMoney,

CONCAT(

CAST(

ROUND(

CASE

WHEN inBill.noTaxMoney - IFNULL(rtnBIll.noTaxoutMoney, 0) = 0 THEN

0

ELSE

(

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0)

) / (

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxoutMoney, 0)

)

END * 100,

2

) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

inBill.mlMoneyWithTax - IFNULL(rtnBIll.mlMoneyWithTax, 0) mlMoneyWithTax,

inBill.TaxMoney - IFNULL(rtnBIll.taxOutMoney, 0) taxMoney,

inBill.moneyWithTax - IFNULL(rtnBIll.moneyWithTax, 0) moneyWithTax,

supplier.typeName supplierType,

supplier. CODE supplierCode,

supplier. NAME supplierName,

supplier.id supplierId,

supplier.typeId supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId AS rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId shopHouseId,

sbd.shopHouseId rdcHouseId,

sum(sbd.centerCostMoney) costMoney,

sum(sbd.centerCostMoneyWithTax) costMoneyWithTax,

sum(sbd.inMoney) noTaxMoney,

sum(sbd.taxInMoney) taxMoney,

sum(sbd.inMoneyWithTax) moneyWithTax,

sum(

sbd.inMoney - sbd.centerCostMoney

) mlMoney,

sum(

sbd.inMoneyWithTax - sbd.centerCostMoneyWithTax

) mlMoneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '45'

AND sb.billState = 1

AND sb.id = sbd.billId

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId,

sbd.shopHouseId

) inBill

LEFT JOIN jc_shop rdc ON inBill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON inBill.shopId = shop.id

LEFT JOIN jc_house shopHouse ON inBill.shopHouseId = shopHouse.id

LEFT JOIN jc_house rdcHouse ON inBill.rdcHouseId = rdcHouse.id

LEFT JOIN (

SELECT

a.id,

a. CODE,

a. NAME,

b. NAME typeName,

b.id typeId

FROM

jc_supplier a,

jc_supplier_type b

WHERE

a.supplierTypeId = b.id

) supplier ON supplier.id = inBill.supplierId

LEFT JOIN (

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.shopId,

sbd.outHouseId shopHouseId,

sbd.shopHouseId rdcHouseId,

sb.supplierId,

sum(sbd.centerCostMoney) costMoney,

sum(sbd.centerCostMoneyWithTax) costMoneyWithTax,

sum(sbd.noTaxOutMoney) noTaxOutMoney,

sum(sbd.taxOutMoney) taxOutMoney,

sum(sbd.outMoneyWithTax) moneyWithTax,

sum(

sbd.noTaxOutMoney - sbd.centerCostMoney

) mlMoney,

sum(

sbd.outMoneyWithTax - sbd.centerCostMoneyWithTax

) mlMoneyWithTax

FROM

dj_storebill sb,

dj_storebilldetail sbd

WHERE

sb.billType = '48'

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

GROUP BY

sb.rdcId,

sb.supplierId,

sb.shopId,

sbd.outHouseId,

sbd.shopHouseId

) rtnBIll ON inBill.rdcId = rtnBIll.rdcId

AND inBill.shopId = rtnBIll.shopId

AND inBill.shopHouseId = rtnBill.shopHouseId

AND inBill.rdcHouseId = rtnBill.rdcHouseId

AND inBill.supplierId = rtnBill.supplierId

UNION ALL

SELECT

outbill.workDate,

outbill.deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

rdcHouse.id rdcHouseId,

rdcHouse. CODE rdcHouseCode,

rdcHouse. NAME rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

outBill.costMoney - IFNULL(rtnBill.costMoney, 0) costMoney,

outBill.costMoneyWithTax - IFNULL(rtnBill.costMoneyWithTax, 0) costMoneyWithTax,

outbill.noTaxMoney - IFNULL(rtnBill.noTaxMoney, 0) noTaxMoney,

outbill.mlMoney - IFNULL(rtnBill.mlMoney, 0) grossProMoney,

CONCAT(

CAST(

ROUND(

CASE

WHEN outbill.noTaxMoney - IFNULL(rtnBill.noTaxMoney, 0) = 0 THEN

0

ELSE

(

outbill.mlMoney - IFNULL(rtnBill.mlMoney, 0)

) / (

outbill.noTaxMoney - IFNULL(rtnBill.noTaxMoney, 0)

)

END * 100,

2

) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

outBill.mlMoneyWithTax - IFNULL(rtnBill.mlMoneyWithTax, 0) grossProMoneyWithTax,

outBill.taxMoney - IFNULL(rtnBill.taxMoney, 0) taxMoney,

outbill.moneyWithTax - IFNULL(rtnBill.moneyWithTax, 0) moneyWithTax,

'' supplierType,

'' supplierCode,

'' supplierName,

'' supplierId,

'' supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.shopId rdcId,

sb.otherPartyId,

sb.houseId outHouseId,

sbd.shopHouseId inHouseId,

SUM(sbd.noTaxOutMoney) costMoney,

SUM(sbd.outMoneyWithTax) costMoneyWithTax,

SUM(sbd.sendMoney) noTaxMoney,

SUM(

sbd.sendMoney - sbd.noTaxOutMoney

) mlMoney,

SUM(

sbd.sendMoneyWithTax - sbd.outMoneyWithTax

) mlMoneyWithTax,

SUM(sbd.sendTaxMoney) taxMoney,

SUM(sbd.sendMoneyWithTax) moneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '32'

AND sb.id = sbd.billId

AND sb.billState = 1

AND sb.shopId = '4028874361e1be3b0161e1c0466c0003'

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.shopid,

sb.houseId,

sb.otherPartyId,

sbd.shopHouseId

) outBill

LEFT JOIN jc_shop rdc ON outbill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON outbill.otherPartyId = shop.id

LEFT JOIN jc_house rdcHouse ON outBill.outHouseId = rdcHouse.id

LEFT JOIN jc_house shopHouse ON outBill.inHouseId = shopHouse.id

LEFT JOIN (

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.otherPartyId,

sb.houseId,

sbd.shopHouseId,

SUM(sbd.inMoney) costMoney,

SUM(sbd.inMoneyWithTax) costMoneyWithTax,

SUM(sbd.sendMoney) noTaxMoney,

SUM(sbd.sendMoney - sbd.inMoney) mlMoney,

SUM(

sbd.sendMoneyWithTax - sbd.inMoneyWithTax

) mlMoneyWithTax,

SUM(sbd.sendTaxMoney) taxMoney,

SUM(sbd.sendMoneyWithTax) moneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '35'

AND sb.id = sbd.billId

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

sb.rdcId,

sb.houseId,

sb.otherPartyId,

sbd.shopHouseId

) rtnBill ON outBill.rdcId = rtnBill.rdcId

AND outBill.otherPartyId = rtnBill.otherPartyId

AND outbill.inHouseId = rtnBill.shopHouseId

AND outbill.outHouseId = rtnBill.houseId

UNION ALL

SELECT

inBill.workDate AS workDate,

inBill.deliverDate AS deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

'' rdcHouseId,

'' rdcHouseCode,

'' rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

inBill.costMoney - IFNULL(rtnBIll.costMoney, 0) costMoney,

inBill.costMoneyWithTax - IFNULL(rtnBIll.costMoneyWithTax, 0) costMoneyWithTax,

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0) noTaxMoney,

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0) mlMoney,

CONCAT(

CAST(

ROUND(

CASE

WHEN inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0) = 0 THEN

0

ELSE

(

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0)

) / (

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0)

)

END * 100,

2

) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

inBill.mlMoneyWithTax - IFNULL(rtnBIll.mlMoneyWithTax, 0) mlMoneyWithTax,

inBill.TaxMoney - IFNULL(rtnBIll.taxMoney, 0) taxMoney,

inBill.moneyWithTax - IFNULL(rtnBIll.moneyWithTax, 0) moneyWithTax,

supplier.typeName supplierType,

supplier. CODE supplierCode,

supplier. NAME supplierName,

supplier.id supplierId,

supplier.typeId supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId AS rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId,

sum(sbd.centerCostMoney) costMoney,

sum(sbd.centerCostMoneyWithTax) costMoneyWithTax,

sum(sbd.inMoney) noTaxMoney,

sum(

sbd.inMoney - sbd.centerCostMoney

) mlMoney,

sum(

sbd.inMoneyWithTax - sbd.centerCostMoneyWithTax

) mlMoneyWithTax,

sum(sbd.taxInMoney) taxMoney,

sum(sbd.inMoneyWithTax) moneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '20'

AND sb.stockType = 1

AND sb.billState = 1

AND sb.id = sbd.billId

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.rdcId,

sb.shopId,

sbd.inHouseId,

sb.supplierId

) inBill

LEFT JOIN jc_shop rdc ON inBill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON inBill.shopId = shop.id

LEFT JOIN jc_house shopHouse ON inBill.inHouseId = shopHouse.id

LEFT JOIN (

SELECT

a.id,

a. CODE,

a. NAME,

b. NAME typeName,

b.id typeId

FROM

jc_supplier a,

jc_supplier_type b

WHERE

a.supplierTypeId = b.id

) supplier ON supplier.id = inBill.supplierId

LEFT JOIN (

SELECT

rtn.rdcId,

rtn.workDate,

rtn.deliverDate,

rtn.shopId,

rtn.shopHouseId,

rtn.supplierId,

sum(

(

inb.centerCostMoney / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

) costMoney,

sum(

(

inb.centerCostMoneyWithTax / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

) costMoneyWithTax,

sum(rtn.noTaxOutMoney) noTaxMoney,

sum(

rtn.noTaxOutMoney - (

(

inb.centerCostMoney / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

)

) mlMoney,

sum(

rtn.outMoneyWithTax - (

(

inb.centerCostMoneyWithTax / inb.mainUnitInAmount

) * rtn.mainUnitOutAmount

)

) mlMoneyWithTax,

sum(rtn.taxOutMoney) taxMoney,

sum(rtn.outMoneyWithTax) moneyWithTax

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.shopId,

sb.supplierId,

sbd.outHouseId shopHouseId,

sbd.goodsId,

sbd.batchCode,

sbd.mainUnitOutAmount,

sbd.noTaxOutMoney,

sbd.taxOutMoney,

sbd.outMoneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '21'

AND sb.stockType = 1

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

) rtn

LEFT JOIN (

SELECT

sbd.batchCode,

sbd.goodsId,

sbd.mainUnitInAmount,

sbd.centerCostMoney,

sbd.centerCostMoneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '20'

AND sb.stockType = 1

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

) inb ON rtn.batchCode = inb.batchCode

AND rtn.goodsId = inb.goodsId

GROUP BY

rtn.rdcId,

rtn.supplierId,

rtn.shopId,

rtn.shopHouseId

) rtnBIll ON inBill.rdcId = rtnBIll.rdcId

AND inBill.shopId = rtnBIll.shopId

AND inBill.inHouseId = rtnBill.shopHouseId

UNION ALL

SELECT

inbill.workDate,

inbill.deliverDate AS deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

'' rdcHouseId,

'' rdcHouseCode,

'' rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

inBill.costMoney - IFNULL(rtnBIll.costMoney, 0) costMoney,

inBill.costMoneyWithTax - IFNULL(rtnBIll.costMoneyWithTax, 0) costMoneyWithTax,

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxMoney, 0) noTaxMoney,

0 mlMoney,

CONCAT(

CAST(

ROUND(0 * 100, 2) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

0 mlMoneyWithTax,

inBill.TaxMoney - IFNULL(rtnBIll.taxMoney, 0) taxMoney,

inBill.moneyWithTax - IFNULL(rtnBIll.moneyWithTax, 0) moneyWithTax,

supplier.typeName supplierType,

supplier. CODE supplierCode,

supplier. NAME supplierName,

supplier.id supplierId,

supplier.typeId supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId AS rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId,

sum(sbd.inMoney) costMoney,

sum(sbd.inMoneyWithTax) costMoneyWithTax,

sum(sbd.inMoney) noTaxMoney,

sum(sbd.taxInMoney) taxMoney,

sum(sbd.inMoneyWithTax) moneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '42'

AND sb.billState = 1

AND sb.id = sbd.billId

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.otherPartyId,

sb.shopId,

sbd.inHouseId,

sb.supplierId

) inBill

LEFT JOIN jc_shop rdc ON inBill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON inBill.shopId = shop.id

LEFT JOIN jc_house shopHouse ON inBill.inHouseId = shopHouse.id

LEFT JOIN (

SELECT

a.id,

a. CODE,

a. NAME,

b. NAME typeName,

b.id typeId

FROM

jc_supplier a,

jc_supplier_type b

WHERE

a.supplierTypeId = b.id

) supplier ON supplier.id = inBill.supplierId

LEFT JOIN (

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.shopId,

sbd.outHouseId shopHouseId,

sb.supplierId,

sum(sbd.noTaxOutMoney) costMoney,

sum(sbd.outMoneyWithTax) costMoneyWithTax,

sum(sbd.noTaxOutMoney) noTaxMoney,

sum(sbd.taxOutMoney) taxMoney,

sum(sbd.outMoneyWithTax) moneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '43'

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

GROUP BY

sb.rdcId,

sb.supplierId,

sb.shopId,

sbd.outHouseId

) rtnBIll ON inBill.rdcId = rtnBIll.rdcId

AND inBill.shopId = rtnBIll.shopId

AND inBill.inHouseId = rtnBill.shopHouseId

AND inBill.supplierId = rtnBill.supplierId

UNION ALL

SELECT

inBill.workDate,

inBill.deliverDate AS deliverDate,

rdc.id rdcId,

rdc. CODE rdcCode,

rdc. NAME rdcName,

rdcHouse.id rdcHouseId,

rdcHouse. CODE rdcHouseCode,

rdcHouse. NAME rdcHouseName,

shop.id shopId,

shop. CODE oppoCode,

shop. NAME oppoName,

shop.id oppoId,

shopHouse.id shopHouseId,

shopHouse. CODE oppoHouseCode,

shopHouse. NAME oppoHouseName,

inBill.costMoney - IFNULL(rtnBIll.costMoney, 0) costMoney,

inBill.costMoneyWithTax - IFNULL(rtnBIll.costMoneyWithTax, 0) costMoneyWithTax,

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxoutMoney, 0) noTaxMoney,

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0) mlMoney,

CONCAT(

CAST(

ROUND(

CASE

WHEN inBill.noTaxMoney - IFNULL(rtnBIll.noTaxoutMoney, 0) = 0 THEN

0

ELSE

(

inBill.mlMoney - IFNULL(rtnBIll.mlMoney, 0)

) / (

inBill.noTaxMoney - IFNULL(rtnBIll.noTaxoutMoney, 0)

)

END * 100,

2

) AS DECIMAL (13, 4)

) + '',

'%'

) AS grossProTaxes,

inBill.mlMoneyWithTax - IFNULL(rtnBIll.mlMoneyWithTax, 0) mlMoneyWithTax,

inBill.TaxMoney - IFNULL(rtnBIll.taxOutMoney, 0) taxMoney,

inBill.moneyWithTax - IFNULL(rtnBIll.moneyWithTax, 0) moneyWithTax,

supplier.typeName supplierType,

supplier. CODE supplierCode,

supplier. NAME supplierName,

supplier.id supplierId,

supplier.typeId supplierTypeId

FROM

(

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId AS rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId shopHouseId,

sbd.shopHouseId rdcHouseId,

sum(sbd.centerCostMoney) costMoney,

sum(sbd.centerCostMoneyWithTax) costMoneyWithTax,

sum(sbd.inMoney) noTaxMoney,

sum(sbd.taxInMoney) taxMoney,

sum(sbd.inMoneyWithTax) moneyWithTax,

sum(

sbd.inMoney - sbd.centerCostMoney

) mlMoney,

sum(

sbd.inMoneyWithTax - sbd.centerCostMoneyWithTax

) mlMoneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '45'

AND sb.billState = 1

AND sb.id = sbd.billId

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

GROUP BY

DATE_FORMAT(sb.workDate, '%Y-%m-%d'),

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d'),

sb.rdcId,

sb.supplierId,

sb.shopId,

sbd.inHouseId,

sbd.shopHouseId

) inBill

LEFT JOIN jc_shop rdc ON inBill.rdcId = rdc.id

LEFT JOIN jc_shop shop ON inBill.shopId = shop.id

LEFT JOIN jc_house shopHouse ON inBill.shopHouseId = shopHouse.id

LEFT JOIN jc_house rdcHouse ON inBill.rdcHouseId = rdcHouse.id

LEFT JOIN (

SELECT

a.id,

a. CODE,

a. NAME,

b. NAME typeName,

b.id typeId

FROM

jc_supplier a,

jc_supplier_type b

WHERE

a.supplierTypeId = b.id

) supplier ON supplier.id = inBill.supplierId

LEFT JOIN (

SELECT

DATE_FORMAT(sb.workDate, '%Y-%m-%d') AS workDate,

DATE_FORMAT(sb.deliverDate, '%Y-%m-%d') AS deliverDate,

sb.rdcId,

sb.shopId,

sbd.outHouseId shopHouseId,

sbd.shopHouseId rdcHouseId,

sb.supplierId,

sum(sbd.centerCostMoney) costMoney,

sum(sbd.centerCostMoneyWithTax) costMoneyWithTax,

sum(sbd.noTaxOutMoney) noTaxOutMoney,

sum(sbd.taxOutMoney) taxOutMoney,

sum(sbd.outMoneyWithTax) moneyWithTax,

sum(

sbd.noTaxOutMoney - sbd.centerCostMoney

) mlMoney,

sum(

sbd.outMoneyWithTax - sbd.centerCostMoneyWithTax

) mlMoneyWithTax

FROM

dj_storebillHistory sb,

dj_storebilldetailHistory sbd

WHERE

sb.billType = '48'

AND sb.billState = 1

AND sb.workDate <= '2021-02-12 23:59:59'

AND sb.workDate >= '2021-01-19 00:00:00'

AND sb.id = sbd.billId

GROUP BY

sb.rdcId,

sb.supplierId,

sb.shopId,

sbd.outHouseId,

sbd.shopHouseId

) rtnBIll ON inBill.rdcId = rtnBIll.rdcId

AND inBill.shopId = rtnBIll.shopId

AND inBill.shopHouseId = rtnBill.shopHouseId

AND inBill.rdcHouseId = rtnBill.rdcHouseId

AND inBill.supplierId = rtnBill.supplierId

) result

WHERE

1 = 1

) baseTable

WHERE

(

baseTable.rdcId = '4028874361e1be3b0161e1c0466c0003'

)

GROUP BY

workDate,

deliverDate,

rdcCode,

rdcName,

rdcHouseCode,

rdcHouseName,

oppoCode,

oppoName,

oppoHouseCode,

oppoHouseName,

grossProTaxes,

supplierType,

supplierCode,

supplierName

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者

人面猴
序言：七十年代末，一起剝皮案震驚了整個濱河市期丰，隨后出現(xiàn)的幾起案子群叶，更是在濱河造成了極大的恐慌，老刑警劉巖钝荡，帶你破解...
沈念sama閱讀 222,104評論 6贊 515
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件街立，死亡現(xiàn)場離奇詭異，居然都是意外死亡埠通，警方通過查閱死者的電腦和手機(jī)赎离，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 94,816評論 3贊 399
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進(jìn)店門，熙熙樓的掌柜王于貴愁眉苦臉地迎上來端辱，“玉大人梁剔，你說我怎么就攤上這事∥璞危” “怎么了荣病？”我有些...
開封第一講書人閱讀 168,697評論 0贊 360
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵，是天一觀的道長渗柿。經(jīng)常有香客問我个盆，道長，這世上最難降的妖魔是什么做祝？我笑而不...
開封第一講書人閱讀 59,836評論 1贊 298
?港島之戀（遺憾婚禮）
正文為了忘掉前任砾省，我火速辦了婚禮，結(jié)果婚禮上混槐，老公的妹妹穿的比我還像新娘编兄。我一直安慰自己，他們只是感情好声登，可當(dāng)我...
茶點(diǎn)故事閱讀 68,851評論 6贊 397
惡毒庶女頂嫁案：這布局不是一般人想出來的
文/花漫我一把揭開白布狠鸳。她就那樣靜靜地躺著，像睡著了一般悯嗓。火紅的嫁衣襯著肌膚如雪件舵。梳的紋絲不亂的頭發(fā)上，一...
開封第一講書人閱讀 52,441評論 1贊 310
城市分裂傳說
那天脯厨，我揣著相機(jī)與錄音铅祸，去河邊找鬼。笑死，一個胖子當(dāng)著我的面吹牛临梗，可吹牛的內(nèi)容都是我干的涡扼。我是一名探鬼主播，決...
沈念sama閱讀 40,992評論 3贊 421
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開眼盟庞，長吁一口氣：“原來是場噩夢啊……” “哼吃沪！你這毒婦竟也來了？” 一聲冷哼從身側(cè)響起什猖，我...
開封第一講書人閱讀 39,899評論 0贊 276
萬榮殺人案實(shí)錄
序言：老撾萬榮一對情侶失蹤票彪，失蹤者是張志新（化名）和其女友劉穎，沒想到半個月后不狮，有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體降铸，經(jīng)...
沈念sama閱讀 46,457評論 1贊 318
?護(hù)林員之死
正文獨(dú)居荒郊野嶺守林人離奇死亡，尸身上長有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點(diǎn)故事閱讀 38,529評論 3贊 341
?白月光啟示錄
正文我和宋清朗相戀三年荤傲，在試婚紗的時候發(fā)現(xiàn)自己被綠了垮耳。大學(xué)時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
茶點(diǎn)故事閱讀 40,664評論 1贊 352
活死人
序言：一個原本活蹦亂跳的男人離奇死亡遂黍，死狀恐怖终佛，靈堂內(nèi)的尸體忽然破棺而出，到底是詐尸還是另有隱情雾家，我是刑警寧澤铃彰，帶...
沈念sama閱讀 36,346評論 5贊 350
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布，位于F島的核電站芯咧，受9級特大地震影響牙捉，放射性物質(zhì)發(fā)生泄漏。R本人自食惡果不足惜敬飒，卻給世界環(huán)境...
茶點(diǎn)故事閱讀 42,025評論 3贊 334
男人毒藥：我在死后第九天來索命
文/蒙蒙一邪铲、第九天我趴在偏房一處隱蔽的房頂上張望。院中可真熱鬧无拗，春花似錦带到、人聲如沸。這莊子的主人今日做“春日...
開封第一講書人閱讀 32,511評論 0贊 24
一樁弒父案揽惹，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽。三九已至四康，卻和暖如春搪搏，著一層夾襖步出監(jiān)牢的瞬間，已是汗流浹背闪金。一陣腳步聲響...
開封第一講書人閱讀 33,611評論 1贊 272
情欲美人皮
我被黑心中介騙來泰國打工疯溺，沒想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留，地道東北人。一個月前我還...
沈念sama閱讀 49,081評論 3贊 377
代替公主和親
正文我出身青樓囱嫩，卻偏偏與公主長得像嗅辣，于是被迫代替她去往敵國和親。傳聞我的和親對象是個殘疾皇子挠说，可洞房花燭夜當(dāng)晚...
茶點(diǎn)故事閱讀 45,675評論 2贊 359

神奇的SQL---天財(cái)商龍

天財(cái)商龍到底是一個什么公司

詳見下雹食，大家覺得這樣的SQL會有多少問題

推薦閱讀更多精彩內(nèi)容