SELECT *
FROM por_session
WHERE session_id = '3tq3o9eaj11cttbh6dshkifbk7'
DELETE
FROM por_session
WHERE ( TIME < '1329992139' )
SELECT *
FROM por_session
WHERE session_id = '3tq3o9eaj11cttbh6dshkifbk7'
UPDATE `por_session`
SET `time`='1329993039',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='saI8tzyUnFrTUr08Qm0YerTrVb6WfxlbL-3dkRLbrjJJX8SdD0O7q8XxmHiy72vRv_VCDDekI4LsDrQUG3XWWErpBCCWA5rzFVifI0w713eDdMMaZBjCQvQX-LWRm-wcEGVQHkhsLySI13jQgnWV0qGJ18wiIYlh5i_lmhSeRAUzg2r7RWbe7rwubXLe6ZAuMvc_8z24qS8JDkZ-pQG6sZXyvB2t9caudWXazwZ-M5rJaASU2jm_NnCiOsmqV3_1oxntzV8vdh6ffrcj3Fhsr0AtxNfLUAtLeS3skaeYNGRtlNM_BZlY1yAkSjddjHKX3sfu9__Mup7eE-aJJtKfcaIbjP5rLzjFJKpMHxqZFYRUeDVWiqjsniVPvdrmDJhoaYIp8_GGSFxEHel791ldOTCYmd0z8Jx9FsswtNCL_KGuUFJZmmZOAKuw0hlffY65JmYsTu_C4wJD6w4zenXqqJa3NINtMsGs8AxjJCdXQvVcuGi7QN--7WhDis-QH1cb832KR9RmowM1RnmI0JTovlLRMUXERPdeDDwn8KdW2aVlvnjG6XXSvWiMEoKVl1W8Gmqv-fcJPil5T8fel6bLt6e7zkx9EFpM7sSenNkZzplgUrFaczImwVlKSZF4XHvRxEZF4jrVE88frCOCZvYfE27pMA-jPhMnGv2KYjbl2HLXw1HY2nBDXYWc2sqnmWq79JzicxNHIVLOXTsPzBpjXwKJmTDTzSwv-69iwlhu4ZciMPANNL98E7iQzy4PjfdG3jLOKN_TxLUj-2CaBafy504ZJLZycLQ1zBtLLZWiW-UvM8l_PdDW4_5FR5B_LWutKHZ9CG36M3KYBnxNyNGD22R62-vrgEtiYOf3aqff-bl06KHvoc0vTySX73Ls45Hs32H-KtNsV81-K9r4SF-qLttegmNRfrGLNf9ZuHnoUL-sJnal15BEO2CObkUepUmmYTUkgAJemzIkQHYw5gL5Ni12e_xsDhOe0Q-aNCHaf_tBysjJUeK9eH1RTDWLzaDbWGe6nCNYEGIeiI618fVc7cVWuQURDA_unEptTnVupZDbtyjLahM_d15gxyvKJ4i3aF_Yr5tJa1eWYHi2k1ds94xOMwoWWeCfcbCH-fh6yz-b7flYIAn8xSGERw7JsBq7j0Ss9qoqkzD179IJG_-U8Hn1YoRMpsI5rnK6LH48zmJaK213iHeq9A8FTYXUAnhyCb9kP5KUdozdlAXaNt9Nrksd8XyRVvgBFba2zVCDEbb3uvccLbEkNCi6Kwb8YOMT16ZTDapkMvfhshfZPwukkLf8bdUnYhUZ2Uzj1GV1pqfmPBBvl65rHfuntMh9GwH1Cbv8u2WHBgp-h6sB4vGGuZVftVwjoYTwHNbI2wHdd1PQFyrZWGpTCLkg0PjhMdK09CMBoGEMEZsWPCMH_uJCO6Mv_3ozceX3TAnydBKStMGzf47KQHUuAm2bWIiwbDi_KQl46xlTcRW9MUWk-R1qJm8S1IciNUebujJBaBXj5ZG0XDQkounSz7L87-PYTigjCKgFXvhSIj-lkBN9A6fqWk38FsSm-s1WAeuKDrfn9HpWOadAQyLOBYtU6f4IcURpLL2ZLOLAx5-71NAhBlKcfW1H2fRcTx8mRK0TzqawWhas_w8921S7UfqLnYdvBbHy2B-S2FV55yxGBj2HEzNOuH_geADDlITQXhaXeTdrb-ebV9mDb7WMbCq7C8iellxT'
WHERE session_id='3tq3o9eaj11cttbh6dshkifbk7'
SELECT *
FROM por_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM por_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM por_menu AS m
LEFT JOIN por_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM por_eventlist_settings
WHERE id = 1
SELECT template
FROM por_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 65)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.id AS eventid, a.dates, a.enddates, a.times, a.endtimes, a.title, a.created, a.locid, a.datdescription, l.id, l.venue, l.city, l.state, l.url, c.catname, c.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END AS venueslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS categoryslug
FROM por_eventlist_events AS a
LEFT JOIN por_eventlist_venues AS l
ON l.id = a.locid
LEFT JOIN por_eventlist_categories AS c
ON c.id = a.catsid
WHERE a.published = 1
AND c.access <= 0
ORDER BY a.dates ASC, a.dates, a.times
SELECT a.id AS eventid, a.dates, a.enddates, a.times, a.endtimes, a.title, a.created, a.locid, a.datdescription, l.id, l.venue, l.city, l.state, l.url, c.catname, c.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END AS venueslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS categoryslug
FROM por_eventlist_events AS a
LEFT JOIN por_eventlist_venues AS l
ON l.id = a.locid
LEFT JOIN por_eventlist_categories AS c
ON c.id = a.catsid
WHERE a.published = 1
AND c.access <= 0
ORDER BY a.dates ASC, a.dates, a.times
LIMIT 0, 30
SELECT g.group_id
FROM por_eventlist_groupmembers AS g
WHERE g.member = 0
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM por_modules AS m
LEFT JOIN por_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 65 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT parent, menutype, ordering
FROM por_menu
WHERE id = 65
LIMIT 1
SELECT COUNT(*)
FROM por_menu AS m
WHERE menutype='medlemsressurser'
AND published=1
AND parent=0
AND ordering < 1
AND access <= '0'