Saturday, 04 July 2009   House Plan Home Contact Us House Plan Architect House Plan Home Home Plan House Plan Architectural Drafting House Plan Architect House Plans Gallery Custom House Plan Blog Online House Design Links Rates and Pricing House Plans Home Improvements Contact Us 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 Contact Us House Plan Architect Registered Architects 1113 W. 31st Street Austin, Texas 78705 (512)-535-7877 phone (815)-301-5481 fax email: admin@houseplanarchitect.com (877)-706-8724 toll f'ree (512)-553-4527   Send an e-mail to this Contact: Enter your name: E-mail address: Message subject: Enter your message: E-mail a copy of this message to your own address [ 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 '%contact us%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM mos_redirection WHERE oldurl LIKE 'contact-us/' LIMIT 1
5
UPDATE mos_redirection SET cpt=(cpt+1) WHERE `newurl` LIKE 'index.php?option=com_contact&Itemid=3'
6
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 3 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM mos_session
 WHERE (
 ( time < '1246746234' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1246746234' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM mos_menu
 WHERE id = 3
9
SELECT *, COUNT( a.id ) AS numlinks
 FROM mos_categories AS cc
 LEFT JOIN mos_contact_details AS a ON a.catid = cc.id
 WHERE a.published = 1
 AND cc.section = 'com_contact_details'
 AND cc.published = 1
 AND a.access <= 0
 AND cc.access <= 0
 GROUP BY cc.id
 ORDER BY cc.ordering
10
SELECT a.id AS value, CONCAT_WS( ' - ', a.name, a.con_position ) AS text, a.catid, cc.access AS cat_access
 FROM mos_contact_details AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 WHERE a.published = 1
 AND cc.published = 1
 AND a.access <= 0
 ORDER BY a.default_con DESC, a.ordering ASC
11
SELECT a.*, cc.access AS cat_access
 FROM mos_contact_details AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 WHERE a.published = 1
 AND a.id = 1
 AND a.access <= 0
12
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_contact'
13
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid=3'
14
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_contact'
15
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&task=view&contact_id=1&Itemid=3'
16
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_contact'
17
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid=3'
18
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'
19
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
20
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 = 3 )
 ORDER BY ordering
21
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
22
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_frontpage'
23
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_frontpage&Itemid=1'
24
SELECT title AS section FROM mos_sections WHERE id=1
25
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
26
SELECT title_alias FROM mos_content WHERE id=4
27
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
28
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=4&Itemid=34'
29
SELECT title_alias FROM mos_content WHERE id=22
30
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
31
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=22&Itemid=39'
32
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_newsfeeds'
33
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_newsfeeds&Itemid=7'
34
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_gallery'
35
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_gallery&Itemid=44'
36
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_wrapper'
37
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_wrapper&Itemid=45'
38
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_wrapper'
39
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_wrapper&Itemid=8'
40
SELECT title_alias FROM mos_content WHERE id=19
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=19
42
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=19&Itemid=35'
43
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_gallery'
44
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?set_albumName=House-Plans&option=com_gallery&Itemid=44&include=view_album.php'
45
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_wrapper'
46
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_wrapper&Itemid=46'
47
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_contact'
48
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid=3'
49
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'Other Menu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
50
SELECT title_alias FROM mos_content WHERE id=17
51
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
52
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=17&Itemid=32'
53
SELECT title_alias FROM mos_content WHERE id=20
54
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
55
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=20&Itemid=36'
56
SELECT title_alias FROM mos_content WHERE id=12
57
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
58
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12&Itemid=27'
59
SELECT title_alias FROM mos_content WHERE id=16
60
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
61
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=16&Itemid=31'
62
SELECT title_alias FROM mos_content WHERE id=18
63
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
64
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=18&Itemid=33'
65
SELECT title_alias FROM mos_content WHERE id=21
66
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
67
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=37'
68
SELECT title_alias FROM mos_content WHERE id=31
69
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
70
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=31&Itemid=51'
71
SELECT title_alias FROM mos_content WHERE id=32
72
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
73
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=32&Itemid=53'