Thursday, 29 July 2010   House Plan Home Home Plan House Plan Custom Home Plan Kitchen and Bath design House Plan Designer House Plan Home Home Plan House Plan Home Plan Drafting Rates and Pricing House Plan books and software Resources Contact Us Cad Drafting Cad Drafting Service 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 Resources 41 Shed Plans House Plans Books and Software Greenhouse Plans 14,000 Woodworking Plans Kitchen and Bath design Kitchen and bathroom additions are the best things you can do to add value to your home, as well as one of the most personally satisfying upgrades that you can do. Let us take your designs and layouts and show you some great alternatives that can give you the best bang for the buck. Elegant kitchen and bath design that will look great for years to come and ensure you get the best resale value when its time to move. Scan and send your sketches and plans to us, I will give you a quote or a maximum not to exceed amount, based on the hourly rate of $25 dollars an hour. Or, take a two hour online consultation for $50 dollars and ask any questions you may have, anything to do with your planning and design ideas. Email me to get started- This e-mail address is being protected from spam bots, you need JavaScript enabled to view it   [ 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 home plan%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM mos_redirection WHERE oldurl LIKE 'custom-home-plan/architectural-advice-and-design.html' LIMIT 1
5
UPDATE mos_redirection SET cpt=(cpt+1) WHERE `newurl` LIKE 'index.php?option=com_content&task=view&id=3&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 < '1280402437' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1280402437' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM mos_session
 WHERE session_id = '2fc35870fdefcf59c7c93d4ccbf0dd6a'
9
SELECT session_id
 FROM mos_session
 WHERE session_id = '5c160199ed72e6a8aa45021d778a5b8e'
10
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '5c160199ed72e6a8aa45021d778a5b8e','1280403337','','0','1' )
11
SELECT *
 FROM mos_menu
 WHERE id = 2
12
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 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.id = 3 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-29 07:35' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-29 07:35' )
 AND a.access <= 0
13
UPDATE mos_content
 SET hits = ( hits + 1 )
 WHERE id = '3'
14
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT params
 FROM mos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
16
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'
17
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
18
SELECT title, catid, id, access
 FROM mos_content
 WHERE id = 3
19
SELECT c.title AS title, s.id AS sectionid, c.id AS id, c.access AS cat_access
 FROM mos_categories AS c
 LEFT JOIN mos_sections AS s
 ON c.section = s.id
 WHERE c.id = 28
 AND c.access <= 0
20
SELECT title AS category FROM mos_categories WHERE id=28
21
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=category§ionid=1&id=28&Itemid=2'
22
SELECT title AS section FROM mos_sections WHERE id=1
23
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
24
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
25
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
26
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_frontpage'
27
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_frontpage&Itemid=1'
28
SELECT title AS section FROM mos_sections WHERE id=1
29
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
30
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
31
SELECT id
 FROM mos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
32
SELECT title_alias FROM mos_content WHERE id=4
33
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
34
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=4&Itemid=34'
35
SELECT title_alias FROM mos_content WHERE id=19
36
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
37
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=19&Itemid=35'
38
SELECT id
 FROM mos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=40'
39
SELECT title_alias FROM mos_content WHERE id=40
40
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
41
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=40&Itemid=58'
42
SELECT title_alias FROM mos_content WHERE id=42
43
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=42
44
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=42&Itemid=60'
45
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_contact'
46
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid=3'
47
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'Other Menu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
48
SELECT title_alias FROM mos_content WHERE id=17
49
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
50
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=17&Itemid=32'
51
SELECT title_alias FROM mos_content WHERE id=20
52
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
53
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=20&Itemid=36'
54
SELECT title_alias FROM mos_content WHERE id=12
55
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
56
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12&Itemid=27'
57
SELECT title_alias FROM mos_content WHERE id=16
58
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
59
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=16&Itemid=31'
60
SELECT title_alias FROM mos_content WHERE id=18
61
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
62
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=18&Itemid=33'
63
SELECT title_alias FROM mos_content WHERE id=21
64
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
65
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=37'
66
SELECT title_alias FROM mos_content WHERE id=31
67
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
68
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=31&Itemid=51'
69
SELECT title_alias FROM mos_content WHERE id=32
70
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
71
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=32&Itemid=53'
72
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-07-29 07:35' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-29 07:35' )
 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
73
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 = 42
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
74
SELECT id 
 FROM mos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
75
SELECT id 
 FROM mos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
76
SELECT title_alias FROM mos_content WHERE id=42
77
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=42
78
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=42&Itemid=2'
79
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
80
SELECT title_alias FROM mos_content WHERE id=41
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=41
82
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=41&Itemid=2'
83
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
84
SELECT title_alias FROM mos_content WHERE id=40
85
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
86
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=40&Itemid=2'
87
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
88
SELECT title_alias FROM mos_content WHERE id=39
89
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
90
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=39&Itemid=2'
91
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
92
SELECT title_alias FROM mos_content WHERE id=38
93
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
94
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=38&Itemid=2'