SoftSelect GmbH - Sitemap

HR-Studie 2021/22 - Human Resources Software Systeme 2021/22

Wir beraten Sie gern!

Bitte zögern Sie nicht, uns mit Fragen jeglicher Art oder Feedback zu kontaktieren:

E-Mail:: info@softselect.de
Telefon: +49 (0)40 870 875-0
Telefax: +49 (0)40 870 875-55


Wir freuen uns auf Sie!

(default) 27 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `researchentries`11111
2DESCRIBE `consultingskills`13131
3DESCRIBE `branchresults`661
4DESCRIBE `moduleresults`881
5DESCRIBE `catalogues_moduleresults`330
6DESCRIBE `catalogueresults`881
7SELECT `Researchentry`.`id`, `Researchentry`.`title`, `Researchentry`.`slug` FROM `researchentries` AS `Researchentry` WHERE `Researchentry`.`online` = 1 ORDER BY `Researchentry`.`order` ASC 550
8SELECT `Glossaryentry`.`id`, `Glossaryentry`.`title`, `Glossaryentry`.`slug` FROM `glossaryentries` AS `Glossaryentry` LEFT JOIN `categories` AS `Category` ON (`Glossaryentry`.`category_id` = `Category`.`id`) LEFT JOIN `tags` AS `Tag` ON (`Glossaryentry`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `Glossaryentry`.`title` ASC 1941943
9SELECT `Webcast`.`id`, `Webcast`.`shorttitle`, `Webcast`.`slug` FROM `webcasts` AS `Webcast` LEFT JOIN `suppliers` AS `Supplier` ON (`Supplier`.`status_id` = 3 AND `Webcast`.`supplier_id` = `Supplier`.`id`) WHERE `Webcast`.`online` = 1 ORDER BY `Webcast`.`order` ASC 20200
10SELECT `Tag`.`id`, `Tag`.`name`, `TagsWebcast`.`id`, `TagsWebcast`.`tag_id`, `TagsWebcast`.`webcast_id` FROM `tags` AS `Tag` JOIN `tags_webcasts` AS `TagsWebcast` ON (`TagsWebcast`.`webcast_id` IN (14140, 14135, 14136, 14137, 14138, 14139, 14132, 15, 13, 14, 14131, 14130, 12, 14129, 14128, 14127, 14126, 14125, 14124, 10) AND `TagsWebcast`.`tag_id` = `Tag`.`id`) 23230
11SELECT `Consultingskill`.`id`, `Consultingskill`.`title`, `Consultingskill`.`slug` FROM `consultingskills` AS `Consultingskill` WHERE `Consultingskill`.`online` = 1 ORDER BY `Consultingskill`.`order` ASC 15150
12SELECT `Expertquestion`.`id`, `Expertquestion`.`teaser`, `Expertquestion`.`slug` FROM `expertquestions` AS `Expertquestion` WHERE 1 = 1 ORDER BY `Expertquestion`.`order` ASC 11110
13SELECT `Tag`.`id`, `Tag`.`name`, `ExpertquestionsTag`.`id`, `ExpertquestionsTag`.`expertquestion_id`, `ExpertquestionsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `expertquestions_tags` AS `ExpertquestionsTag` ON (`ExpertquestionsTag`.`expertquestion_id` IN (31, 33, 30, 16, 36, 2, 1, 3, 17, 18, 19) AND `ExpertquestionsTag`.`tag_id` = `Tag`.`id`) 26261
14SELECT * FROM `suppliers` WHERE `suppliers`.`id` IN (SELECT `areas_suppliers`.`supplier_id` FROM `areas_suppliers`) AND `suppliers`.`status_id` = 3 GROUP BY `suppliers`.`name` ORDER BY `suppliers`.`name`98985
15SELECT * FROM `suppliers` WHERE `suppliers`.`id` IN (SELECT `studies_suppliers`.`supplier_id` FROM `studies_suppliers` WHERE `studies_suppliers`.`supplier_id` NOT IN (SELECT `supplier_id` FROM `areas_suppliers` WHERE 1=1)) ORDER BY `suppliers`.`name`71715
16SELECT `Researchentry`.`id`, `Researchentry`.`title`, `Researchentry`.`slug` FROM `researchentries` AS `Researchentry` WHERE `Researchentry`.`online` = 1 ORDER BY `Researchentry`.`order` ASC 550
17SELECT `Glossaryentry`.`id`, `Glossaryentry`.`title`, `Glossaryentry`.`slug` FROM `glossaryentries` AS `Glossaryentry` LEFT JOIN `categories` AS `Category` ON (`Glossaryentry`.`category_id` = `Category`.`id`) LEFT JOIN `tags` AS `Tag` ON (`Glossaryentry`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `Glossaryentry`.`title` ASC 1941940
18SELECT `Webcast`.`id`, `Webcast`.`shorttitle`, `Webcast`.`slug` FROM `webcasts` AS `Webcast` LEFT JOIN `suppliers` AS `Supplier` ON (`Supplier`.`status_id` = 3 AND `Webcast`.`supplier_id` = `Supplier`.`id`) WHERE `Webcast`.`online` = 1 ORDER BY `Webcast`.`order` ASC 20200
19SELECT `Tag`.`id`, `Tag`.`name`, `TagsWebcast`.`id`, `TagsWebcast`.`tag_id`, `TagsWebcast`.`webcast_id` FROM `tags` AS `Tag` JOIN `tags_webcasts` AS `TagsWebcast` ON (`TagsWebcast`.`webcast_id` IN (14140, 14135, 14136, 14137, 14138, 14139, 14132, 15, 13, 14, 14131, 14130, 12, 14129, 14128, 14127, 14126, 14125, 14124, 10) AND `TagsWebcast`.`tag_id` = `Tag`.`id`) 23230
20SELECT `Consultingskill`.`id`, `Consultingskill`.`title`, `Consultingskill`.`slug` FROM `consultingskills` AS `Consultingskill` WHERE `Consultingskill`.`online` = 1 ORDER BY `Consultingskill`.`order` ASC 15150
21SELECT `Expertquestion`.`id`, `Expertquestion`.`teaser`, `Expertquestion`.`slug` FROM `expertquestions` AS `Expertquestion` WHERE 1 = 1 ORDER BY `Expertquestion`.`order` ASC 11110
22SELECT `Tag`.`id`, `Tag`.`name`, `ExpertquestionsTag`.`id`, `ExpertquestionsTag`.`expertquestion_id`, `ExpertquestionsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `expertquestions_tags` AS `ExpertquestionsTag` ON (`ExpertquestionsTag`.`expertquestion_id` IN (31, 33, 30, 16, 36, 2, 1, 3, 17, 18, 19) AND `ExpertquestionsTag`.`tag_id` = `Tag`.`id`) 26260
23SELECT `Branchresult`.`id`, `Branchresult`.`title`, `Branchresult`.`title_en`, `Branchresult`.`slug`, `Branchresult`.`area_id`, `Branchresult`.`question_id`, `Area`.`id`, `Area`.`name`, `Area`.`abbreviation`, `Area`.`matchingcatalogue_id`, `Question`.`id`, `Question`.`text`, `Question`.`text_en`, `Question`.`evaluate`, `Question`.`questiontype_id`, `Question`.`questionstatus_id`, `Question`.`help`, `Question`.`help_en`, `Question`.`order`, `Question`.`bold`, `Question`.`catalogue_id`, `Question`.`last_edit` FROM `branchresults` AS `Branchresult` LEFT JOIN `areas` AS `Area` ON (`Branchresult`.`area_id` = `Area`.`id`) LEFT JOIN `questions` AS `Question` ON (`Branchresult`.`question_id` = `Question`.`id`) WHERE 1 = 1 ORDER BY `Branchresult`.`title` ASC 30301
24SELECT `Moduleresult`.`id`, `Moduleresult`.`title`, `Moduleresult`.`title_en`, `Moduleresult`.`description`, `Moduleresult`.`description_en`, `Moduleresult`.`slug`, `Moduleresult`.`glossaryentry_id`, `Moduleresult`.`catalogue_id`, `Glossaryentry`.`id`, `Glossaryentry`.`slug`, `Glossaryentry`.`title`, `Glossaryentry`.`title_en`, `Glossaryentry`.`description`, `Glossaryentry`.`description_en`, `Glossaryentry`.`category_id`, `Glossaryentry`.`tag_id` FROM `moduleresults` AS `Moduleresult` LEFT JOIN `glossaryentries` AS `Glossaryentry` ON (`Moduleresult`.`glossaryentry_id` = `Glossaryentry`.`id`) WHERE 1 = 1 ORDER BY `Moduleresult`.`title` ASC 770
25SELECT `Catalogue`.`id`, `Catalogue`.`old_id`, `Catalogue`.`name`, `Catalogue`.`name_en`, `Catalogue`.`parent_id`, `Catalogue`.`questionstatus_id`, `Catalogue`.`lft`, `Catalogue`.`rght`, `Catalogue`.`order`, `Catalogue`.`bold`, `Catalogue`.`edited_on`, `CataloguesModuleresult`.`id`, `CataloguesModuleresult`.`catalogue_id`, `CataloguesModuleresult`.`moduleresult_id` FROM `catalogues` AS `Catalogue` JOIN `catalogues_moduleresults` AS `CataloguesModuleresult` ON (`CataloguesModuleresult`.`moduleresult_id` IN (7, 3, 4, 5, 1, 2, 6) AND `CataloguesModuleresult`.`catalogue_id` = `Catalogue`.`id`) 990
26SELECT `Catalogueresult`.`id`, `Catalogueresult`.`title`, `Catalogueresult`.`title_en`, `Catalogueresult`.`description`, `Catalogueresult`.`description_en`, `Catalogueresult`.`slug`, `Catalogueresult`.`glossaryentry_id`, `Catalogueresult`.`catalogue_id`, `Catalogue`.`id`, `Catalogue`.`old_id`, `Catalogue`.`name`, `Catalogue`.`name_en`, `Catalogue`.`parent_id`, `Catalogue`.`questionstatus_id`, `Catalogue`.`lft`, `Catalogue`.`rght`, `Catalogue`.`order`, `Catalogue`.`bold`, `Catalogue`.`edited_on`, `Glossaryentry`.`id`, `Glossaryentry`.`slug`, `Glossaryentry`.`title`, `Glossaryentry`.`title_en`, `Glossaryentry`.`description`, `Glossaryentry`.`description_en`, `Glossaryentry`.`category_id`, `Glossaryentry`.`tag_id` FROM `catalogueresults` AS `Catalogueresult` LEFT JOIN `catalogues` AS `Catalogue` ON (`Catalogueresult`.`catalogue_id` = `Catalogue`.`id`) LEFT JOIN `glossaryentries` AS `Glossaryentry` ON (`Catalogueresult`.`glossaryentry_id` = `Glossaryentry`.`id`) WHERE 1 = 1 ORDER BY `Catalogueresult`.`title` ASC 220
27SELECT COUNT(*) as total FROM suppliers WHERE status_id = 3 GROUP BY status_id;110