Performed SQL enquiries
SELECT `data` FROM `ijm61_session` WHERE `session_id` = '0ndbal86bqrl74ffb7gnht11g0'
DELETE FROM `ijm61_session` WHERE `time` < '1618563105'
SELECT `session_id` FROM `ijm61_session` WHERE `session_id` = '0ndbal86bqrl74ffb7gnht11g0' LIMIT 0, 1
INSERT INTO `ijm61_session` (`session_id`, `client_id`, `time`) VALUES ('0ndbal86bqrl74ffb7gnht11g0', 0, '1618564005')
SELECT extension_id AS id, element AS "option", params, enabled FROM ijm61_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM ijm61_usergroups AS a LEFT JOIN ijm61_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `ijm61_viewlevels`
SELECT folder AS type, element AS name, params FROM ijm61_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering
SELECT * FROM ijm61_languages WHERE published=1 ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled FROM ijm61_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT COUNT(*) FROM `ijm61_menu` WHERE home = 1 AND published = 1 AND client_id = 0
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM ijm61_menu AS m LEFT JOIN ijm61_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled FROM ijm61_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT id, home, template, s.params FROM ijm61_template_styles as s LEFT JOIN ijm61_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT a.rules FROM ijm61_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM ijm61_assets AS a LEFT JOIN ijm61_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM ijm61_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('en-GB','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM ijm61_content AS a LEFT JOIN ijm61_categories AS c ON c.id = a.catid LEFT JOIN ijm61_users AS ua ON ua.id = a.created_by LEFT JOIN ijm61_users AS uam ON uam.id = a.modified_by LEFT JOIN ijm61_categories as parent ON parent.id = c.parent_id LEFT JOIN ijm61_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ijm61_categories AS cat JOIN ijm61_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN ijm61_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-16 09:06:45') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-16 09:06:45') AND a.language in ('en-GB','*') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 9
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM ijm61_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('en-GB','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM ijm61_content AS a LEFT JOIN ijm61_categories AS c ON c.id = a.catid LEFT JOIN ijm61_users AS ua ON ua.id = a.created_by LEFT JOIN ijm61_users AS uam ON uam.id = a.modified_by LEFT JOIN ijm61_categories as parent ON parent.id = c.parent_id LEFT JOIN ijm61_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM ijm61_categories AS cat JOIN ijm61_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN ijm61_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-16 09:06:45') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-16 09:06:45') AND a.language in ('en-GB','*') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM ijm61_categories as c LEFT JOIN ijm61_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('en-GB','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) LEFT JOIN (SELECT cat.id as id FROM ijm61_categories AS cat JOIN ijm61_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=28 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT a.sef AS sef,a.lang_code AS lang_code FROM ijm61_languages AS a
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM ijm61_modules AS m LEFT JOIN ijm61_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN ijm61_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-16 09:06:45') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-16 09:06:45') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 212 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering
SELECT m2.language, m2.id FROM ijm61_menu as m INNER JOIN ijm61_associations as a ON a.id=m.id AND a.context='com_menus.item' INNER JOIN ijm61_associations as a2 ON a.key=a2.key INNER JOIN ijm61_menu as m2 ON a2.id=m2.id WHERE m.id=212
JS 0.000 seconds (+0.000); 3.92 MB (+3.920) - Perform Visitor counting process (function: countVisitor())
Performed SQL enquiries
SELECT * FROM ijm61_jstats_configuration
JS 0.000 seconds (+0.000); 3.92 MB (+0.002) - loadKnownRecords start
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
JS 0.004 seconds (+0.004); 3.93 MB (+0.005) - loadKnownRecords end
Performed SQL enquiries
SELECT * FROM ijm61_jstats_ipaddresses AS a WHERE a.ip = '586126905'
SELECT c.* FROM ijm61_jstats_clients AS c LEFT OUTER JOIN ijm61_jstats_visits AS v ON c.client_id = v.client_id WHERE v.ip = '586126905' AND (c.visitor_id = 0 OR c.visitor_id IS NULL);
JS 0.005 seconds (+0.000); 3.93 MB (+0.001) - client & ip handling start
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
select * from `ijm61_jstats_configuration` where description like 'ext_%' and value = '1'
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
JS 0.010 seconds (+0.005); 3.95 MB (+0.022) - client & ip handling end
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
SELECT v.visit_id FROM ijm61_jstats_visits as v WHERE v.client_id = 9326 AND v.ip = 586126905 AND v.changed_at >= 1618535205
Performed SQL enquiries
UPDATE ijm61_jstats_visits SET changed_at= 1618564005 WHERE visit_id = '18758'
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
SELECT page_id, page_title FROM ijm61_jstats_pages WHERE page = '/index.php/en/home-en' LIMIT 1
INSERT INTO `ijm61_jstats_impressions` (`page_id`, `visit_id`, `timestamp`) VALUES (677,18758,1618564005)
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
JS 0.014 seconds (+0.004); 3.95 MB (+0.005) - Counting Visitor finished
Performed SQL enquiries
Welcome to the site of WeeZet BV. WeeZet is an IT consulting company that was founded by senior SAP ABAP Consultant Willy Zwaan in 2006.
The company is based in Didam (near Arnhem in the Netherlands).
On this site you can see my full CV. The CV gives you detailed information about my technical experience I have gained in the various companies. Besides of that, you can find information about mij company and how I can work without a VAR.
if you want more information, you always can mail or call me of course. You can find my information the contact page.