Sản phẩm mới nhất
DB Error 1146 : Table 'denthannew.idv_sell_product_price_cat_36' doesn't exist
Query:
SELECT
id
, catId
, merchantId
, merchantName
, userName
, proName
, proSummary
, price
, quantity
, specialOffer
, proThum
, lastUpdate
, cond
, hasVAT
, warranty
, goldSeller
, hasOffer
, sealMaf
, wholesale
, oath
, warrantyPaper
, returnAccept
, shippingFee
, payThruDT
, rewardPoint
, shipFast
, onlineOnly
, expireTime
, (expireTime - UNIX_TIMESTAMP(NOW()))
FROM (
(
SELECT
sell.id
, sell.catId
, sell.merchantId
, sell.merchantName
, sell.userName
, sell.proName
, sell.proSummary
, light.price
, light.quantity
, sell.specialOffer
, sell.proThum
, light.lastUpdate
, sell.cond
, sell.hasVAT
, sell.warranty
, light.goldSeller
, light.hasOffer
, light.sealMaf
, light.wholesale
, light.oath
, light.warrantyPaper
, light.returnAccept
, light.shippingFee
, light.payThruDT
, light.rewardPoint
, light.shipFast
, light.onlineOnly
, light.expireTime
FROM idv_sell_product_price_cat_36 light, idv_sell_product_cat_36 sell
WHERE sell.id = light.id AND light.id IN (2847773,2847772,2847771,2847770,2847769,2847768,2847767,2847766,2847765,2847764,2847763,2847762,2847761,2847760,2847759,2847758,2847757,2847756,2847755,2847754,2847753,2847752,2847751,2847750,2847749,2847748,2847747,2847746,2847745,2847744,2847743,2847742,2847741,2847740,2847739,2847738,2847737,2847736,2847735,2847734,-1)
)
UNION ALL
(
SELECT
sell.id
, sell.catId
, sell.merchantId
, sell.merchantName
, sell.userName
, sell.proName
, sell.proSummary
, light.price
, light.quantity
, sell.specialOffer
, sell.proThum
, light.lastUpdate
, sell.cond
, sell.hasVAT
, sell.warranty
, light.goldSeller
, light.hasOffer
, light.sealMaf
, light.wholesale
, light.oath
, light.warrantyPaper
, light.returnAccept
, light.shippingFee
, light.payThruDT
, light.rewardPoint
, light.shipFast
, light.onlineOnly
, light.expireTime
FROM idv_sell_product_price_cat_6 light, idv_sell_product_cat_6 sell
WHERE sell.id = light.id AND light.id IN (2847773,2847772,2847771,2847770,2847769,2847768,2847767,2847766,2847765,2847764,2847763,2847762,2847761,2847760,2847759,2847758,2847757,2847756,2847755,2847754,2847753,2847752,2847751,2847750,2847749,2847748,2847747,2847746,2847745,2847744,2847743,2847742,2847741,2847740,2847739,2847738,2847737,2847736,2847735,2847734,-1)
)
UNION ALL
(
SELECT
sell.id
, sell.catId
, sell.merchantId
, sell.merchantName
, sell.userName
, sell.proName
, sell.proSummary
, light.price
, light.quantity
, sell.specialOffer
, sell.proThum
, light.lastUpdate
, sell.cond
, sell.hasVAT
, sell.warranty
, light.goldSeller
, light.hasOffer
, light.sealMaf
, light.wholesale
, light.oath
, light.warrantyPaper
, light.returnAccept
, light.shippingFee
, light.payThruDT
, light.rewardPoint
, light.shipFast
, light.onlineOnly
, light.expireTime
FROM idv_sell_product_price_cat_36 light, idv_sell_product_cat_36 sell
WHERE sell.id = light.id AND light.id IN (2847773,2847772,2847771,2847770,2847769,2847768,2847767,2847766,2847765,2847764,2847763,2847762,2847761,2847760,2847759,2847758,2847757,2847756,2847755,2847754,2847753,2847752,2847751,2847750,2847749,2847748,2847747,2847746,2847745,2847744,2847743,2847742,2847741,2847740,2847739,2847738,2847737,2847736,2847735,2847734,-1)
)
) as light