beaubikker/indianhorsedatabase.com — Issue #1: code showing on everypage
Author: beaubikker
Created: 2011-12-29 03:41:57+00:00
State: open
Labels: ERROR

below the content on everypage it shows:

(default) 20 queries took 14 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `User`.`id`, `User`.`usertype`, `User`.`firstname`, `User`.`lastname`, `User`.`email_address`, `User`.`image`, `User`.`cropeed_image`, `User`.`password`, `User`.`registered_date`, `User`.`login_stat`, `User`.`expiration_time_periode`, `User`.`membership_exipre_date`, `User`.`payment_option`, `User`.`payment_status`, `User`.`login_counter`, `User`.`website`, `User`.`about_me`, `User`.`facebook_url`, `User`.`town_id`, `User`.`state_id`, `User`.`countryid`, `User`.`logoutdate`, `User`.`edited_date` FROM `tbl_users` AS `User` WHERE `User`.`id` = 91 LIMIT 1	1	1	1
2	SELECT * FROM tbl_stables Stable ,tbl_stablesubscriptions Stablesubscribtion WHERE Stable.status='Y' AND Stable.id=Stablesubscribtion.stable_id AND Stablesubscribtion.user_id=91 AND Stable.edited_date>='2011-12-29'	0	0	0
3	SELECT * FROM tbl_users User ,tbl_usersubscriptions Usersubscription WHERE User.login_stat='Y' AND User.id=Usersubscription.usrid AND Usersubscription.yesstatus='Y' AND Usersubscription.user_id=91 AND User.edited_date>='2011-12-29'	0	0	0
4	SELECT * FROM tbl_horses Horse ,tbl_horsesubscriptions Horsesubscribtion WHERE Horse.approve_stat='Y' AND Horse.id=Horsesubscribtion.horse_id AND Horsesubscribtion.yesstatus='Y' AND Horsesubscribtion.user_id=91 AND Horse.edited_date>='2011-12-29'	0	0	0
5	SELECT * FROM tbl_horses Horse ,tbl_horsesubscriptions Horsesubscribtion WHERE Horse.approve_stat='Y' AND Horse.id=Horsesubscribtion.horse_id AND Horsesubscribtion.user_id=91 AND Horse.posted_date>='2011-12-29' Group By Horse.id	0	0	2
6	SELECT `User`.`id`, `User`.`usertype`, `User`.`firstname`, `User`.`lastname`, `User`.`email_address`, `User`.`image`, `User`.`cropeed_image`, `User`.`password`, `User`.`registered_date`, `User`.`login_stat`, `User`.`expiration_time_periode`, `User`.`membership_exipre_date`, `User`.`payment_option`, `User`.`payment_status`, `User`.`login_counter`, `User`.`website`, `User`.`about_me`, `User`.`facebook_url`, `User`.`town_id`, `User`.`state_id`, `User`.`countryid`, `User`.`logoutdate`, `User`.`edited_date` FROM `tbl_users` AS `User` WHERE `User`.`id` = 91 LIMIT 1	1	1	1
7	SELECT * FROM tbl_horses Horse, tbl_changerequesthorses Changerequest WHERE Horse.id=Changerequest.horse_id AND Changerequest.approve_status='Y' AND Horse.ownerid=91 AND Changerequest.changed_date>='2011-12-29' ORDER BY Changerequest.id DESC	0	0	0
8	SELECT * FROM tbl_horses Horse, tbl_changerequesthorses Changerequest WHERE Horse.id=Changerequest.horse_id AND Changerequest.approve_status='Y' AND Horse.breeder_id=91 AND Changerequest.changed_date>='2011-12-29' ORDER BY Changerequest.id DESC	0	0	1
9	SELECT * FROM tbl_horses Horse, tbl_changerequesthorses Changerequest WHERE Horse.id=Changerequest.horse_id AND Changerequest.approve_status='Y' AND Horse.addedby=91 AND Changerequest.changed_date>='2011-12-29' ORDER BY Changerequest.id DESC	0	0	0
10	SELECT `Notification`.`id`, `Notification`.`user_id`, `Notification`.`posted_date`, `Notification`.`notification_title`, `Notification`.`notificationdetails` FROM `tbl_notifications` AS `Notification` WHERE user_id=91 ORDER BY `id` desc	0	0	0
11	SELECT * FROM tbl_horses Horse, tbl_changerequesthorses Changerequest WHERE Horse.id=Changerequest.horse_id AND Changerequest.approve_status='Y' AND Changerequest.ownerid=91 AND Changerequest.changed_date>='2011-12-29' ORDER BY Changerequest.id DESC	0	0	1
12	SELECT * FROM tbl_horses Horse, tbl_changerequesthorses Changerequest WHERE Horse.id=Changerequest.horse_id AND Changerequest.approve_status='Y' AND Changerequest.breeder_id=91 AND Changerequest.changed_date>='2011-12-29' ORDER BY Changerequest.id DESC	0	0	0
13	SELECT `User`.`id`, `User`.`usertype`, `User`.`firstname`, `User`.`lastname`, `User`.`email_address`, `User`.`image`, `User`.`cropeed_image`, `User`.`password`, `User`.`registered_date`, `User`.`login_stat`, `User`.`expiration_time_periode`, `User`.`membership_exipre_date`, `User`.`payment_option`, `User`.`payment_status`, `User`.`login_counter`, `User`.`website`, `User`.`about_me`, `User`.`facebook_url`, `User`.`town_id`, `User`.`state_id`, `User`.`countryid`, `User`.`logoutdate`, `User`.`edited_date` FROM `tbl_users` AS `User` WHERE `User`.`id` = 91 LIMIT 1	1	1	0
14	SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`headerimage`, `Setting`.`paypal_account_id`, `Setting`.`payment_mode`, `Setting`.`6_months_proce`, `Setting`.`1_year_price`, `Setting`.`1_half_year_price`, `Setting`.`2_year_price`, `Setting`.`6_month_price_rs`, `Setting`.`1_year_price_rs`, `Setting`.`1and_half_year_price_rs`, `Setting`.`2_year_price_price_rs` FROM `tbl_settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1	1	1	0
15	SELECT `User`.`id`, `User`.`usertype`, `User`.`firstname`, `User`.`lastname`, `User`.`email_address`, `User`.`image`, `User`.`cropeed_image`, `User`.`password`, `User`.`registered_date`, `User`.`login_stat`, `User`.`expiration_time_periode`, `User`.`membership_exipre_date`, `User`.`payment_option`, `User`.`payment_status`, `User`.`login_counter`, `User`.`website`, `User`.`about_me`, `User`.`facebook_url`, `User`.`town_id`, `User`.`state_id`, `User`.`countryid`, `User`.`logoutdate`, `User`.`edited_date` FROM `tbl_users` AS `User` WHERE `User`.`id` = 91 LIMIT 1	1	1	1
16	SELECT `User`.`id`, `User`.`usertype`, `User`.`firstname`, `User`.`lastname`, `User`.`email_address`, `User`.`image`, `User`.`cropeed_image`, `User`.`password`, `User`.`registered_date`, `User`.`login_stat`, `User`.`expiration_time_periode`, `User`.`membership_exipre_date`, `User`.`payment_option`, `User`.`payment_status`, `User`.`login_counter`, `User`.`website`, `User`.`about_me`, `User`.`facebook_url`, `User`.`town_id`, `User`.`state_id`, `User`.`countryid`, `User`.`logoutdate`, `User`.`edited_date` FROM `tbl_users` AS `User` WHERE `User`.`id` = 91 LIMIT 1	1	1	0
17	DESCRIBE `tbl_stableimages`	3	3	3
18	DESCRIBE `tbl_stablesubscriptions`	3	3	3
19	SELECT `Stable`.`id`, `Stable`.`userid`, `Stable`.`stable_name`, `Stable`.`stabledesc`, `Stable`.`stable_image`, `Stable`.`posted_date`, `Stable`.`edited_date`, `Stable`.`status`, `Stable`.`website`, `Stable`.`about`, `Stable`.`services`, `Stable`.`town_id`, `Stable`.`state_id`, `Stable`.`country_id` FROM `tbl_stables` AS `Stable` WHERE userid=91	0	0	1
20	SELECT `Advertisement`.`id`, `Advertisement`.`name`, `Advertisement`.`shortdescription`, `Advertisement`.`image`, `Advertisement`.`posted_date`, `Advertisement`.`status`, `Advertisement`.`url`, `Advertisement`.`page` FROM `tbl_advertisements` AS `Advertisement` WHERE status='Y' AND page LIKE '%horse%' ORDER BY RAND() ASC	1	1	0