Friday, 12 March 2010   House Plan Home Home Plan House Plan Custom House Plan Home Plan House Plan Architect House Plan Home Home Plan House Plan Architectural Drafting House Plan Architect Rates and Pricing House Plan books and software Contact Us House Plan Architect Blog Cad Drafting Search Bargain Homes Home Plan Pro Home Builder House Plan Permit Design your own Home Autocad LT Find a Contractor Privacy Policy Avoid Home Builder ripoffs Latest News 41 Shed Plans House Plans Books and Software Greenhouse Plans 14,000 Woodworking Plans Solar & Wind Energy Diy Guide Custom Home Plan House Plan Filter     Order  Title asc Title desc Ordering    Display #  5 10 15 20 25 30 50 Item Title Find a Contractor Home Builder Rates Autocad LT Home Plan Pro Design your own home Plumbing Walls Land considerations in House Planning Door and window sizes Permit Plans Custom Home Plans Ask an Architect Custom House Plan Design Sketch Get a Sketch   << Start < Prev 1 Next > End >> Results 1 - 14 of 14 Custom Home Plan  ( 12 items ) [ Back ]

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT `id`,`link` FROM mos_menu  WHERE ((`name` LIKE '%custom house plan home plan%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM mos_redirection WHERE oldurl LIKE 'custom-house-plan-home-plan/' LIMIT 1
5
UPDATE mos_redirection SET cpt=(cpt+1) WHERE `newurl` LIKE 'index.php?option=com_content&task=category§ionid=1&id=1&Itemid=2'
6
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 2 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM mos_session
 WHERE (
 ( time < '1268357704' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268357704' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM mos_session
 WHERE session_id = '686c04e3de97ab221e01a13b1e5cd468'
9
SELECT session_id
 FROM mos_session
 WHERE session_id = '940ff947b4692164386a0ccbe29f988e'
10
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '940ff947b4692164386a0ccbe29f988e','1268358604','','0','1' )
11
SELECT *
 FROM mos_menu
 WHERE id = 2
12
SELECT *
 FROM mos_categories
 WHERE id = '1'
13
SELECT *
 FROM mos_sections
 WHERE id = '1'
14
SELECT c.*, COUNT( b.id ) AS numitems
 FROM mos_categories AS c
 LEFT JOIN mos_content AS b ON b.catid = c.id 
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2010-03-11 20:50' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2010-03-11 20:50' )
 AND b.access <= 0
 WHERE c.section = '1'
 AND c.published = 1
 AND c.access <= 0
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
15
SELECT COUNT(a.id) as numitems
 FROM mos_content AS a
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.catid = 1
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-03-11 20:50' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-03-11 20:50' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
16
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.catid = 1
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-03-11 20:50' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-03-11 20:50' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 50
17
SELECT title AS category FROM mos_categories WHERE id=1
18
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=category§ionid=1&id=1&Itemid=2'
19
SELECT title_alias FROM mos_content WHERE id=21
20
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=21
21
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=2'
22
SELECT title_alias FROM mos_content WHERE id=20
23
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=20
24
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=20&Itemid=2'
25
SELECT title_alias FROM mos_content WHERE id=19
26
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=19
27
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=19&Itemid=2'
28
SELECT title_alias FROM mos_content WHERE id=18
29
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=18
30
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=18&Itemid=2'
31
SELECT title_alias FROM mos_content WHERE id=17
32
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=17
33
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=17&Itemid=2'
34
SELECT title_alias FROM mos_content WHERE id=16
35
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=16
36
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=16&Itemid=2'
37
SELECT title_alias FROM mos_content WHERE id=15
38
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=15
39
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=15&Itemid=2'
40
SELECT title_alias FROM mos_content WHERE id=14
41
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=14
42
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=14&Itemid=2'
43
SELECT title_alias FROM mos_content WHERE id=13
44
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=13
45
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=13&Itemid=2'
46
SELECT title_alias FROM mos_content WHERE id=12
47
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=12
48
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12&Itemid=2'
49
SELECT title_alias FROM mos_content WHERE id=9
50
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=9
51
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=9&Itemid=2'
52
SELECT title_alias FROM mos_content WHERE id=7
53
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=7
54
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=7&Itemid=2'
55
SELECT title_alias FROM mos_content WHERE id=6
56
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=6
57
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=6&Itemid=2'
58
SELECT title_alias FROM mos_content WHERE id=8
59
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=8
60
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=8&Itemid=2'
61
SELECT title AS category FROM mos_categories WHERE id=28
62
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=category§ionid=1&id=28&Itemid=2'
63
SELECT a.*
 FROM mos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
64
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
65
SELECT title, id
 FROM mos_categories
 WHERE id = 1
 AND access <= 0
66
SELECT title AS section FROM mos_sections WHERE id=1
67
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
68
SELECT id, title, module, position, content, showtitle, params
 FROM mos_modules AS m
 INNER JOIN mos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 2 )
 ORDER BY ordering
69
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
70
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_frontpage'
71
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_frontpage&Itemid=1'
72
SELECT title AS section FROM mos_sections WHERE id=1
73
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
74
SELECT title_alias FROM mos_content WHERE id=4
75
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=4
76
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=4&Itemid=34'
77
SELECT title_alias FROM mos_content WHERE id=22
78
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=22
79
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=22&Itemid=39'
80
SELECT title_alias FROM mos_content WHERE id=19
81
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=19
82
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=19&Itemid=35'
83
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
84
SELECT id
 FROM mos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=40'
85
SELECT title_alias FROM mos_content WHERE id=40
86
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=40
87
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=40&Itemid=58'
88
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_contact'
89
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid=3'
90
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'Other Menu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
91
SELECT title_alias FROM mos_content WHERE id=17
92
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=17
93
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=17&Itemid=32'
94
SELECT title_alias FROM mos_content WHERE id=20
95
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=20
96
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=20&Itemid=36'
97
SELECT title_alias FROM mos_content WHERE id=12
98
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=12
99
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12&Itemid=27'
100
SELECT title_alias FROM mos_content WHERE id=16
101
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=16
102
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=16&Itemid=31'
103
SELECT title_alias FROM mos_content WHERE id=18
104
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=18
105
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=18&Itemid=33'
106
SELECT title_alias FROM mos_content WHERE id=21
107
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=21
108
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=37'
109
SELECT title_alias FROM mos_content WHERE id=31
110
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=31
111
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=31&Itemid=51'
112
SELECT title_alias FROM mos_content WHERE id=32
113
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=32
114
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=32&Itemid=53'
115
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-11 20:50' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 20:50' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
116
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN mos_categories AS c ON i.catid = c.id
 LEFT JOIN mos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 41
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
117
SELECT id 
 FROM mos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
118
SELECT id 
 FROM mos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
119
SELECT title_alias FROM mos_content WHERE id=41
120
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=41
121
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=41&Itemid=2'
122
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN mos_categories AS c ON i.catid = c.id
 LEFT JOIN mos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 40
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
123
SELECT title_alias FROM mos_content WHERE id=40
124
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=40
125
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=40&Itemid=2'
126
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN mos_categories AS c ON i.catid = c.id
 LEFT JOIN mos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 39
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
127
SELECT title_alias FROM mos_content WHERE id=39
128
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=39
129
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=39&Itemid=2'
130
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN mos_categories AS c ON i.catid = c.id
 LEFT JOIN mos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 38
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
131
SELECT title_alias FROM mos_content WHERE id=38
132
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=38
133
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=38&Itemid=2'
134
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN mos_categories AS c ON i.catid = c.id
 LEFT JOIN mos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 37
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
135
SELECT title_alias FROM mos_content WHERE id=37
136
SELECT c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=37
137
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=37&Itemid=2'