Thursday, 29 July 2010   House Plan Home 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 Architectural Services Architectural Services including house plan drafting, cad drafting, and cad conversion services. Feed Name # Articles Feed Link Cad Conversion service cad drafting 1 http://www.houseplanarchitect.com   House Plan Drafting   (1) [ 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 '%house plans%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM mos_redirection WHERE oldurl LIKE 'house-plans/architectural-services.html' LIMIT 1
5
UPDATE mos_redirection SET cpt=(cpt+1) WHERE `newurl` LIKE 'index.php?option=com_newsfeeds&catid=26&Itemid=7'
6
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 7 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM mos_session
 WHERE (
 ( time < '1280402283' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1280402283' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM mos_session
 WHERE session_id = '59b30c70a8bf45fadec4e9319998e9b7'
9
UPDATE mos_session SET `time`='1280403183',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='59b30c70a8bf45fadec4e9319998e9b7'
10
SELECT *
 FROM mos_menu
 WHERE id = 7
11
SELECT cc.*, a.catid, COUNT(a.id) AS numlinks
 FROM mos_categories AS cc
 LEFT JOIN mos_newsfeeds AS a ON a.catid = cc.id
 WHERE a.published = 1
 AND cc.section = 'com_newsfeeds'
 AND cc.published = 1
 AND cc.access <= 0
 GROUP BY cc.id
 ORDER BY cc.ordering
12
SELECT *
 FROM mos_newsfeeds
 WHERE catid = 26
 AND published = 1
 ORDER BY ordering
13
SELECT id, name, description, image, image_position
 FROM mos_categories
 WHERE id = 26
 AND published = 1
 AND access <= 0
14
SELECT name FROM mos_newsfeeds WHERE id = "11"
15
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_newsfeeds'
16
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_newsfeeds&task=view&feedid=11&Itemid=7'
17
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'
18
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
19
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 = 7 )
 ORDER BY ordering
20
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
21
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_frontpage'
22
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_frontpage&Itemid=1'
23
SELECT title AS section FROM mos_sections WHERE id=1
24
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=section&id=1&Itemid=2'
25
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
26
SELECT id
 FROM mos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=4'
27
SELECT title_alias FROM mos_content WHERE id=4
28
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
29
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=4&Itemid=34'
30
SELECT title_alias FROM mos_content WHERE id=19
31
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
32
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=19&Itemid=35'
33
SELECT id
 FROM mos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=40'
34
SELECT title_alias FROM mos_content WHERE id=40
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=40
36
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=40&Itemid=58'
37
SELECT title_alias FROM mos_content WHERE id=42
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=42
39
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=42&Itemid=60'
40
SELECT name FROM mos_menu WHERE link = 'index.php?option=com_contact'
41
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid=3'
42
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'Other Menu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
43
SELECT title_alias FROM mos_content WHERE id=17
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=17
45
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=17&Itemid=32'
46
SELECT title_alias FROM mos_content WHERE id=20
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=20
48
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=20&Itemid=36'
49
SELECT title_alias FROM mos_content WHERE id=12
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=12
51
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=12&Itemid=27'
52
SELECT title_alias FROM mos_content WHERE id=16
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=16
54
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=16&Itemid=31'
55
SELECT title_alias FROM mos_content WHERE id=18
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=18
57
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=18&Itemid=33'
58
SELECT title_alias FROM mos_content WHERE id=21
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=21
60
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=21&Itemid=37'
61
SELECT title_alias FROM mos_content WHERE id=31
62
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
63
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=31&Itemid=51'
64
SELECT title_alias FROM mos_content WHERE id=32
65
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
66
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=32&Itemid=53'