Submit Product

1054: Unknown column 'b.member_visibilty_date' in 'where clause'
select b.product_id, b.access_type from OMS_PM_product b LEFT JOIN OMS_PM_product_details a on a.product_id = b.product_id WHERE b.status='1' 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, a.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, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1) , IF(b.no_of_downloads > 0, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1) ) /* CASE 'M' */ WHEN 'M' THEN IF((RTRIM(LTRIM(b.member_visibilty_date)) <> '' AND b.member_visibilty_date <> '0000-00-00') ,1,1) AND IF( b.no_of_downloads >0, a.no_of_view_or_downloads_cnt < b.no_of_downloads, 1 ) /* CASE '' */ WHEN '' THEN b.membership_id LIKE '%{-1}%' END , 1 ) 1054: Unknown column 'b.member_visibilty_date' in 'where clause'
select b.product_id, b.access_type from OMS_PM_product b LEFT JOIN OMS_PM_product_details a on a.product_id = b.product_id WHERE b.status='1' 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, a.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, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1) , IF(b.no_of_downloads > 0, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1) ) /* CASE 'M' */ WHEN 'M' THEN IF((RTRIM(LTRIM(b.member_visibilty_date)) <> '' AND b.member_visibilty_date <> '0000-00-00') ,1,1) AND IF( b.no_of_downloads >0, a.no_of_view_or_downloads_cnt < b.no_of_downloads, 1 ) /* CASE '' */ WHEN '' THEN b.membership_id LIKE '%{-1}%' END , 1 ) Submit Product