Identified the professions for M-STAR project

Written on 01 April 2017.

With participation of the 200 students from 6 madrasas and local 30 employers M-STAR project staff organized labor market analysis. During the meetings staff asked from parts which professions are more popular and why? Also staff learned wishes of the students about the profession. By end of the analysis it was unexpected result, needs and wishes of the parts were coincided. For the labor market the next professions are needed: welders, seamstress, PC users and cooker-confectioner. Short –term courses will be provided on selected madrasas for the project.

Joomla! Debug Console

19 Queries Logged

SELECT `data` FROM `iafco_session` WHERE `session_id` = 'u9tljphfthn7l2q42eo2fcn784'
DELETE FROM `iafco_session` WHERE `time` < '1739395137'
SELECT `session_id` FROM `iafco_session` WHERE `session_id` = 'u9tljphfthn7l2q42eo2fcn784' LIMIT 0, 1
INSERT INTO `iafco_session` (`session_id`, `client_id`, `time`) VALUES ('u9tljphfthn7l2q42eo2fcn784', 0, '1739396037')
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 = 1
SELECT id, rules FROM `iafco_viewlevels`
SELECT COUNT(*) FROM `iafco_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 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.lft
SELECT a.rules FROM iafco_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT 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.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( 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 FROM iafco_content AS a LEFT JOIN iafco_categories AS c on c.id = a.catid LEFT JOIN iafco_users AS u on u.id = a.created_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 <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('en-GB','*') AND a.id = 175 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-02-12 21:33:57') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-02-12 21:33:57') AND (a.state = 1 OR a.state =2)
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.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.lft
SELECT a.sef AS sef,a.lang_code AS lang_code FROM iafco_languages AS a
SELECT params FROM iafco_extensions AS e WHERE e.element='com_widgetkit'
SELECT id,template FROM iafco_template_styles WHERE client_id=0 AND home=1
SELECT * FROM iafco_widgetkit_widget WHERE id=67
SHOW FULL COLUMNS FROM `iafco_content`
UPDATE iafco_content SET hits = hits + 1 WHERE id = 175
UPDATE `iafco_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1739396037;s:18:\"session.timer.last\";i:1739396037;s:17:\"session.timer.now\";i:1739396037;s:24:\"session.client.forwarded\";s:11:\"18.97.14.81\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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;}s:13:\"session.token\";s:32:\"5358f9930882f5d4baafe413019d5684\";}' , `time` = '1739396037' WHERE `session_id` = 'u9tljphfthn7l2q42eo2fcn784'

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1 × 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.rgt
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM iafco_contact_details AS contact
1 × SELECT a.sef AS sef,a.lang_code AS lang_code FROM iafco_languages AS
1 × SELECT params FROM iafco_extensions AS e
1 × SELECT * FROM iafco_widgetkit_widget
1 × SELECT id,template FROM iafco_template_styles
1 × SELECT b.rules FROM iafco_assets AS a LEFT JOIN iafco_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT a.rules FROM iafco_assets AS a
1 × SELECT b.id FROM iafco_usergroups AS a LEFT JOIN iafco_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `session_id` FROM `iafco_session`
1 × SELECT id, rules FROM `iafco_viewlevels
1 × SELECT COUNT(*) FROM `iafco_menu`
1 × 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_id
1 × SELECT `data` FROM `iafco_session`

OTHER Tables:

1 × UPDATE `iafco_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1739396037;s:18:\"session.timer.last\";i:1739396037;s:17:\"session.timer.now\";i:1739396037;s:24:\"session.client.forwarded\";s:11:\"18.97.14.81\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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;}s:13:\"session.token\";s:32:\"5358f9930882f5d4baafe413019d5684\";}' , `time` = '1739396037'
1 × UPDATE iafco_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `iafco_content
1 × INSERT INTO `iafco_session` (`session_id`, `client_id`, `time`) VALUES ('u9tljphfthn7l2q42eo2fcn784', 0, '1739396037'
1 × DELETE FROM `iafco_session`

Identified the professions for M-STAR project

Bishkek Program office

Balykchy Program office

Osh Program office

Joomla! Debug Console

Session

__default

user

Profile Information

Memory Usage

Database Queries

19 Queries Logged

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: