Investment Property For Sale

Mosaic
Location: USA, Houston

Latest UK Property News

Stamp duty amnesty

02 Sep 2008 5:04pm

The government has announced a one-year stamp duty holiday on properties bought for £175,000 or less.
Tags: United Kingdom

Sellers kick-start chains

01 Sep 2008 2:21pm

Property owners are taking a new approach to chains in order to secure a vendor or a buyer in the current housing market.
Tags: United Kingdom, Bear Stearns

Latest EU Property News

UK nationals taking 3-day holidays

01 Aug 2008 3:31pm

Many families in the UK are choosing to take holidays of just three or four days, a new study has found.
Tags: Morocco, EU, Sun Investments

Italy tipped to attract investors

27 Jul 2008 8:23pm

Property in Italy could be set to see a renewed surge of interest from foreign buyers
Tags: Italy, EU

Latest US Property News

California Screamin' as prices plunge

03 Aug 2008 10:38am

New figures have revealed that house prices across California plunged in February...
Tags: USA, California, Property Prices, Housing

Rates on 30-year mortgages dip to 5.85%

27 Jul 2008 9:19pm

Rates on 30-year mortgages edged down slightly this week, staying below 6%, although rates on other types of mortgages rose.
Tags: Mortgages, USA, Bear Stearns

Network

Latest Member:

Recent Posts

Buy to Let can't work anymore

By Mark Portman

8th April 2008, 7:50am

I'm confused.

By Roy Webb

31st March 2008, 8:24am

Albania

By Trevor Jones

24th March 2008, 1:16pm

I'll go first then.

By Roy Webb

24th March 2008, 11:14am

Welcome

By Andy Yardley

18th March 2008, 1:05pm

Page Execution: 190.77ms
Peak Memory: 3244 Kb (2.75 MB)

Debug Output


Executed 83 queries in 24.73ms
0.34msSELECT user_id,last_active FROM active_sessions WHERE session_id='f9d873b776f2860d4194fc0488b56b37'
13.77msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('f9d873b776f2860d4194fc0488b56b37','','38.103.63.60',UNIX_TIMESTAMP())
0.14msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('f9d873b776f2860d4194fc0488b56b37','/',UNIX_TIMESTAMP());
0.11msSELECT * FROM top_navigation ORDER BY list_order;
0.09msSELECT COUNT(DISTINCT(c.id)) as RTN FROM content c WHERE active=1 && (c.type=3);
1.38msSELECT * FROM content c WHERE active=1 && (c.type=3) GROUP BY c.id ORDER BY RAND() LIMIT 0,4;
0.06msSELECT id,filename,pri FROM content_image WHERE content_id=385
0.05msSELECT name as RTN FROM content_type WHERE id=3;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=385 && revision_id=1 && content_type_id=3;
0.05msSELECT filename,title FROM content_file WHERE content_id=385
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=385
0.06msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=385
0.05msSELECT id,filename,pri FROM content_image WHERE content_id=515
0.05msSELECT name as RTN FROM content_type WHERE id=3;
0.06msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=515 && revision_id=2 && content_type_id=3;
0.05msSELECT filename,title FROM content_file WHERE content_id=515
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=515
0.06msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=515
0.06msSELECT id,filename,pri FROM content_image WHERE content_id=514
0.05msSELECT name as RTN FROM content_type WHERE id=3;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=514 && revision_id=5 && content_type_id=3;
0.05msSELECT filename,title FROM content_file WHERE content_id=514
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=514
0.06msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=514
0.06msSELECT id,filename,pri FROM content_image WHERE content_id=517
0.05msSELECT name as RTN FROM content_type WHERE id=3;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=517 && revision_id=2 && content_type_id=3;
0.05msSELECT filename,title FROM content_file WHERE content_id=517
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=517
0.06msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=517
0.08msSELECT tag_id,name FROM tag_data WHERE simple_name='uk';
0.05msSELECT COUNT(DISTINCT(c.id)) as RTN FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=180) && (c.type=1);
0.07msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=180) && (c.type=1) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,2;
0.06msSELECT id,filename,pri FROM content_image WHERE content_id=689
0.05msSELECT name as RTN FROM content_type WHERE id=1;
0.06msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=689 && revision_id=1 && content_type_id=1;
0.05msSELECT filename,title FROM content_file WHERE content_id=689
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=689
0.08msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=689
0.06msSELECT id,filename,pri FROM content_image WHERE content_id=699
0.05msSELECT name as RTN FROM content_type WHERE id=1;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=699 && revision_id=1 && content_type_id=1;
0.05msSELECT filename,title FROM content_file WHERE content_id=699
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=699
0.07msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=699
0.07msSELECT tag_id,name FROM tag_data WHERE simple_name='eu';
0.05msSELECT COUNT(DISTINCT(c.id)) as RTN FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=203) && (c.type=1);
0.07msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=203) && (c.type=1) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,2;
0.06msSELECT id,filename,pri FROM content_image WHERE content_id=528
0.05msSELECT name as RTN FROM content_type WHERE id=1;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=528 && revision_id=3 && content_type_id=1;
0.05msSELECT filename,title FROM content_file WHERE content_id=528
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=528
1.18msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=528
0.09msSELECT id,filename,pri FROM content_image WHERE content_id=547
0.05msSELECT name as RTN FROM content_type WHERE id=1;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=547 && revision_id=3 && content_type_id=1;
0.05msSELECT filename,title FROM content_file WHERE content_id=547
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=547
1.21msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=547
0.11msSELECT tag_id,name FROM tag_data WHERE simple_name='usa';
0.05msSELECT COUNT(DISTINCT(c.id)) as RTN FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=182) && (c.type=1);
0.07msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=182) && (c.type=1) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,2;
0.06msSELECT id,filename,pri FROM content_image WHERE content_id=530
0.05msSELECT name as RTN FROM content_type WHERE id=1;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=530 && revision_id=3 && content_type_id=1;
0.05msSELECT filename,title FROM content_file WHERE content_id=530
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=530
0.88msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=530
0.09msSELECT id,filename,pri FROM content_image WHERE content_id=549
0.05msSELECT name as RTN FROM content_type WHERE id=1;
0.07msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=549 && revision_id=3 && content_type_id=1;
0.06msSELECT filename,title FROM content_file WHERE content_id=549
0.06msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=549
1.18msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=549
0.18msSELECT * FROM user WHERE authenticated=1 ORDER BY join_date DESC LIMIT 1;
0.06msSELECT id,first_name,email,dob,gender FROM user WHERE id=41
0.1msSELECT DISTINCT(ft.id),ft.views,ft.subject,fu.first_name as first_name,fu.id as first_user_id,lu.first_name as last_name,lu.id as last_user_id,ffp.timestamp as first_post_time,lfp.timestamp as last_post_time FROM forum_topic ft LEFT JOIN forum_post fp ON (ft.id=fp.topic_id) LEFT JOIN forum_post lfp ON (lfp.id=ft.last_post) LEFT JOIN user lu ON (lu.id=lfp.user_id) LEFT JOIN forum_post ffp ON (ffp.id=ft.first_post) LEFT JOIN user fu ON (fu.id=ffp.user_id) ORDER BY lfp.timestamp DESC LIMIT 6;
0.05msSELECT (COUNT(id)-1) as RTN FROM forum_post WHERE topic_id=5;
0.05msSELECT (COUNT(id)-1) as RTN FROM forum_post WHERE topic_id=6;
0.05msSELECT (COUNT(id)-1) as RTN FROM forum_post WHERE topic_id=4;
0.05msSELECT (COUNT(id)-1) as RTN FROM forum_post WHERE topic_id=3;
0.05msSELECT (COUNT(id)-1) as RTN FROM forum_post WHERE topic_id=2;