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 ) 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 ) Latest Products Meta Title
SEO SERVICES
SPECIAL REPORTS
SEO Resources
Latest Products
DISCOVER WHY BUSINESSES FEAR SEO
How to Succeed in
Search Engine Marketing where Others fail
Please Provide
Your name & E-mail below:
Name:
E-Mail:
We protect your privacy and would never share or sell your information
TESTIMONIALS
" In addition, great service and technical assistance helped us get our unique aviation chart service off the ground."
American Flyers
more testimonials...
Real Time Web Analytics