 |
|
 |
 |
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
| SELECT T.type_name From T1_User.User_company as UC left join T1_User.Company as C using(com_num)left join T1_User.Company_type as T using(type_num) WHERE UC.user_num= |
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND order_type=4' at line 1 |
| SELECT count(*) From T1_Orders.Order WHERE user_num= AND order_type=4 |
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
| SELECT count(*) From T1_Estimate.Estimate WHERE user_num= |
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
| SELECT sum(OP.order_price+OP.order_tprice+OP.order_tvprice+OP.order_commission) From T1_Orders.Order as O, T1_Orders.Order_price as OP WHERE O.order_num=OP.order_num and O.order_type in (4) AND O.user_num= |
| 0원 |
|
|
 |
|
 |
|
 |
|
|
| |
| |
|
|
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY O.order_num DESC LIMIT 3' at line 3 |
SELECT O.order_num, O.wdate, (OP.order_price+OP.order_tprice+OP.order_tvprice+OP.order_commission) as Price From
T1_Orders.Order as O
left join T1_Orders.Order_price as OP using(order_num) WHERE O.user_num= ORDER BY O.order_num DESC LIMIT 3 |
| 주문번호 |
주문일자 |
상품명 |
합계금액 |
주문상태 |
| 주문내역이 없습니다. |
 |
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND CG.goods_pk=G.goods_pk ORDER BY CG.wdate DESC, G.st_index ASC LIMIT 4' at line 7 |
SELECT 1 as K_Sort, GI.goods_num, GI.cate_num, B.brand_num as brd_num, G.goods_pk From
T1_Goods.Goods_info as GI
left join T1_Category.Goods as SC using(cate_num)
left join T1_Goods.Brand as B using(brd_num)
left join T1_Goods.Brand_mother as BM using(brand_num)
left join T1_Goods.Goods as G on GI.goods_num=G.goods_num
left join T1_Goods.Goods_price as GP on G.goods_pk=GP.goods_pk and GP.price_state='Y', T1_Mypage.Concern_goods as CG where GI.goods_num>0 and SC.cate_view='V' and G.goods_view='V' AND CG.user_num= AND CG.goods_pk=G.goods_pk ORDER BY CG.wdate DESC, G.st_index ASC LIMIT 4 |
|
 |
 |
|
| 번호 |
제목 |
상담일자 |
답변 |
|
| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND A1.11_num=A1.11_pnum LIMIT 3' at line 5 |
SELECT
A1.11_num, A1.11_subject, A1.wdate, A2.11_num as CHK From
T1_Customer.1and1 as A1
left join T1_Customer.1and1 as A2 on A1.11_num=A2.11_pnum AND A1.11_num!=A2.11_num
WHERE A1.user_num= AND A1.11_num=A1.11_pnum LIMIT 3 |
| 상담내역이 없습니다. |
|
|
|
[고객 만족센터]