IJDG Gallery Trunk Show Home
IJDG Trunk Show Home Artists Live Chat IJDG Search Contact Us - - - - - - - - - - - - - - Artist Editor Administrator	Welcome to the International Jewelry Designers' Guild Virtual Trunk Show! Written by IJDG VTS Editor    Mar 17, 2005 at 04:55 PM Last Updated ( Dec 04, 2005 at 12:20 PM )     © 2005 IJDG. All rights reserved.

1
SELECT * FROM mos_menu ORDER BY name
2
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=1) ORDER BY client_id, menuid
3
DELETE FROM mos_session WHERE (time<1280598839 AND guest>=0) OR (time<1280596139 AND guest<0)
4
SELECT * FROM mos_session WHERE session_id='081619fc226a10119cdedc855e95cf51'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('ec086d2e29a2ff08271ff4ec631b247f')
6
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '882388c04fb9945ae7b2ff01e5874748','1280599739','0','','0','1' ) 
7
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
8
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
9
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
10
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-07-31 11:08:59'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-07-31 11:08:59' )
 AND a.access <= 0
 ORDER BY f.ordering
11
SELECT id FROM mos_mambots WHERE element = 'mosthumb' AND folder = 'content'
12
SELECT * FROM mos_mambots WHERE id='22'
13
SELECT i.id, i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id ORDER BY i.id DESC LIMIT 250
14
SELECT i.id, i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id ORDER BY i.id DESC LIMIT 250
15
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='66'
16
SELECT COUNT(*)
FROM mos_core_acl_aro_groups AS g1
LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='25' AND g2.name='Public Frontend'
17
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
18
SELECT id, title, module, position, content, showtitle, params, published, m.access, m.groups
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering