| 2.22ms |
SELECT
P.*,
DATE_SUB(P.datum, INTERVAL IFNULL(P.alterslimite, 18) YEAR) as maxbirthdate,
UNIX_TIMESTAMP(P.datum) AS unixtime,
UNIX_TIMESTAMP(P.datum_ende) AS datum_ende_ts,
(ADDTIME(P.datum, P.zeit) >= DATE_ADD(NOW(), INTERVAL 0 HOUR)) AS cd,
IFNULL(P.alterslimite, 18) AS agelimit, TIME_FORMAT(P.zeit, '%H:%i') AS fzeit,
TIME_FORMAT(P.zeitbis,'%H:%i') AS fzeitbis,
L.rid,
L.uniquestring,
L.linfos,
L.strasse AS locaddr,
L.plz AS locplz,
L.howtogetthere,
L.bild1 AS locpicture,
L.am_zvv_nachtnetz,
IFNULL(L.name, alterloc_name) AS locname,
IFNULL(L.ort, alterloc_desc) AS locort,
IFNULL(L.rid, P.alterloc_rid) AS myrid,
(CASE WHEN C.name_FR <> '' THEN C.name_FR WHEN C.name_EN <> '' THEN C.name_EN WHEN C.name <> '' THEN C.name WHEN C.name_IT <> '' THEN C.name_IT WHEN C.name_ES <> '' THEN C.name_ES WHEN C.name_BG <> '' THEN C.name_BG WHEN C.name_TR <> '' THEN C.name_TR WHEN C.name_NL <> '' THEN C.name_NL WHEN C.name_RO <> '' THEN C.name_RO ELSE '' END) AS country,
CS.state_code AS state,
C.isocode,
CC.code,
PV.verlosung_preis,
PV.verlosung_delta,
PV.verlosung_log,
PV.verlosung_freigegeben,
PV.verlosung_done,
PV.verlosung_smstext,
PV.verlosung_is_guestlist,
PV.verlosung_notify_by_sms,
PV.verlosung_gl_closing_time,
PV.verlosung_bedingungen,
PV.verlosung_gl_person,
PV.verlosung_notify_email,
PV.verlosung_is_selected_verl,
PV.verlosung_gl_person_limit,
PV.verlosung_gl_comment,
PV.verlosung_gl_type,
PV.verlosung_gl_closing_datetime,
PV.verlosung_vlive_tickets,
PV.verlosung_vlive_status,
PV.verlosung_gl_closing_hours_before_event,
PV.verlosung_member_restriction,
PV.verlosung_extra_questions_html,
PP.pass_leistung,
PP.pass_image,
PP.pass_member_restriction,
(CASE WHEN PT.description_FR <> '' THEN PT.description_FR WHEN PT.description_EN <> '' THEN PT.description_EN WHEN PT.description <> '' THEN PT.description WHEN PT.description_IT <> '' THEN PT.description_IT WHEN PT.description_ES <> '' THEN PT.description_ES WHEN PT.description_BG <> '' THEN PT.description_BG WHEN PT.description_TR <> '' THEN PT.description_TR WHEN PT.description_NL <> '' THEN PT.description_NL WHEN PT.description_RO <> '' THEN PT.description_RO ELSE '' END) AS groedesc,
PTO.orgid,
F.fid as group_pic,
F.filename,
F.directory,
F.file_location_id,
mogilefs_hash,
mimetype,
picturetype,
(CASE WHEN VGT.gt_text_FR <> '' THEN VGT.gt_text_FR WHEN VGT.gt_text_EN <> '' THEN VGT.gt_text_EN WHEN VGT.gt_text <> '' THEN VGT.gt_text WHEN VGT.gt_text_IT <> '' THEN VGT.gt_text_IT WHEN VGT.gt_text_ES <> '' THEN VGT.gt_text_ES WHEN VGT.gt_text_BG <> '' THEN VGT.gt_text_BG WHEN VGT.gt_text_TR <> '' THEN VGT.gt_text_TR WHEN VGT.gt_text_NL <> '' THEN VGT.gt_text_NL WHEN VGT.gt_text_RO <> '' THEN VGT.gt_text_RO ELSE '' END) as gt
FROM parties P
LEFT JOIN parties_verlosung PV ON P.gid = PV.gid
LEFT JOIN parties_to_organisatoren PTO ON PTO.gid = P.gid AND PTO.parties_to_organisatoren_role_id = '1'
LEFT JOIN parties_pass PP ON P.gid = PP.gid
LEFT JOIN locations L ON P.lid = L.lid
LEFT JOIN countries C ON C.cid = L.country
LEFT JOIN countries_states CS ON CS.stateid = L.country_stateid
LEFT JOIN pa_type PT ON P.groesse = PT.ptid
LEFT JOIN countries_currencies CC ON P.currency_id = CC.id
LEFT JOIN f_bilder F ON P.group_pic = F.fid
LEFT JOIN verlosung_gl_types VGT ON VGT.gtid = PV.verlosung_gl_type
WHERE P.gid = '6052493'
Called from: Tilllate_Event_Query->findById()
Affected rows: 2 Database ID: default Master: no |
| 1.01ms |
SELECT COUNT(DISTINCT mzp.uid) AS num
FROM member_zu_parties mzp
INNER JOIN users U ON U.uid = mzp.uid WHERE mzp.gid = '6052493'
AND mzp.state = 3
AND U.gesperrt = 0 AND U.validiert = 0
Called from: Tilllate_Event->getAttendeesCount()
Affected rows: 1 Database ID: default Master: no |
| 1.03ms |
SELECT
f.fid
FROM
f_comments c
LEFT JOIN
f_bilder f ON c.fid = f.fid
WHERE
f.deleted = 0
AND f.gid= '6052493'
Called from: Tilllate_Event_Index_Controller->_loadPhotoCommentsCount()
Affected rows: 11 Database ID: default Master: no |
| 1.15ms |
select f.fid from f_bilder f inner join its_me i on i.fid=f.fid where f.gid = '6052493' AND i.uid > 0 group by fid
Called from: Tilllate_Event_Index_Controller->_loadMarkedPhotosCount()
Affected rows: 33 Database ID: default Master: no |
| 0.74ms |
SELECT l.*,
pt.description AS typeName,
c.isocode,
(CASE WHEN c.name_FR <> '' THEN c.name_FR WHEN c.name_EN <> '' THEN c.name_EN WHEN c.name <> '' THEN c.name WHEN c.name_IT <> '' THEN c.name_IT WHEN c.name_ES <> '' THEN c.name_ES WHEN c.name_BG <> '' THEN c.name_BG WHEN c.name_TR <> '' THEN c.name_TR WHEN c.name_NL <> '' THEN c.name_NL WHEN c.name_RO <> '' THEN c.name_RO ELSE '' END) as countryName,
(CASE WHEN cs.state_name_FR <> '' THEN cs.state_name_FR WHEN cs.state_name_EN <> '' THEN cs.state_name_EN WHEN cs.state_name <> '' THEN cs.state_name WHEN cs.state_name_IT <> '' THEN cs.state_name_IT WHEN cs.state_name_ES <> '' THEN cs.state_name_ES WHEN cs.state_name_BG <> '' THEN cs.state_name_BG WHEN cs.state_name_TR <> '' THEN cs.state_name_TR WHEN cs.state_name_NL <> '' THEN cs.state_name_NL WHEN cs.state_name_RO <> '' THEN cs.state_name_RO ELSE '' END) as regionName,
f.filename,
f.directory,
f.file_location_id,
mogilefs_hash,
mimetype,
picturetype,
f.fid
FROM locations l
LEFT JOIN pa_type pt ON l.type = pt.ptid
LEFT JOIN countries c ON l.country = c.cid
LEFT JOIN f_bilder f ON f.fid = l.locationbild_fid
LEFT JOIN countries_states cs ON cs.stateid = l.country_stateid
WHERE l.lid = '1832'
Called from: Tilllate_Db_Query->load()
Affected rows: 1 Database ID: default Master: no |
| 0.45ms |
SELECT O.organisation, O.orgid, O.organisation_clean, O.organisation_clean_postfix
FROM organisatoren O, parties_to_organisatoren PTO, org_type OT
WHERE O.orgid = PTO.orgid AND O.org_type = OT.id
AND PTO.parties_to_organisatoren_role_id = '1'
AND PTO.gid = '6052493' AND OT.org_type_group_id = '1'
ORDER BY O.organisation
Called from: Tilllate_Event->getPromoters()
Affected rows: 2 Database ID: default Master: no |
| 4.40ms |
SELECT
pz.*, (CASE WHEN pgt.name_FR <> '' THEN pgt.name_FR WHEN pgt.name_EN <> '' THEN pgt.name_EN WHEN pgt.name <> '' THEN pgt.name WHEN pgt.name_IT <> '' THEN pgt.name_IT WHEN pgt.name_ES <> '' THEN pgt.name_ES WHEN pgt.name_BG <> '' THEN pgt.name_BG WHEN pgt.name_TR <> '' THEN pgt.name_TR WHEN pgt.name_NL <> '' THEN pgt.name_NL WHEN pgt.name_RO <> '' THEN pgt.name_RO ELSE '' END) as guestlist_type_name
FROM prizedraws pz
INNER JOIN prizedraws_to_events pte ON pte.prizedraw_id=pz.id
LEFT JOIN prizedraw_guestlist_types pgt ON pgt.id = pz.guestlist_type
WHERE
pte.event_id='6052493' AND status='open'
Called from: Tilllate_Event->getPrizedraws()
Affected rows: 0 Database ID: default Master: yes |
| 1.31ms |
SELECT * FROM f_bilder WHERE `fid`='117380053' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.99ms |
SELECT *, status
FROM f_bilder f
WHERE gid = '6052493'
AND fid <> '117380053'
AND status = 1
AND f.uploadedByOrgid=0
AND size_x_new > size_y_new LIMIT '50'
Called from: Tilllate_Event->getSelectedPhotos()
Affected rows: 0 Database ID: default Master: no |
| 0.50ms |
SELECT *, status
FROM f_bilder f
WHERE gid = '6052493'
AND fid NOT IN ('117380053')
AND size_x_new > size_y_new
AND f.uploadedByOrgid=0
ORDER BY f_bilder_pos, quickaccess, fid LIMIT '2'
Called from: Tilllate_Event->getLandscapePhotos()
Affected rows: 2 Database ID: default Master: no |
| 1.00ms |
SELECT *, status
FROM f_bilder f
WHERE gid = '6052493'
AND fid <> '117380053'
AND status = 1
AND f.uploadedByOrgid > 0
AND size_x_new > size_y_new LIMIT '50'
Called from: Tilllate_Event->getSelectedPromoterPhotos()
Affected rows: 0 Database ID: default Master: no |
| 1.19ms |
SELECT *, status
FROM f_bilder f
WHERE gid = '6052493'
AND fid NOT IN ('117380053')
AND f.uploadedByOrgid > 0
AND size_x_new > size_y_new
ORDER BY f_bilder_pos, quickaccess, fid LIMIT '3'
Called from: Tilllate_Event->getLandscapePromoterPhotos()
Affected rows: 0 Database ID: default Master: no |
| 0.17ms |
SELECT COUNT(DISTINCT mzp.uid) AS num
FROM member_zu_parties mzp
INNER JOIN users U ON U.uid = mzp.uid WHERE mzp.gid = '6052493'
AND mzp.state = 3
AND U.gesperrt = 0 AND U.validiert = 0
Called from: Tilllate_Event->getAttendeesCount()
Affected rows: 1 Database ID: default Master: no |
| 1.29ms |
SELECT f1.uid AS u1, f2.uid AS u2, f1.name AS n1, f2.name AS n2
FROM (f_bilder LEFT JOIN fotografen AS f1 ON f_bilder.mid = f1.mid)
LEFT JOIN fotografen AS f2 ON f_bilder.mid2 = f2.mid
WHERE f_bilder.gid = '6052493'
GROUP BY f1.mid ORDER BY f1.name LIMIT 6
Called from: Tilllate_Event->getPhotographers()
Affected rows: 1 Database ID: default Master: no |
| 0.65ms |
SELECT *
FROM users
WHERE uid IN (2089454)
Called from: Tilllate_Event->getPhotographers()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT
id,
gid,
uid,
fid,
comment,
UNIX_TIMESTAMP(ts) AS ts
FROM
partyshouts
WHERE gid = '6052493'
Called from: Tilllate_Event->getPartyshouts()
Affected rows: 0 Database ID: default Master: no |
| 0.29ms |
SELECT rating, count(*) as members
FROM parties_rating
WHERE gid = '6052493'
GROUP BY rating
Called from: Tilllate_Event_Rating->__construct()
Affected rows: 1 Database ID: default Master: no |
| 0.37ms |
SELECT SQL_CALC_FOUND_ROWS g.*
FROM guestbook_entries g
LEFT JOIN users u ON u.uid = g.from_id
WHERE g.type_id = '27'
AND g.to_id = '6052493'
AND g.approved = 'yes'
AND u.uid != 0
ORDER BY g.timestamp DESC LIMIT 0, 4
Called from: Tilllate_Tui_Guestbook_Entry_Query->loadEntries()
Affected rows: 0 Database ID: default Master: no |
| 0.16ms |
SELECT FOUND_ROWS()
Called from: Trevi_Db_PagedQuery->_predictTotalResults()
Affected rows: 1 Database ID: default Master: no |
| 0.18ms |
INSERT DELAYED IGNORE INTO statistik_track (fid, is_party) VALUES (6052493, 1)
Called from: Tilllate_Event_Index_Controller->indexAction()
Affected rows: 1 Database ID: log Master: yes |
| 0.95ms |
SELECT (CASE WHEN news.titel_FR <> '' THEN news.titel_FR WHEN news.titel_EN <> '' THEN news.titel_EN WHEN news.titel <> '' THEN news.titel WHEN news.titel_IT <> '' THEN news.titel_IT WHEN news.titel_ES <> '' THEN news.titel_ES WHEN news.titel_BG <> '' THEN news.titel_BG WHEN news.titel_TR <> '' THEN news.titel_TR WHEN news.titel_NL <> '' THEN news.titel_NL WHEN news.titel_RO <> '' THEN news.titel_RO ELSE '' END) as title, news.url
FROM news
INNER JOIN targetings ON targetings.targeting_id = news.targeting_id
LEFT JOIN targeting_to_language ON targeting_to_language.targeting_id = targetings.targeting_id
LEFT JOIN targeting_to_site ON targeting_to_site.targeting_id = targetings.targeting_id
LEFT JOIN targeting_to_region ON targeting_to_region.targeting_id = targetings.targeting_id
LEFT JOIN targeting_to_group ON targeting_to_group.targeting_id = targetings.targeting_id
INNER JOIN news_to_events nte ON nte.nid = news.nid
WHERE news_type = 'news'
AND IF(targeting_to_language.language_id, targeting_to_language.language_id IN (4), 0)
AND IF(targeting_to_group.group_id, targeting_to_group.group_id = 51, 1)
AND IF(targetings.date_from, targetings.date_from <='2010-09-03', 1) AND IF(targetings.date_to, targetings.date_to >= '2010-09-03', 1) AND news.enabled = 1
AND news.redesign = "yes"
AND news.deleted = "no"
AND nte.gid = '6052493'
UNION
SELECT (CASE WHEN news.titel_FR <> '' THEN news.titel_FR WHEN news.titel_EN <> '' THEN news.titel_EN WHEN news.titel <> '' THEN news.titel WHEN news.titel_IT <> '' THEN news.titel_IT WHEN news.titel_ES <> '' THEN news.titel_ES WHEN news.titel_BG <> '' THEN news.titel_BG WHEN news.titel_TR <> '' THEN news.titel_TR WHEN news.titel_NL <> '' THEN news.titel_NL WHEN news.titel_RO <> '' THEN news.titel_RO ELSE '' END) as title, news.url
FROM news
INNER JOIN targetings ON targetings.targeting_id = news.targeting_id
LEFT JOIN targeting_to_language ON targeting_to_language.targeting_id = targetings.targeting_id
LEFT JOIN targeting_to_site ON targeting_to_site.targeting_id = targetings.targeting_id
LEFT JOIN targeting_to_region ON targeting_to_region.targeting_id = targetings.targeting_id
LEFT JOIN targeting_to_group ON targeting_to_group.targeting_id = targetings.targeting_id
INNER JOIN news_to_partygroups ntp ON ntp.nid = news.nid
INNER JOIN party_zu_partygruppen pzp ON pzp.pgid = ntp.pgid
WHERE news_type = "news"
AND IF(targeting_to_language.language_id, targeting_to_language.language_id IN (4), 0)
AND IF(targeting_to_group.group_id, targeting_to_group.group_id = 51, 1)
AND IF(targetings.date_from, targetings.date_from <='2010-09-03', 1) AND IF(targetings.date_to, targetings.date_to >= '2010-09-03', 1) AND news.enabled = 1
AND news.redesign = "yes"
AND news.deleted = "no"
AND pzp.gid = '6052493'
Called from: Tilllate_News_Query->loadNewsByEventId()
Affected rows: 0 Database ID: default Master: no |
| 0.31ms |
SELECT * FROM regionen WHERE `rid`='11' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.37ms |
SELECT r.rid,r.site_id, s.site_shortdomain FROM regionen r INNER JOIN sites s ON s.site_id = r.site_id;
Called from: Tilllate_Region_Query->getRegionToSiteArray()
Affected rows: 333 Database ID: default Master: no |
| 0.95ms |
SELECT pgid, homepage, titel_oeffentlich_verbergen, (CASE WHEN name_FR <> '' THEN name_FR WHEN name_EN <> '' THEN name_EN WHEN name <> '' THEN name WHEN name_IT <> '' THEN name_IT WHEN name_ES <> '' THEN name_ES WHEN name_BG <> '' THEN name_BG WHEN name_TR <> '' THEN name_TR WHEN name_NL <> '' THEN name_NL WHEN name_RO <> '' THEN name_RO ELSE '' END) AS name,
is_business_tl, (CASE WHEN special_html_FR <> '' THEN special_html_FR WHEN special_html_EN <> '' THEN special_html_EN WHEN special_html <> '' THEN special_html WHEN special_html_IT <> '' THEN special_html_IT WHEN special_html_ES <> '' THEN special_html_ES WHEN special_html_BG <> '' THEN special_html_BG WHEN special_html_TR <> '' THEN special_html_TR WHEN special_html_NL <> '' THEN special_html_NL WHEN special_html_RO <> '' THEN special_html_RO ELSE '' END) AS special_html, ad_in_pic_verbergen, hide_events_from_other
FROM partygruppen INNER JOIN party_zu_partygruppen USING(pgid)
WHERE gid = '6052493'
Called from: Tilllate_Event->getSpecials()
Affected rows: 1 Database ID: default Master: no |
| 2.12ms |
SELECT * FROM fotografen WHERE `uid`='2089454' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.49ms |
SELECT min(UNIX_TIMESTAMP(fr.datum)) AS photographerSince, count(DISTINCT fr.gid) as numberOfReports,
SUM(anz_fotos) as numberOfPhotos,
SUM(anz_zugriffe) as generatedViews
FROM fotografen_report fr
WHERE fr.mid='10089'
Called from: Tilllate_User->getPhotographerReport()
Affected rows: 1 Database ID: default Master: no |
| 8.71ms |
SELECT * FROM fbconnect_users WHERE `uid`='2089454' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Database ID: default Master: no |
| 0.36ms |
SELECT directory, filename_small, filename_big, mogilefs_hash_small, mogilefs_hash_big
FROM member_passfotos WHERE uid = '2089454'
Called from: Tilllate_User->getMemberPhotoData()
Affected rows: 1 Database ID: default Master: no |
| 0.26ms |
SELECT * FROM fotografen_status WHERE `id`='6' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.77ms |
SELECT * FROM parties_rating WHERE `uid`='-1' AND `gid`='6052493' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 0 Database ID: default Master: no |
| 0.52ms |
SELECT
ms.*,
msg.link_ms
FROM pa_musikstil ms
INNER JOIN musikstil_zu_party mzp ON ms.msid=mzp.msid
LEFT JOIN pa_musikstilgruppen msg ON ms.msgid=msg.msgid
WHERE mzp.gid='6052493'
Called from: Tilllate_Event->getMusicStyles()
Affected rows: 2 Database ID: default Master: no |
| 0.26ms |
SELECT
ms.*,
msg.link_ms
FROM pa_musikstil ms
INNER JOIN musikstil_zu_party mzp ON ms.msid=mzp.msid
LEFT JOIN pa_musikstilgruppen msg ON ms.msgid=msg.msgid
WHERE mzp.gid='6052493'
Called from: Tilllate_Event->getMusicStyles()
Affected rows: 2 Database ID: default Master: no |
| 0.77ms |
SELECT o.orgid,
p.djs,
o.approved_status,
o.organisation_clean,
o.organisation_clean_postfix,
o.organisation,
o.org_type
FROM parties_to_organisatoren pto
LEFT JOIN organisatoren o ON o.orgid = pto.orgid
LEFT JOIN parties p ON p.gid = pto.gid
WHERE pto.gid='6052493' AND pto.orgid > 0 AND pto.parties_to_organisatoren_role_id = 2
LIMIT '200'
Called from: include()
Affected rows: 4 Database ID: default Master: no |
| 0.36ms |
SELECT * FROM regionen WHERE `rid`='6' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='4' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='8' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.32ms |
SELECT * FROM regionen WHERE `rid`='3' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='113' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='9' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.31ms |
SELECT * FROM regionen WHERE `rid`='114' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='5' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.32ms |
SELECT * FROM regionen WHERE `rid`='7' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='10' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.31ms |
SELECT * FROM regionen WHERE `rid`='112' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='11' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.30ms |
SELECT * FROM regionen WHERE `rid`='1' AND `aktiv`='1' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.79ms |
SELECT * FROM parties WHERE `gid`='6052493' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 3.24ms |
SELECT
a.id,
a.subject_uid,
at.name,
a.params,
UNIX_TIMESTAMP(ts) AS date
FROM activities a
LEFT JOIN activities_types at ON at.id=a.activity_id
WHERE a.site_id = '1'
AND (relGid = 6052493)
ORDER BY ts DESC
LIMIT '40'
Called from: Tilllate_Activity::fetchItems()
Affected rows: 0 Database ID: default Master: no |
| 0.73ms |
SELECT * FROM locations WHERE `lid`='1832' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 0.20ms |
SELECT O.organisation, O.orgid, O.organisation_clean, O.organisation_clean_postfix
FROM organisatoren O, parties_to_organisatoren PTO, org_type OT
WHERE O.orgid = PTO.orgid AND O.org_type = OT.id
AND PTO.parties_to_organisatoren_role_id = '1'
AND PTO.gid = '6052493' AND OT.org_type_group_id = '1'
ORDER BY O.organisation
Called from: Tilllate_Event->getPromoters()
Affected rows: 2 Database ID: default Master: no |
| 0.57ms |
SELECT * FROM organisatoren WHERE `orgid`='32329' LIMIT 1
Called from: Trevi_Db_Row->_loadByQuery()
Affected rows: 1 Database ID: default Master: no |
| 4.15ms |
SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*, UNIX_TIMESTAMP(p.datum) as ts
FROM parties_to_organisatoren pto
INNER JOIN parties p ON p.gid = pto.gid
WHERE pto.orgid = '32329'
AND p.datum >= '2010-09-03'
AND p.geloescht = '0'
AND p.non_party = '0'
AND p.existiert_fotos = '0'
AND pto.parties_to_organisatoren_role_id = '1'
AND p.gid != '24495'
AND p.invisible = 0
GROUP BY p.gid
ORDER BY p.datum ASC LIMIT 0, 1
Called from: Tilllate_Organizer->getEvents()
Affected rows: 1 Database ID: default Master: no |
| 3.40ms |
SELECT FOUND_ROWS()
Called from: Trevi_Db_PagedQuery->_predictTotalResults()
Affected rows: 1 Database ID: default Master: no |
