Home Blogs Events Videos Photos Music Groups

SEARCH   | REGISTER | SIGN IN | MY DASHBOARD PEOPLE Members Tributes Testimonies Pets Hobbies ARTS Movies Musicians Theatre Arts Visual Arts EDUCATION Colleges & Universities Home School K-12 Schools KIDS Ages 10-12 Ages 2-4 Ages 5-9 Newborn-2 Teens Youth Groups Youth Missions MEN & WOMEN Careers Finances Health Homemaking Leadership Marriage Parenting Singles MINISTRIES Associations Churches Denominations Humanitarian Aid Missions Prayer RECREATION Hobbies Retreats Sports Summer Camps Travel LIVE CHAT (must be logged in)  • My Photo Albums  • Upload a new Photo Photo: Comedy   Comedy   In This Category     Most Recent Most Viewed Top Rated           Photos Uploaded     Today This Week This Month All Time             Category: Comedy     1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 Hahaha!! Added: 1/25/12 9:15 AM Posted by: seahorse35 Views: 212 1  ratings :} Added: 6/15/11 7:07 PM Posted by: thellama Views: 144 9  ratings Caution Added: 6/3/11 11:17 PM Posted by: drumplusguitar4him Views: 206 23  ratings No, I wasn't really angry . . . . Added: 4/9/11 2:14 PM Posted by: thellama Views: 107 0  ratings Prpl!! xD Added: 10/26/10 10:47 PM Posted by: thellama Views: 128 0  ratings Take my whistle.... Added: 9/18/10 12:39 PM Posted by: seahorse35 Views: 114 1  ratings mi bein stupid Added: 9/15/10 11:28 AM Posted by: jaysonts Views: 61 0  ratings somemore Shadoey things Added: 8/1/10 8:56 PM Posted by: thellama Views: 110 0  ratings who wants a piece of Added: 7/16/10 5:57 PM Posted by: austin97 Views: 107 0  ratings k Added: 4/23/10 2:55 PM Posted by: bolgonon Views: 50 0  ratings

Home   |   Terms of Use   |   Privacy Policy   |   Copyright Notice   |   FAQ   |   Contact   |   Network Status   -  © 2008 - 2009 - gloryLane.com

SELECT id, name_en FROM sn_badwords;


SELECT id FROM sn_usersonline WHERE ip='38.107.179.233' AND login='guest' AND session_id = '6ff3f361a7d3e315a45d95daea69642b';


UPDATE sn_usersonline SET timestamp=1337707174 WHERE ip ='38.107.179.233' AND login='guest' AND session_id = '6ff3f361a7d3e315a45d95daea69642b';


DELETE FROM sn_usersonline WHERE timestamp < 1337699974 AND login='guest' AND session_id = '6ff3f361a7d3e315a45d95daea69642b';


SELECT COUNT(*) guests FROM sn_usersonline WHERE (login ='guest') AND (timestamp > 1337699974);


SELECT COUNT(DISTINCT login) registered FROM sn_usersonline WHERE (login <> 'guest') AND (timestamp>1337699974);


SELECT u_max FROM sn_section_basic WHERE input_name='birth_year' LIMIT 1;


DELETE FROM sn_usersonline WHERE (timestamp < 1337704674);


SELECT id, age, profile_type, profile_id FROM sn_members WHERE birth_day='22' AND birth_month='05' AND birth_year='2012';


SELECT id FROM sn_photos WHERE `status` = 0 AND `timestamp` < 1337703574;


SELECT id FROM sn_videos WHERE `status` = 0 AND `timestamp` < 1337703574;


SELECT * FROM sn_membership_levels LIMIT 1;


	SELECT MAX(bh.order_date) AS order_date, bh.member_id,bh.order_id,m.membership_level,
					bi.quantity,bi.membership_level_id,
					((( bh.order_date+(bi.quantity*60*60*24) )-1337707174)/24/60/60) AS days_remaining
					FROM sn_billing_history bh,
					sn_billing_items bi,
					sn_membership_levels ml,
					sn_members m
					WHERE bh.order_id = bi.id
					AND bi.membership_level_id = ml.id
					AND bh.member_id = m.id
					GROUP BY bh.member_id
					ORDER BY order_date DESC;


	SELECT pages FROM sn_membership_levels
					WHERE name_en = 'non_paying_member';


SELECT id FROM sn_pages
		            			WHERE name = 'profile_search.php';


SELECT id FROM sn_pages
		            			WHERE name = 'billing_confirm.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_my_photos.php';


SELECT id FROM sn_pages
		            			WHERE name = 'edit_survey.php';


SELECT id FROM sn_pages
		            			WHERE name = 'new_message.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_friends.php';


SELECT id FROM sn_pages
		            			WHERE name = 'group_members.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_results.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im_message_logs.php';


SELECT id FROM sn_pages
		            			WHERE name = 'pending_request.php';


SELECT id FROM sn_pages
		            			WHERE name = 'group_invite_history.php';


SELECT id FROM sn_pages
		            			WHERE name = 'video_home_bar.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_view_photos.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_views_handler.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_video_upload2.php';


SELECT id FROM sn_pages
		            			WHERE name = 'event_invite.php';


SELECT id FROM sn_pages
		            			WHERE name = 'blog_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'sent_messages.php';


SELECT id FROM sn_pages
		            			WHERE name = 'create_event.php';


SELECT id FROM sn_pages
		            			WHERE name = 'video_upload.php';


SELECT id FROM sn_pages
		            			WHERE name = 'about_me.php';


SELECT id FROM sn_pages
		            			WHERE name = 'post_bulletin.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_media_favorites.php';


SELECT id FROM sn_pages
		            			WHERE name = 'video_upload1.php';


SELECT id FROM sn_pages
		            			WHERE name = 'add_frnds.php';


SELECT id FROM sn_pages
		            			WHERE name = 'update_username.php';


SELECT id FROM sn_pages
		            			WHERE name = 'bulletin_post_success.php';


SELECT id FROM sn_pages
		            			WHERE name = 'event_image.php';


SELECT id FROM sn_pages
		            			WHERE name = 'messages_trash.php';


SELECT id FROM sn_pages
		            			WHERE name = 'photo_albums.php';


SELECT id FROM sn_pages
		            			WHERE name = 'registration_academy_bulk.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_message.php';


SELECT id FROM sn_pages
		            			WHERE name = 'solo.php';


SELECT id FROM sn_pages
		            			WHERE name = 'top_friends_nw.php';


SELECT id FROM sn_pages
		            			WHERE name = 'edit_video_upload.php';


SELECT id FROM sn_pages
		            			WHERE name = 'account_info.php';


SELECT id FROM sn_pages
		            			WHERE name = 'event_map.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_my_videos.php';


SELECT id FROM sn_pages
		            			WHERE name = 'address_book.php';


SELECT id FROM sn_pages
		            			WHERE name = 'whos_online.php';


SELECT id FROM sn_pages
		            			WHERE name = 'calendar_options.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_video_upload1.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_video_upload3.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_event.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_videos.php';


SELECT id FROM sn_pages
		            			WHERE name = 'photo_upload2.php';


SELECT id FROM sn_pages
		            			WHERE name = 'create_group.php';


SELECT id FROM sn_pages
		            			WHERE name = 'billing_failed.php';


SELECT id FROM sn_pages
		            			WHERE name = 'group_videos.php';


SELECT id FROM sn_pages
		            			WHERE name = 'frnd.php';


SELECT id FROM sn_pages
		            			WHERE name = 'blog_index.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_load_playlist.php';


SELECT id FROM sn_pages
		            			WHERE name = 'own_add_frnds.php';


SELECT id FROM sn_pages
		            			WHERE name = 'my_events.php';


SELECT id FROM sn_pages
		            			WHERE name = 'category_view_photo.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_view_bulletin.php';


SELECT id FROM sn_pages
		            			WHERE name = 'photo_upload.php';


SELECT id FROM sn_pages
		            			WHERE name = 'chat_rooms.php';


SELECT id FROM sn_pages
		            			WHERE name = 'create_profile.php';


SELECT id FROM sn_pages
		            			WHERE name = 'top_friends.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_search.php';


SELECT id FROM sn_pages
		            			WHERE name = 'group_page.php';


SELECT id FROM sn_pages
		            			WHERE name = 'resend_confirmation.php';


SELECT id FROM sn_pages
		            			WHERE name = 'compose_message.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_management.php';


SELECT id FROM sn_pages
		            			WHERE name = 'tag_file.php';


SELECT id FROM sn_pages
		            			WHERE name = 'create_album.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_videos_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'photo_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'edit_event.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_calendar_event.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_survey.php';


SELECT id FROM sn_pages
		            			WHERE name = 'group_events.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_photo_albums.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_join.php';


SELECT id FROM sn_pages
		            			WHERE name = 'films_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_get_songs.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_album.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im_settings.php';


SELECT id FROM sn_pages
		            			WHERE name = 'blog_view.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_calendar.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'event_invite_history.php';


SELECT id FROM sn_pages
		            			WHERE name = 'confirm_member.php';


SELECT id FROM sn_pages
		            			WHERE name = 'main_search.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_profile.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_upload_image.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im_away_message.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_photo_reported.php';


SELECT id FROM sn_pages
		            			WHERE name = 'event_guests.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im_away_message_box.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im_buddy_list_management.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_video_reported.php';


SELECT id FROM sn_pages
		            			WHERE name = 'hidden_profile.php';


SELECT id FROM sn_pages
		            			WHERE name = 'event_rsvp.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im.php';


SELECT id FROM sn_pages
		            			WHERE name = 'photo_upload1.php';


SELECT id FROM sn_pages
		            			WHERE name = 'contact.php';


SELECT id FROM sn_pages
		            			WHERE name = 'registration_complete.php';


SELECT id FROM sn_pages
		            			WHERE name = 'blog_search.php';


SELECT id FROM sn_pages
		            			WHERE name = 'films_search.php';


SELECT id FROM sn_pages
		            			WHERE name = 'blocked_users.php';


SELECT id FROM sn_pages
		            			WHERE name = 'playlist.php';


SELECT id FROM sn_pages
		            			WHERE name = 'edit_profile.php';


SELECT id FROM sn_pages
		            			WHERE name = 'categories_main_photo.php';


SELECT id FROM sn_pages
		            			WHERE name = 'create_calendar_event.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im_buddy_list.php';


SELECT id FROM sn_pages
		            			WHERE name = 'forgot_password.php';


SELECT id FROM sn_pages
		            			WHERE name = 'chat_room_page.php';


SELECT id FROM sn_pages
		            			WHERE name = 'PhotoNotes.php';


SELECT id FROM sn_pages
		            			WHERE name = 'index.php';


SELECT id FROM sn_pages
		            			WHERE name = 'organizations_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'surveys.php';


SELECT id FROM sn_pages
		            			WHERE name = 'im_buddy_window.php';


SELECT id FROM sn_pages
		            			WHERE name = 'chat_create_room.php';


SELECT id FROM sn_pages
		            			WHERE name = 'film_upload1.php';


SELECT id FROM sn_pages
		            			WHERE name = 'add_frnds_next.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_browse.php';


SELECT id FROM sn_pages
		            			WHERE name = 'register.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_invite.php';


SELECT id FROM sn_pages
		            			WHERE name = 'organizations_search.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_directory.php';


SELECT id FROM sn_pages
		            			WHERE name = 'login.php';


SELECT id FROM sn_pages
		            			WHERE name = 'video_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_photo_album.php';


SELECT id FROM sn_pages
		            			WHERE name = 'event_cancel.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_unauthorized.php';


SELECT id FROM sn_pages
		            			WHERE name = 'billing_success.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_photo.php';


SELECT id FROM sn_pages
		            			WHERE name = 'film_upload3.php';


SELECT id FROM sn_pages
		            			WHERE name = 'invite.php';


SELECT id FROM sn_pages
		            			WHERE name = 'group_blogs.php';


SELECT id FROM sn_pages
		            			WHERE name = 'show_invites.php';


SELECT id FROM sn_pages
		            			WHERE name = 'video_upload3.php';


SELECT id FROM sn_pages
		            			WHERE name = 'forgot_password_complete.php';


SELECT id FROM sn_pages
		            			WHERE name = 'categories_main.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'frnds_request.php';


SELECT id FROM sn_pages
		            			WHERE name = 'film_upload2.php';


SELECT id FROM sn_pages
		            			WHERE name = 'billing.php';


SELECT id FROM sn_pages
		            			WHERE name = 'home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'messages_inbox.php';


SELECT id FROM sn_pages
		            			WHERE name = 'calendar_events.php';


SELECT id FROM sn_pages
		            			WHERE name = 'manage_songs.php';


SELECT id FROM sn_pages
		            			WHERE name = 'aboutme.php';


SELECT id FROM sn_pages
		            			WHERE name = 'groups_advanced_search.php';


SELECT id FROM sn_pages
		            			WHERE name = 'join_requests.php';


SELECT id FROM sn_pages
		            			WHERE name = 'faq.php';


SELECT id FROM sn_pages
		            			WHERE name = 'edit_album.php';


SELECT id FROM sn_pages
		            			WHERE name = 'category_view.php';


SELECT id FROM sn_pages
		            			WHERE name = 'profile_search_results.php';


SELECT id FROM sn_pages
		            			WHERE name = 'top_film_makers.php';


SELECT id FROM sn_pages
		            			WHERE name = 'edit_photo_upload.php';


SELECT id FROM sn_pages
		            			WHERE name = 'group_bulletins.php';


SELECT id FROM sn_pages
		            			WHERE name = 'music_top_artists.php';


SELECT id FROM sn_pages
		            			WHERE name = 'organization.php';


SELECT id FROM sn_pages
		            			WHERE name = 'view_video.php';


SELECT id FROM sn_pages
		            			WHERE name = 'blog_edit.php';


SELECT id FROM sn_pages
		            			WHERE name = 'video_upload2.php';


SELECT id FROM sn_pages
		            			WHERE name = 'contact_complete.php';


SELECT id FROM sn_pages
		            			WHERE name = 'already_add_frnds.php';


SELECT id FROM sn_pages
		            			WHERE name = 'events_home.php';


SELECT id FROM sn_pages
		            			WHERE name = 'blank.php';


SELECT id, name FROM sn_pages;


SELECT id, calendar_id, reminder_type FROM sn_calendar_entries WHERE reminder_time>=1337659200
			 AND reminder_time<=1337745599 AND reminder=1;


DELETE FROM sn_mail_message WHERE status = 2;


SELECT name_en,description_en ,image FROM sn_photo_categories where id=1 LIMIT 1;


SELECT * FROM sn_photos WHERE category='1' AND visibility=1 AND approval!=1  ORDER BY timestamp DESC;


SELECT * FROM sn_photos WHERE category='1' AND visibility=1 AND approval!=1  ORDER BY timestamp DESC LIMIT 0, 10;


SELECT label FROM sn_sub_menu_sections;


SELECT * FROM sn_sub_menus WHERE page='Photos' AND access > -2 ORDER BY relative_order ASC;


SELECT input_text, required FROM sn_form_fields WHERE page='category_view_photo';



			SELECT
				c.id,
				CONCAT(
					IFNULL(CONCAT(cgp.name_en, ' / '), ''),
					IFNULL(CONCAT(cp.name_en, ' / '), ''),
					c.name_en
				) extended_name,
				c.name_en name,
				c.name_en,
				(c.num_groups + IFNULL(ccc.num_groups, 0)) num_groups,
				IFNULL(ccc.num_child, 0) num_child,
				c.short_desc, c.long_desc,
				cp.id parent_id,
				cp.name_en parent_name,
				cgp.id grand_parent_id,
				cgp.name_en grand_parent_name
			FROM sn_group_categories c
			LEFT OUTER JOIN (
				SELECT COUNT(*) num_child, MAX(ci.num_groups) + SUM(IFNULL(cci.num_groups, 0)) num_groups, ci.parent_id
				FROM sn_group_categories ci
				LEFT OUTER JOIN sn_group_categories cci ON cci.parent_id = ci.id
				GROUP BY ci.parent_id
			) ccc ON ccc.parent_id = c.id
			LEFT OUTER JOIN sn_group_categories cp ON cp.id = c.parent_id
			LEFT OUTER JOIN sn_group_categories cgp ON cgp.id = cp.parent_id
			WHERE 
			cgp.parent_id IS NULL
			
			AND cgp.id IS NULL
			
			ORDER BY
			COALESCE(cgp.relative_order, cp.relative_order, c.relative_order) ASC,
			COALESCE(cgp.relative_order, cp.relative_order, 0) ASC,
			c.relative_order ASC
			;