1146: Table 'register_ktcmsi.CMSI_PM_product_details' doesn't exist select b.product_id, b.access_type from CMSI_PM_product b LEFT JOIN CMSI_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('0000-00-00', INTERVAL b.visibilty_days DAY), 1) AND
IF(b.visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD('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 '' */
WHEN '' THEN b.membership_id LIKE '%{-1}%' END
,
1 )
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/register/public_html/knightstavern/classes/class.procedure.php on line 92
1146: Table 'register_ktcmsi.CMSI_PM_product_details' doesn't exist select b.product_id, b.access_type from CMSI_PM_product b LEFT JOIN CMSI_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('0000-00-00', INTERVAL b.visibilty_days DAY), 1) AND
IF(b.visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD('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 '' */
WHEN '' THEN b.membership_id LIKE '%{-1}%' END
,
1 )
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/register/public_html/knightstavern/classes/class.procedure.php on line 92
1146: Table 'register_ktcmsi.CMSI_PM_product_details' doesn't exist select b.product_id, b.access_type from CMSI_PM_product b LEFT JOIN CMSI_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('0000-00-00', INTERVAL b.visibilty_days DAY), 1) AND
IF(b.visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD('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 '' */
WHEN '' THEN b.membership_id LIKE '%{-1}%' END
,
1 )
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/register/public_html/knightstavern/classes/class.procedure.php on line 92 Knights Tavern - Living History and Reenactment - True Irish Ghost Stories
