Home Board of Directors Continuing Education Online Forms Advanced Search How to Become a CCA CCA Credential Forms Find an official CCA Contact Us Links Exams/Announcements Articles / News Presentations                   Contact Us CACCA 1143 No. Market Blvd, Suite 7 Sacramento CA USA 95834 916-928-1625 916-928-0705 Download information as a VCard Send an Email to this Contact: Enter your name: E-mail address: Message subject: Enter your message: Email a copy of this message to your own address

1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='3' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1283766498)
4
SELECT * FROM mos_session WHERE session_id='0d355b58d74b3fab62570121b904c66a'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('fe615c21e117bfc802b37c2b24257195')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '9d260b186daffc54d516f3bb00c9e6e0','1283767398','','0','1' )
7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
9
SELECT access FROM mos_menu WHERE id='3'
10
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
11
SELECT a.id AS value, CONCAT_WS( ' - ', a.name, a.con_position ) AS text
 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
 AND cc.access <=0
 ORDER BY a.default_con DESC, a.ordering ASC
12
SELECT *
 FROM mos_contact_details
 WHERE published = '1'
 AND id = 1
 AND access <=0
13
SELECT * FROM mos_menu WHERE id='3'
14
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
15
SELECT * FROM mos_components WHERE id='17'
16
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '3' OR mm.menuid = '0')
ORDER BY ordering
17
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
18
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
19
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
20
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=27'
21
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=27'
22
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
23
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
24
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
25
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
26
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
27
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
28
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=32'
29
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=32'
30
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering