select wp.prdcode
, wp.prdname
, wp.shortexp
, wp.content
, wp.prdimg_R
, wc.catname
, wc.purl
, wc.catcode
from (select prdcode
, prdname
, shortexp
, content
, prdimg_R
from wiz_product2
where showset != 'N'
and wp.prdcode = ''
order by prior desc
limit 0, 10
) as wp
left join wiz_cprelation2 as wcp
on wp.prdcode = wcp.prdcode
left join wiz_category2 as wc
on wcp.catcode = wc.catcode
and wc.catuse != 'N'
1054 : Unknown column 'wp.prdcode' in 'where clause'