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) 74 queries took 73 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`773
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `suppliers`772
5DESCRIBE `statuses`552
6DESCRIBE `products`882
7DESCRIBE `areas`441
8DESCRIBE `matchingcatalogues`441
9DESCRIBE `catalogues`11111
10DESCRIBE `questionstatuses`441
11DESCRIBE `questions`12121
12DESCRIBE `questiontypes`442
13DESCRIBE `areas_catalogues`661
14DESCRIBE `catalogues_matchingcatalogues`332
15DESCRIBE `areas_products`331
16DESCRIBE `users`25252
17DESCRIBE `groups`221
18DESCRIBE `usercompanies`661
19DESCRIBE `supplierdetails`39391
20DESCRIBE `adminsuppliers`552
21DESCRIBE `webcasts`12121
22DESCRIBE `tags`221
23DESCRIBE `glossaryentries`881
24DESCRIBE `categories`222
25DESCRIBE `studies`14141
26DESCRIBE `studydownloads`991
27DESCRIBE `studies_suppliers`332
28DESCRIBE `studies_tags`332
29DESCRIBE `poolentries`10101
30DESCRIBE `poolentries_tags`332
31DESCRIBE `expertquestions`662
32DESCRIBE `expertquestions_tags`331
33DESCRIBE `references`882
34DESCRIBE `references_tags`331
35DESCRIBE `newsarticles`12121
36DESCRIBE `newsarticles_suppliers`332
37DESCRIBE `newsarticles_tags`331
38DESCRIBE `documents`10101
39DESCRIBE `documenttypes`552
40DESCRIBE `documents_tags`332
41DESCRIBE `tags_webcasts`331
42DESCRIBE `jobs`20201
43DESCRIBE `appointments`12121
44DESCRIBE `supplieruploads`991
45DESCRIBE `fairs`661
46DESCRIBE `fairs_suppliers`552
47DESCRIBE `areas_suppliers`661
48DESCRIBE `researchentries`11111
49DESCRIBE `consultingskills`13131
50DESCRIBE `branchresults`661
51DESCRIBE `moduleresults`881
52DESCRIBE `catalogues_moduleresults`331
53DESCRIBE `catalogueresults`881
54SELECT `Researchentry`.`id`, `Researchentry`.`title`, `Researchentry`.`slug` FROM `researchentries` AS `Researchentry` WHERE `Researchentry`.`online` = 1 ORDER BY `Researchentry`.`order` ASC 550
55SELECT `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
56SELECT `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 20201
57SELECT `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
58SELECT `Consultingskill`.`id`, `Consultingskill`.`title`, `Consultingskill`.`slug` FROM `consultingskills` AS `Consultingskill` WHERE `Consultingskill`.`online` = 1 ORDER BY `Consultingskill`.`order` ASC 15150
59SELECT `Expertquestion`.`id`, `Expertquestion`.`teaser`, `Expertquestion`.`slug` FROM `expertquestions` AS `Expertquestion` WHERE 1 = 1 ORDER BY `Expertquestion`.`order` ASC 11110
60SELECT `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
61SELECT * 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`98980
62SELECT * 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`71710
63SELECT `Researchentry`.`id`, `Researchentry`.`title`, `Researchentry`.`slug` FROM `researchentries` AS `Researchentry` WHERE `Researchentry`.`online` = 1 ORDER BY `Researchentry`.`order` ASC 550
64SELECT `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
65SELECT `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
66SELECT `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
67SELECT `Consultingskill`.`id`, `Consultingskill`.`title`, `Consultingskill`.`slug` FROM `consultingskills` AS `Consultingskill` WHERE `Consultingskill`.`online` = 1 ORDER BY `Consultingskill`.`order` ASC 15150
68SELECT `Expertquestion`.`id`, `Expertquestion`.`teaser`, `Expertquestion`.`slug` FROM `expertquestions` AS `Expertquestion` WHERE 1 = 1 ORDER BY `Expertquestion`.`order` ASC 11110
69SELECT `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
70SELECT `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 30300
71SELECT `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
72SELECT `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
73SELECT `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
74SELECT COUNT(*) as total FROM suppliers WHERE status_id = 3 GROUP BY status_id;110