오늘 닫기
  • 제로노트
  • 1:1문의
  • 신상품
  • 보조배터리
  • 마스크

[class] /home/byman/inc/dbconn.php
[excute]
질의가 실패하였습니다.

select cate11 as cate1, cate22 as cate2, cate33 as cate3, cate44 as cate4, sum(su) as ea, CAST((select IFNULL(sort, '0') from t_category where cate1=TB.cate11 and cate2=TB.cate22 and cate3=TB.cate33 and cate4=TB.cate44) as SIGNED) as sort from ( select cate1_1 as cate11, cate1_2 as cate22, cate1_3 as cate33, cate1_4 as cate44, count(idx) as su from t_goods where view=1 and status!=4 and cate1 like '11-4-2-%' and cate1_4>0 group by cate1_1, cate1_2, cate1_3, cate1_4 UNION select cate2_1 as cate11, cate2_2 as cate22, cate2_3 as cate33, cate2_4 as cate44, count(idx) as su from t_goods where view=1 and status!=4 and cate2 like '11-4-2-%' and cate2_4>0 group by cate2_1, cate2_2, cate2_3, cate2_4 UNION select cate3_1 as cate11, cate3_2 as cate22, cate3_3 as cate33, cate3_4 as cate44, count(idx) as su from t_goods where view=1 and status!=4 and cate3 like '11-4-2-%' and cate3_4>0 group by cate3_1, cate3_2, cate3_3, cate3_4 UNION select cate4_1 as cate11, cate4_2 as cate22, cate4_3 as cate33, cate4_4 as cate44, count(idx) as su from t_goods where view=1 and status!=4 and cate3 like '11-4-2-%' and cate3_4>0 group by cate4_1, cate4_2, cate4_3, cate4_4 UNION select cate5_1 as cate11, cate5_2 as cate22, cate5_3 as cate33, cate5_4 as cate44, count(idx) as su from t_goods where view=1 and status!=4 and cate5 like '11-4-2-%' and cate5_4>0 group by cate5_1, cate5_2, cate5_3, cate5_4 ) as TB group by cate11, cate22, cate33, cate44 order by sort asc

Subquery returns more than 1 row : 1242