SELECT TOP 1 * FROM minutes_ln_vote vote
	

	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.dataSortOrder sort_order, c.misc_alpha2,
		   CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'

			select top 1 * from codes
		

SELECT fas.form_num fas_form_num, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop, fas.routing_apprvl fas_routing_apprvl,
	   fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.final_stop fas_final_stop,
	   fas.date_final fas_date_final, fas.final_prt_date fas_final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id,
	   agt.ag_template_name, agt.ag_template_id, codes.long_descr px_size, codes.descr pdf_format,
	   cv.misc_alpha vote_position, cr.misc_alpha roll_position,
 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo, mt.meeting_type,
 	    ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, am.misc_alpha motion_verbiage, am.misc_alpha3 att_print_nametitle,
	   am.misc_alpha4 att_print_format, am.loc_code att_title_place, am.large_misc_alpha roll_title_place,
	   amm.misc_alpha prt_att_links, amm.misc_alpha3 page_start, amm.text_value1 pdf_header, amm.text_value2 pdf_footer,
	   amm.misc_alpha9 printLine
FROM fas
INNER JOIN MINUTES AS ft ON (ft.form_num = fas.form_num)
INNER JOIN form_hist ON (form_hist.form_id = fas.form_id AND form_hist.stat_action = 'ADD' AND form_hist.form_num = fas.form_num)
INNER JOIN meetings AS m ON (m.meeting_id = ft.meeting_id)
LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = ft.ag_template_id)
LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = ft.text_size)
LEFT OUTER JOIN codes crt ON (crt.code_type = 'AG_FONT' and crt.valid_code = ft.roll_text_size)
LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_JUST' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_JUST' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes ct ON (ct.code_type = 'VOTE_WIDTH' and ct.valid_code = ft.vote_disp_width)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
LEFT OUTER JOIN codes amm ON (amm.code_type = 'AddlMtgMin' and
	amm.valid_code = CAST(ft.meeting_id as varchar))
WHERE fas.form_id = 'MINUTES' AND
	  fas.form_num = ? 

		SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct
		FROM meetings, minutes min
		WHERE meetings.meeting_id = ? AND
		      min.meeting_id = meetings.meeting_id
		

		SELECT descr, long_descr, valid_code from codes WHERE code_type = 'AG_FONT'
	

		SELECT long_descr, descr from getFonts
		WHERE valid_code = 'mediumText'
	

	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 443 

SELECT ml._rowid _rowid, ml.form_num, ml.rev_num, ml.seq_num, ml.motion_text,  
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.page_br,	
	   c.descr as status_desc,

	   ai.box1_label, ai.disp_title, ai.box1_disp, ai.box2_label, ai.box2_disp, ai.box3_label, ai.box3_disp, ai.box4_label,
	   ai.box4_disp, ai.box5_label, ai.box5_disp, ai.box6_label, ai.box6_disp, ai.box7_label, ai.box7_disp,
	   ai.print_time, ai.time_label, ai.ainumber_label, ai.lbl_bold, ai.lbl_underline, ai.lbl_size,
	   ai._rowid as ag_item_rowid,
	   CASE WHEN ml.header_ln = 'Y' THEN 1	
	   		WHEN ml.footer_ln = 'Y' THEN 3
	   		ELSE 2 END AS line_sort,
	   
	   as1.sort_seq sort_level1,
	   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
	   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
	   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
	   
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   am.allow_comment, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, ml.color_impact, ml.left_justify,		
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time,
	   
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action,
	   CASE WHEN ml.ainumber IS NOT NULL THEN ml.ainumber ELSE am.ainumber END as ainumber
FROM minutes_ln ml
LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)

LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = 443 AND ai._rowid = am.ag_item_rowid)

LEFT OUTER JOIN codes AS c ON (c.code_type = 'MIN STATUS' AND c.valid_code = ml.ag_line_status)

LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
WHERE ml.form_num = ?
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo

			
	SELECT *
	FROM getAllLines
	WHERE getAllLines.header_ln = 'N' AND getAllLines.footer_ln = 'N'
	ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo

	select * from getAllLines where header_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4

	select * from getAllLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4

		SELECT *
		FROM getAllLines
		WHERE getAllLines.header_ln = 'Y'
		ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
	

		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid
	FROM minutes_ln ml,
		 minutes_docs docs
	WHERE ml.form_num = 121 AND
		  docs.form_num = ml.form_num AND
		  docs.rev_num = ml.rev_num AND
		  docs.ln_rowid = ml._rowid

	SELECT *
	FROM meeting_minutes
	WHERE form_num = 121 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 

		SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text,
				motion.time_of_vote, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
			   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
			   c.descr status_desc
		FROM minutes_ln_motion motion
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
											  r.rev_num = motion.rev_num AND
											  r.valid_code = motion.motion_id)
		LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
											  r2.rev_num = motion.rev_num AND
											  r2.valid_code = motion.second_id)
		LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = motion.motion_status)
		WHERE motion.form_num = 121 AND
			  motion.rev_num = 0 AND
			  (motion.motion_status IS NULL OR motion.motion_status <> 'VERBIAGE')
		  AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
		ORDER BY motion.ln_rowid, motion.motion_seq
	

		SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote,
			   r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type,
			   c2.misc_alpha3 disp_in_vote,
			   v.seq_num sort1, motion.time_of_vote, m.meeting_id,
			   c3.misc_alpha motion_verbiage, c3.long_descr vote_label,
			   CASE WHEN c2.long_descr = 'Y' THEN 1
			   		WHEN c2.long_descr = 'N' THEN 2
					ELSE 3 END AS sort2
		FROM minutes_ln_vote AS v
		INNER JOIN minutes AS m ON (m.form_num = v.form_num AND
								m.rev_num = v.rev_num)
		INNER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND		
											  r.rev_num = v.rev_num AND
											  r.valid_code = v.valid_code)
		INNER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote AND c2.misc_alpha3 = 'Y')
		LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND
			c3.valid_code = CAST(m.meeting_id AS varchar))
		LEFT OUTER JOIN minutes_ln_motion motion ON
						(motion.form_num = v.form_num AND
					 	 motion.rev_num = v.rev_num AND
					 	 motion.ln_rowid = v.ln_rowid AND
					 	 motion.motion_seq = v.motion_seq AND
					 	(motion.motion_status IS NULL OR motion.motion_status <> 'VERBIAGE')
		 AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
			 )
		WHERE v.form_num = 121 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1						
		

			select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad,
				   c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad,
				   c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad,
				   c.misc_alpha11 mRollSection_pad
			from codes c
			where c.code_type = ? and
			     c.valid_code = CAST(444 as varchar)
		

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3168
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3168 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3168 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3165
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3165 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3165 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3175
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3175 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3175 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3183
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3183 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3183 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3204
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3204 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3204 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 637 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3204 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3204 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3166
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3166 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3166 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2446 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3172
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3172 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3172 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3167
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3167 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3167 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3187
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3187 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3187 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 638 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3187 AND
						      motion_seq = 2 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3187 AND
								  allVotes.motion_seq = 2 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2448 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 639 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3187 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3187 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 672 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3187 AND
						      motion_seq = 5 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3187 AND
								  allVotes.motion_seq = 5 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 673 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3187 AND
						      motion_seq = 6 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3187 AND
								  allVotes.motion_seq = 6 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3188
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3188 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3188 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 642 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3188 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3188 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 643 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3188 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3188 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3189
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3189 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3189 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 644 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3189 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3189 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 645 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3189 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3189 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 646 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3189 AND
						      motion_seq = 5 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3189 AND
								  allVotes.motion_seq = 5 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3190
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3190 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3190 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 647 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3190 AND
						      motion_seq = 1 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3190 AND
								  allVotes.motion_seq = 1 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 648 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3190 AND
						      motion_seq = 2 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3190 AND
								  allVotes.motion_seq = 2 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'N' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2454 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 649 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3190 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3190 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3191
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3191 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3191 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 650 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3191 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3191 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 651 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3191 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3191 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3192
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3192 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3192 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 652 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3192 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3192 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 653 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3192 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3192 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3193
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3193 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3193 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 654 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3193 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3193 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3169
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3169 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3169 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3170
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3170 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3170 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 655 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3170 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3170 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3194
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3194 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3194 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3195
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3195 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3195 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3171
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3171 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3171 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3196
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3196 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3196 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 656 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3196 AND
						      motion_seq = 1 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3196 AND
								  allVotes.motion_seq = 1 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2464 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 657 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3196 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3196 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3197
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3197 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3197 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2466 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 658 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3197 AND
						      motion_seq = 2 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3197 AND
								  allVotes.motion_seq = 2 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2467 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 659 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3197 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3197 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3198
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3198 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3198 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2468 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2469 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 660 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3198 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3198 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 661 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3198 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3198 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2470 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 662 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3198 AND
						      motion_seq = 6 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3198 AND
								  allVotes.motion_seq = 6 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2471 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3199
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3199 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3199 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2472 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 663 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3199 AND
						      motion_seq = 2 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3199 AND
								  allVotes.motion_seq = 2 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2473 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 664 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3199 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3199 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3200
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3200 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3200 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2474 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 665 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3200 AND
						      motion_seq = 2 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3200 AND
								  allVotes.motion_seq = 2 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2475 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 666 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3200 AND
						      motion_seq = 4 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3200 AND
								  allVotes.motion_seq = 4 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3173
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3173 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3173 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3174
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3174 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3174 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3176
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3176 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3176 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3186
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3186 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3186 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2479 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3177
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3177 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3177 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3178
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3178 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3178 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3201
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3201 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3201 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2481 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 667 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3201 AND
						      motion_seq = 2 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3201 AND
								  allVotes.motion_seq = 2 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'N' 

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 668 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3201 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3201 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2482 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3179
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3179 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3179 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3203
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3203 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3203 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2483 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3180
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3180 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3180 

				SELECT * from sortList
				ORDER BY seqNum
			

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3185
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3185 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3185 

				SELECT * from sortList
				ORDER BY seqNum
			

				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 669 

		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 3185 AND
						      motion_seq = 3 

							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 3185 AND
								  allVotes.motion_seq = 3 

	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	

				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3202
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3202 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3202 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2487 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3181
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3181 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3181 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2489 

				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 121 AND
					  rev_num = 0 AND
					  ml_rowid = 3182
				ORDER BY sort_seq, doc_name
			

				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 3182 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			

					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 3182 

				SELECT * from sortList
				ORDER BY seqNum
			

						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 2491 

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=D:\inetpub\PublicPages\public\publish\print_minutes.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFTOKEN=3f3bf3c79e9202c6%2D71C6BA60%2DE3F8%2D24EA%2D717EF833182BA273; CFID=9869869
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=http://cityweb.flagstaffaz.gov/print_minutes.cfm?seq=121&id=&mode=External&reloaded=true
HTTP_URL=/public/publish/print_minutes.cfm?seq=121&id=&mode=External&reloaded=true&CFID=9869869&CFTOKEN=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\public\publish\print_minutes.cfm
QUERY_STRING=seq=121&id=&mode=External&reloaded=true&CFID=9869869&CFTOKEN=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/print_minutes.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=9869869
cftoken=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273
hitcount=71
lastvisit={ts '2024-05-18 04:13:01'}
timecreated={ts '2024-05-18 04:12:45'}
urltoken=CFID=9869869&CFTOKEN=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273

Cookie Variables:
CFID=9869869
CFTOKEN=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273

Session Variables:
ailist=Query (23)
cfid=9869869
cftoken=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9869869_3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273
subdir=/public/
tzoffset=0
urltoken=CFID=9869869&CFTOKEN=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273

URL Parameters:
CFID=9869869
CFTOKEN=3f3bf3c79e9202c6-71C6BA60-E3F8-24EA-717EF833182BA273
id=
mode=External
reloaded=true
seq=121