1054 - Unknown column 'p2c.full_ccode' in 'order clause'

select lb2p.*, p.* from LookBook2Products lb2p left join eProducts p on (lb2p.product_id=p.product_id) where lb2p.lb_id='363' and p.product_visible=1 order by lbp_idx and p2c.full_ccode like 'PLUSTOPPBSP%'

[TEP STOP]