"Black Currant": the application is targeted at farmers growing black currant in Kyrgyzstan. The annex contains the main diseases and pests of black currant and ways to control them, namely: chemical, biological and agro technical. Choosing a way to protect the black currant, the farmer has the opportunity to contact by phone directly with a company that sells chemical and biological protection products, or with agricultural specialists in berry crops.
Download
"Greenhouses": the application is targeted at people who grow different products in greenhouses. The application contains information on companies specializing in the sale, installation and repair in Kyrgyzstan of the elements of the greenhouse: frame, coating, drip irrigation, ventilation and heating systems, additional equipment. The application also provides information with contact details of credit institutions that finance the construction and operation of greenhouses.
Download
In the application “Warm house”, you will find information on insulating of houses and building of stoves. The work on the development of the mobile application was carried out under the framework of the project "Green Skills Training in Rural Areas - G-STAR" financed by Helvetas Swiss Intercooperation and the Embassy of Finland in Astana. The experts of the PF AVEP, Unison Group, PF CEEBA and PU AMETiS developed the informative part of the application.
Avisa Technologies LLC developed the technical part.
Download
Timiryazeva street 134,
Bishkek, 720014
tel.: +996 (312) 903 707
Abdrahmanova str. 374A,
Balykchy, 722300
tel.: +996 (3944) 30603
fax: +996 (3944) 30617
Oskonbaeva str. 4,
Osh, 714004
tel.: +996 (773) 640 325
session.client.forwarded ⇒ 3.145.15.205
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
Application 0.000 seconds (+0.000); 0.33 MB (+0.326) - afterLoadApplication 0.027 seconds (+0.027); 1.42 MB (+1.092) - afterInitialiseApplication 0.037 seconds (+0.011); 2.05 MB (+0.627) - afterRouteApplication 0.104 seconds (+0.067); 3.48 MB (+1.439) - afterDispatchApplication 0.110 seconds (+0.006); 3.63 MB (+0.147) - beforeRenderModule mod_custom (Bishkek Program office)Application 0.112 seconds (+0.002); 3.64 MB (+0.010) - afterRenderModule mod_custom (Bishkek Program office)Application 0.113 seconds (+0.001); 3.64 MB (-0.001) - beforeRenderModule mod_custom (Balykchy Program office)Application 0.114 seconds (+0.001); 3.64 MB (+0.004) - afterRenderModule mod_custom (Balykchy Program office)Application 0.115 seconds (+0.001); 3.64 MB (-0.002) - beforeRenderModule mod_custom (Osh Program office)Application 0.116 seconds (+0.001); 3.65 MB (+0.004) - afterRenderModule mod_custom (Osh Program office)Application 0.121 seconds (+0.005); 3.72 MB (+0.074) - beforeRenderModule mod_custom (Logo3)Application 0.121 seconds (+0.001); 3.73 MB (+0.004) - afterRenderModule mod_custom (Logo3)Application 0.123 seconds (+0.002); 3.72 MB (-0.001) - beforeRenderModule mod_custom (flazhki)Application 0.123 seconds (+0.000); 3.73 MB (+0.004) - afterRenderModule mod_custom (flazhki)Application 0.125 seconds (+0.002); 3.73 MB (+0.004) - beforeRenderModule mod_menu (Main menu)Application 0.135 seconds (+0.010); 3.78 MB (+0.047) - afterRenderModule mod_menu (Main menu)Application 0.145 seconds (+0.010); 3.90 MB (+0.117) - beforeRenderModule mod_search (Search)Application 0.147 seconds (+0.003); 3.92 MB (+0.019) - afterRenderModule mod_search (Search)Application 0.149 seconds (+0.002); 3.91 MB (-0.007) - beforeRenderModule mod_custom (Logo small)Application 0.149 seconds (+0.000); 3.91 MB (+0.004) - afterRenderModule mod_custom (Logo small)Application 0.152 seconds (+0.002); 3.92 MB (+0.003) - beforeRenderModule mod_breadcrumbs (Breadcrumbs (en))Application 0.154 seconds (+0.002); 3.93 MB (+0.015) - afterRenderModule mod_breadcrumbs (Breadcrumbs (en))Application 0.156 seconds (+0.002); 3.93 MB (+0.000) - beforeRenderModule mod_articles_latest (News)Application 0.169 seconds (+0.013); 4.05 MB (+0.122) - afterRenderModule mod_articles_latest (News)Application 0.172 seconds (+0.003); 3.96 MB (-0.091) - beforeRenderModule mod_custom (jivovo)Application 0.172 seconds (+0.000); 3.97 MB (+0.004) - afterRenderModule mod_custom (jivovo)Application 0.174 seconds (+0.002); 3.97 MB (+0.001) - beforeRenderModule mod_menu (Offcanvas Menu (en))Application 0.183 seconds (+0.010); 3.98 MB (+0.009) - afterRenderModule mod_menu (Offcanvas Menu (en))Application 0.195 seconds (+0.012); 3.93 MB (-0.046) - afterRender3.93 MB (4,124,456 Bytes)SELECT `data`
FROM `iafco_session`
WHERE `session_id` = 'fq6eo45flcjgarrb4805uksdg4'DELETE
FROM `iafco_session`
WHERE `time` < '1714477667'SELECT `session_id`
FROM `iafco_session`
WHERE `session_id` = 'fq6eo45flcjgarrb4805uksdg4'
LIMIT 0, 1INSERT INTO `iafco_session`
(`session_id`, `client_id`, `time`)
VALUES
('fq6eo45flcjgarrb4805uksdg4', 0, '1714478567')SELECT b.id
FROM iafco_usergroups AS a
LEFT JOIN iafco_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `iafco_viewlevels`SELECT COUNT(*)
FROM `iafco_menu`
WHERE home = 1
AND published = 1
AND client_id = 0SELECT 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 iafco_menu AS m
LEFT JOIN iafco_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.lftSELECT id, home, template, s.params
FROM iafco_template_styles as s
LEFT JOIN iafco_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 = 1SELECT a.rules
FROM iafco_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSELECT b.rules
FROM iafco_assets AS a
LEFT JOIN iafco_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.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM iafco_categories as c
LEFT JOIN iafco_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 iafco_categories AS cat JOIN iafco_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
LEFT JOIN `iafco_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=37
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.lftSELECT b.rules
FROM iafco_assets AS a
LEFT JOIN iafco_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.37')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT 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 iafco_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 iafco_content AS a
LEFT JOIN iafco_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN iafco_categories AS c
ON c.id = a.catid
LEFT JOIN iafco_users AS ua
ON ua.id = a.created_by
LEFT JOIN iafco_users AS uam
ON uam.id = a.modified_by
LEFT JOIN iafco_categories as parent
ON parent.id = c.parent_id
LEFT JOIN iafco_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM iafco_categories AS cat JOIN iafco_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 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.catid = 37
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-30 12:02:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-30 12:02:47')
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
LIMIT 0, 9SELECT 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 iafco_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 iafco_content AS a
LEFT JOIN iafco_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN iafco_categories AS c
ON c.id = a.catid
LEFT JOIN iafco_users AS ua
ON ua.id = a.created_by
LEFT JOIN iafco_users AS uam
ON uam.id = a.modified_by
LEFT JOIN iafco_categories as parent
ON parent.id = c.parent_id
LEFT JOIN iafco_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM iafco_categories AS cat JOIN iafco_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 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.catid = 37
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-30 12:02:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-30 12:02:47')
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.createdSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM iafco_categories as c
LEFT JOIN iafco_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 iafco_categories AS cat JOIN iafco_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=37
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.lftSELECT params
FROM iafco_extensions AS e
WHERE e.element='com_widgetkit'SELECT id,template
FROM iafco_template_styles
WHERE client_id=0
AND home=1SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM iafco_modules AS m
LEFT JOIN iafco_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN iafco_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 <= '2024-04-30 12:02:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-30 12:02:47')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 270 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingSELECT 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 iafco_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 iafco_content AS a
LEFT JOIN iafco_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN iafco_categories AS c
ON c.id = a.catid
LEFT JOIN iafco_users AS ua
ON ua.id = a.created_by
LEFT JOIN iafco_users AS uam
ON uam.id = a.modified_by
LEFT JOIN iafco_categories as parent
ON parent.id = c.parent_id
LEFT JOIN iafco_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM iafco_categories AS cat JOIN iafco_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 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.catid IN (26)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-30 12:02:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-30 12:02:47')
AND a.language in ('en-GB','*')
ORDER BY a.created DESC
LIMIT 0, 3SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM iafco_categories as c
LEFT JOIN iafco_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 iafco_categories AS cat JOIN iafco_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=26
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.lftUPDATE `iafco_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714478567;s:18:\"session.timer.last\";i:1714478567;s:17:\"session.timer.now\";i:1714478567;s:24:\"session.client.forwarded\";s:12:\"3.145.15.205\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1714478567'
WHERE `session_id` = 'fq6eo45flcjgarrb4805uksdg4'3 × 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 iafco_contact_details AS contact2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM iafco_categories as c
LEFT JOIN iafco_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 iafco_categories AS cat JOIN iafco_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT b.rules
FROM iafco_assets AS a
LEFT JOIN iafco_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM iafco_categories as c
LEFT JOIN iafco_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 iafco_categories AS cat JOIN iafco_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT params
FROM iafco_extensions AS e1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM iafco_modules AS m
LEFT JOIN iafco_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN iafco_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id,template
FROM iafco_template_styles1 × SELECT a.rules
FROM iafco_assets AS a1 × SELECT b.id
FROM iafco_usergroups AS a
LEFT JOIN iafco_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `iafco_session`1 × SELECT id, rules
FROM `iafco_viewlevels1 × SELECT COUNT(*)
FROM `iafco_menu`1 × SELECT id, home, template, s.params
FROM iafco_template_styles as s
LEFT JOIN iafco_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 iafco_menu AS m
LEFT JOIN iafco_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `iafco_session`1 × UPDATE `iafco_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714478567;s:18:\"session.timer.last\";i:1714478567;s:17:\"session.timer.now\";i:1714478567;s:24:\"session.client.forwarded\";s:12:\"3.145.15.205\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1714478567'1 × INSERT INTO `iafco_session` (`session_id`, `client_id`, `time`)
VALUES ('fq6eo45flcjgarrb4805uksdg4', 0, '1714478567'1 × DELETE
FROM `iafco_session`