SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?

select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?

SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')

select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC

SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )

SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())

SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

		WHERE		x.competition_number = ?

SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
INNER JOIN ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND getdate() < arc_off_ad_dt

ORDER BY a.arc_on_ad_dt DESC

SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text, arc_on_ad_dt,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages, ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		arc_obc_flag = 1

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()

SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()

SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE a.arc_number IN (select top 4 arc_number
							from		arcs
							WHERE 		arc_obc_flag = 1
							AND			arc_active_flag = 0
							AND 		arc_closed_flag = 1
							AND 		getdate() > arc_off_ad_dt
							ORDER BY	arc_on_ad_dt DESC)
	ORDER BY  	NEWID()

select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?

select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC

select member_message, member_message_number
        from member_messages
        where member_number = ?
        and member_message_active_flag = 1
        and member_message_start_dt <= getdate()
		and member_message_expiry_dt > getdate()

select a.ezine_number, a.ezine_type_number, a.ezine_description, a.ezine_dt, a.ezine_introduction, a.ezine_quote, a.ezine_news, a.ezine_questions_and_answers, b.ezine_type_name, ezine_brief_description, ezine_image
	    from ezines a, ezine_types b
			where a.ezine_type_number = b.ezine_type_number
				and a.ezine_dt < getdate()
				AND a.ezine_active_flag = 1
					order by a.ezine_dt desc

select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?

select 	
			a.ezine_preview_number, 
			a.ezine_preview_jacket_image,
			a.ezine_preview_publish_dt,
			a.ezine_preview_title,
			a.ezine_preview_subtitle,
			a.ezine_preview_jacket_desc,
			a.ezine_preview_author,
			a.ezine_preview_publisher,			
			a.ezine_preview_isbn13,
            a.ezine_preview_number_of_pages,
            a.ezine_preview_rating,
            a.ezine_preview_reading_level,
            a.ezine_preview_firsts_flag,
            a.ezine_preview_bb_link,
            a.ezine_preview_bb_author_link,
            b.ezine_preview_category_name,
            c.review_number
	
	from ezine_previews a
	inner join ezine_preview_categories b  on b.ezine_preview_category_number = a.ezine_preview_category_number
    left join review_allocator c on c.ezine_preview_number = a.ezine_preview_number

	where 	ezine_preview_publish_dt BETWEEN ? and ?
    and		a.ezine_number >= 5
	AND		(select count(*) from editions e where e.book_number = a.ezine_preview_bb_link) < 2
	 
	
		order by newid()

select 	count(*) as "count"
	from 	ezine_previews a
	where 	ezine_preview_publish_dt BETWEEN ? and ?

select 	count(*) as "count"
	from 	ezine_previews a
	inner join ezine_preview_categories b  on b.ezine_preview_category_number = a.ezine_preview_category_number
    left join review_allocator c on c.ezine_preview_number = a.ezine_preview_number

	where 	ezine_preview_publish_dt BETWEEN ? and ?
    and		a.ezine_number >= 5
	AND		(select count(*) from editions e where e.book_number = a.ezine_preview_bb_link) < 2

select 		a.book_number,
			a.book_title,
			b.edition_publisher,	
			b.edition_isbn13,
            b.edition_publish_dt,
            b.edition_number_of_pages,
			c.ezine_preview_author,
			d.ezine_preview_category_name,
			(select cast(AVG(CAST(media_review_rating AS numeric(12,2)))AS decimal(12,0)) from media_reviews where book_number = a.book_number and media_review_type_number <> 7 and media_review_rating > 0) "scritrating"

            

from 		books a
inner join 	editions b on b.book_number = a.book_number
inner join  ezine_previews c on c.ezine_preview_bb_link = a.book_number
inner join	ezine_preview_categories d  on d.ezine_preview_category_number = c.ezine_preview_category_number
	
where 		b.edition_paperback_flag = 1
and 		b.edition_publish_dt >= ?
and			b.edition_publish_dt <?

order by 	d.ezine_preview_category_sortorder ASC, b.edition_publish_dt ASC, c.ezine_preview_title DESC

select member_cc_country
		from members
		where member_number = ?

SELECT 		(select count(*) from arcs where arcs.arc_number NOT IN (select arc_number from arc_allocator) and getdate() > arcs.arc_active_dt) as "available",
	            a.arc_number,a.arc_client_url, a.arc_on_ad_dt,a.arc_active_dt,a.arc_promo_text2, a.arc_ebook_flag, a.arc_allow_free_members_flag,
	            b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author,  b.ezine_preview_publisher, 
	            b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b. ezine_preview_isbn, b.ezine_preview_bb_comments,
	            c.ezine_preview_category_name AS "ezine_preview_category",
	            CASE WHEN (select count(*) from arc_allocator d where d.arc_number = a.arc_number and member_number = ?) >= 1 THEN '1'
	                 ELSE '0'
	            END "requested"
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	INNER JOIN 	ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number
	WHERE 		a.arc_active_flag = 1
	AND			a.arc_obc_flag = ?
	AND 		arc_closed_flag = 0
	ORDER BY  	a.arc_active_dt

SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt,a.arc_off_ad_dt,
                b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
                b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_short_summary,
                b.ezine_preview_bb_author_link,b.ezine_preview_rating,b.ezine_preview_firsts_flag,ezine_preview_bb_link,
                c.ezine_preview_category_name AS "ezine_preview_category",
                (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
                CASE WHEN getdate() < arc_off_ad_dt THEN 1
                ELSE 0
                END "Current",
                (select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
                        (CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
                         WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
                         ELSE 0
                         END)
                    from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "arcrating",
                (select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating",
                (select top 1 arc_allocator_notification_dt from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "arcdate",
                (select top 1 year(arc_allocator_notification_dt) from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "arcyear",
                year(ezine_preview_publish_dt) AS "pubyear"
        
        FROM arcs a
        INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
        INNER JOIN ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number
        
        WHERE 	arc_closed_flag = 1
        AND		a.arc_obc_flag = ?
		AND		year(ezine_preview_publish_dt) > 2005

        
       ORDER BY arc_on_ad_dt
	   			
					ASC

SELECT 		arc_forumidfk
	FROM 		arcs
	WHERE 		bc_active_flag = 1 and arc_forumidfk !='' and arc_forumidfk !='0'

SELECT 		arc_forumidfk
	FROM 		arcs
	WHERE 		bc_active_flag = 0 and arc_forumidfk !='' and arc_forumidfk !='0' and getdate() > arc_on_ad_dt

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, a.arc_active_dt, a.arc_number,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_jacket_image
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_obc_flag = 1
	AND 		getdate() < arc_on_ad_dt
	AND 		a.arc_forumidfk NOT IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )
	ORDER BY  	a.arc_on_ad_dt ASC

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT * FROM get_current ORDER BY arc_on_ad_dt DESC, ezine_preview_title ASC

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT 		a.arc_forumidfk, a.arc_on_ad_dt, 
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_author, b.ezine_preview_short_summary, b.ezine_preview_jacket_image,a.discourse_flag,a.bc_active_flag
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		a.arc_forumidfk = ?

SELECT * FROM get_previous ORDER BY arc_on_ad_dt DESC, ezine_preview_title ASC

select a.book_number, a.rl_book_number, a.reading_list_number, b.reading_list_tag
			from reading_lists a
			left join reading_list_tags b on b.reading_list_number = a.reading_list_number
			where a.member_number = ?
			order by a.reading_list_added_dt DESC

select count(*) as "total"
			from reading_lists

select		book_number, book_title,
						(select count(*) from reading_lists r  WHERE CAST(r.book_number AS VARCHAR) LIKE b.book_number) AS "total"
			from		books b
			 WHERE CAST(book_number AS VARCHAR) IN (	select top 30 CAST(book_number AS VARCHAR)
									from reading_lists c
									where c.rl_book_number IS NULL
									and	datepart(year, c.reading_list_added_dt) > datepart(year, getdate())-4
									group by	c.book_number
									order by count(c.book_number) DESC)
			order by	newid()

SELECT 	*
    FROM 	free_newsletters

SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)

SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0

SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/members/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D4072765%26CFTOKEN%23%3De4221998e1ee69c1%2DFBB75E36%2DBBBD%2D08EB%2D896650070D188925%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2019%3A45%3A58%27%7D%23hitcount%3D8%23timecreated%3D%7Bts%20%272026%2D05%2D31%2019%3A45%3A56%27%7D%23cftoken%3D425f3ed811ecd263%2DFBB75051%2DE0E2%2D2DCE%2DC8006434996FC107%23cfid%3D4072761%23; CFID=4072765; FREEACCESSCOUNT=1; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFTOKEN=e4221998e1ee69c1-FBB75E36-BBBD-08EB-896650070D188925
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=
PATH_TRANSLATED=/root/website/members/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/members/index.cfm
SERVER_NAME=dev.bookbrowse.com
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=
WEB_SERVER_API=

Client Variables:
cfid=4072761
cftoken=425f3ed811ecd263-FBB75051-E0E2-2DCE-C8006434996FC107
hitcount=18
lastvisit={ts '2026-05-31 19:46:02'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 19:45:56'}
urltoken=CFID=4072765&CFTOKEN=e4221998e1ee69c1-FBB75E36-BBBD-08EB-896650070D188925
view=books

Cookie Variables:
CFCLIENT_BOOKBROWSE=order=p#member_number=0#member_active_flag=0#member_logged_in_flag=0#library_user_flag=0#view=books#
CFGLOBALS=urltoken=CFID#=4072765&CFTOKEN#=e4221998e1ee69c1-FBB75E36-BBBD-08EB-896650070D188925#lastvisit={ts '2026-05-31 19:45:58'}#hitcount=8#timecreated={ts '2026-05-31 19:45:56'}#cftoken=425f3ed811ecd263-FBB75051-E0E2-2DCE-C8006434996FC107#cfid=4072761#
CFID=4072765
CFTOKEN=e4221998e1ee69c1-FBB75E36-BBBD-08EB-896650070D188925
FREEACCESSCOUNT=1

Session Variables:
cfid=4072765
cftoken=e4221998e1ee69c1-FBB75E36-BBBD-08EB-896650070D188925
quiz=Struct (4)
quizadmin=0
sessionid=BOOKBROWSE_4072765_e4221998e1ee69c1-FBB75E36-BBBD-08EB-896650070D188925
urltoken=CFID=4072765&CFTOKEN=e4221998e1ee69c1-FBB75E36-BBBD-08EB-896650070D188925