Category Listings

1054: Unknown column 'b.membership_id' in 'where clause'
select b.article_id, b.access_type from OMS_AM_article b WHERE b.status='A' AND IF(b.access_type = 'H' , b.membership_id LIKE '%{-1}%' AND /* CASE D */ CASE b.visibilty_type WHEN 'D' THEN IF( (RTRIM( LTRIM( b.visibilty_date ) ) <> '' AND b.visibilty_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= b.visibilty_date , 1 ) AND IF( (RTRIM( LTRIM( b.expiry_date ) ) <> '' AND b.expiry_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) <= b.expiry_date, 1 ) AND IF( b.no_of_downloads >0, b.no_of_view_or_downloads_cnt < b.no_of_downloads, 1 ) /* CASE R */ WHEN 'R' THEN IF(b.visibilty_days > 0 OR b.visible_upto_days > 0, '' <> '' AND IF(b.visibilty_days > 0, DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= DATE_ADD( /* Consider upgrade or regisration date. */ IF(b.flag_regi_upgrade_date = 'R','0000-00-00','0000-00-00') , INTERVAL b.visibilty_days DAY), 1) AND IF(b.visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD( /* Consider upgrade or regisration date. */ IF(b.flag_regi_upgrade_date = 'R','0000-00-00','0000-00-00') , INTERVAL (b.visibilty_days + b.visible_upto_days) DAY),1) AND IF(b.no_of_downloads > 0, b.no_of_view_or_downloads_cnt < b.no_of_downloads,1) , IF(b.no_of_downloads > 0, b.no_of_view_or_downloads_cnt < b.no_of_downloads,1) ) /* CASE '' */ WHEN '' THEN b.membership_id LIKE '%{-1}%' END , 1 ) Category Listings