| 0.0010 |
SELECT * FROM `seminars` LIMIT 1
|
| 0.0076 |
SELECT *
FROM (`seminars`)
WHERE `seminars`.`date` >= '2012-05-25'
AND `seminars`.`participants` > '0'
ORDER BY `seminars`.`date` asc
|
| 0.0008 |
SELECT * FROM `speakers` LIMIT 1
|
| 0.0010 |
SELECT * FROM `categories` LIMIT 1
|
| 0.0013 |
SELECT `seminars`.*, `speakers`.`forename` AS speaker_forename, `speakers`.`lastname` AS speaker_lastname, `categories`.`name` AS category_name, `categories`.`permalink` AS category_permalink
FROM (`seminars`)
LEFT OUTER JOIN `speakers` speakers ON `speakers`.`id` = `seminars`.`speaker_id`
LEFT OUTER JOIN `categories` categories ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`date` >= '2012-05-25'
AND `seminars`.`participants` > '0'
ORDER BY `seminars`.`date` asc
LIMIT 7
|
| 0.0037 |
SELECT `seminars`.*, `speakers`.`forename` AS speaker_forename, `speakers`.`lastname` AS speaker_lastname, `categories`.`name` AS category_name, `categories`.`permalink` AS category_permalink
FROM (`seminars`)
LEFT OUTER JOIN `speakers` speakers ON `speakers`.`id` = `seminars`.`speaker_id`
LEFT OUTER JOIN `categories` categories ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`date` >= '2012-05-25'
ORDER BY `seminars`.`date` asc
|
| 0.0009 |
SELECT *
FROM (`categories`)
WHERE `categories`.`permalink` = 'marketing'
|
| 0.0007 |
SELECT `seminars`.*
FROM (`seminars`)
WHERE (
`seminars`.`date` >= '2012-05-25'
AND `seminars`.`participants` > '0'
)
AND `seminars`.`category_id` = 5
LIMIT 3
|
| 0.0007 |
SELECT *
FROM (`categories`)
WHERE `categories`.`permalink` = 'recht-finanzen'
|
| 0.0008 |
SELECT `seminars`.*
FROM (`seminars`)
WHERE (
`seminars`.`date` >= '2012-05-25'
AND `seminars`.`participants` > '0'
)
AND `seminars`.`category_id` = 6
LIMIT 3
|
| 0.0007 |
SELECT *
FROM (`categories`)
WHERE `categories`.`permalink` = 'it-operations'
|
| 0.0010 |
SELECT `seminars`.*
FROM (`seminars`)
WHERE (
`seminars`.`date` >= '2012-05-25'
AND `seminars`.`participants` > '0'
)
AND `seminars`.`category_id` = 7
LIMIT 3
|
| 0.0031 |
SELECT *
FROM (`categories`)
WHERE `categories`.`permalink` = 'hr-softskills'
|
| 0.0009 |
SELECT `seminars`.*
FROM (`seminars`)
WHERE (
`seminars`.`date` >= '2012-05-25'
AND `seminars`.`participants` > '0'
)
AND `seminars`.`category_id` = 8
LIMIT 3
|
| 0.0006 |
SELECT `categories`.`id`, `categories`.`name`
FROM (`categories`)
|
| 0.0006 |
SELECT DISTINCT `seminars`.`city`
FROM (`seminars`)
WHERE YEAR(date) = '2012' AND city != '' AND city IS NOT NULL
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 69
|
| 0.0014 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 83
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 81
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 65
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 76
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 80
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 91
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 85
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 31
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 38
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 39
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 33
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 92
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 73
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 48
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 86
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 42
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 14
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 87
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 49
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 84
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 89
|
| 0.0010 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 56
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 90
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 74
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 55
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 82
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 61
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 63
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 64
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 68
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 70
|
| 0.0009 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 66
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 57
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 54
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 75
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 88
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 58
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 52
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 53
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 59
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 48
|
| 0.0007 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 49
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 52
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 42
|
| 0.0079 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 76
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 80
|
| 0.0005 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 14
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 59
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 69
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 31
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 33
|
| 0.0008 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 38
|
| 0.0046 |
SELECT `seminars`.*, `speakers`.`forename` AS speaker_forename, `speakers`.`lastname` AS speaker_lastname
FROM (`seminars`)
LEFT OUTER JOIN `speakers` speakers ON `speakers`.`id` = `seminars`.`speaker_id`
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 64
|
| 0.0006 |
SELECT `categories`.*
FROM (`categories`)
LEFT OUTER JOIN `seminars` seminars ON `categories`.`id` = `seminars`.`category_id`
WHERE `seminars`.`id` = 76
|
