Radnim danom slavimo svete mise u 7.30 u župnoj crkvi u Sivši. Svete mise nedjeljom: u Sivši u 8 i 11 sati; u Omanjskoj u 9.30; u Blaževcima u 10; u Alibegovcima u 11.30 sati.
Iz Matice krštenih za 2019. godinu:
12. 08. 09. 2018.: Petra Matošević, kći Ivana Matoševića i Dajane r. Glamatović.
10. 04. 08. 2018.: Anđelko Sučić, sin Ivice Sučića i Gordane r. Balaton.
9. 21. 07. 2018.: Emili Ćosić, kći Nenada Ćosića i Mateje r. Bratić.
8. 29. 04. 2018.: Lana Martinović, kći Danijela Martinovića i Marijane r. Čupić.
7. 28. 04. 2018.: Matej Grgić, sin Ivana Grgića i Antonije r. Krajina.
6. 02. 04. 2018.: Manuel Katić, sin Marka Katića i Kristine r. Vidić.
5. 31. 03. 2018.: Tea Baštijanović, kći Danijela Baštijanovića i Irene r. Duvnjak.
4. 31. 03. 2018.: Franjo Filipović, sin Ante Filipovića i Ivane r. Matošević.
3. 31. 03. 2018.: Antonela Filipović, kći Ante Filipovića i Ivane r. Matošević.
2. 06. 01. 2018.: Lucia Risonjić, kći Luke Risonjića i Josipe r. Suvala.
1. 03. 01. 2018.: Leon Labudović, sin Žarka Labudovića i Marine r. Šumić.
Nedavno su u Gospodinu preminuli:
Srpanj:
35. Ruža Tokić rođ. Bejić (Omanjska, 1941.), umrla 1.7.2019.; sahranjena 3.7.2019.; Sivša.
Lipanj: (8)
34. Anđa Petrović rođ. Jelić (Alibegovci, 1943.), umrla 30.6.2019.; sahranjena 2.7.2019.; Sivša.
33. Pejo Augustinović Matin (Piljužići, 1943.), umro 25.6.2019.; sahranjen 27.6.2019.; Bobare.
32. Manda Glavaš Nike (Bobare, 1951.), umrla 19.6.2019.; sahranjena 26.6.2019.; Bobare.
31. Janja Topalović rođ. Gavran (Ularice, 1935.), umrla 21.6.2019.; sahranjena 24.6.2019.; Sivša.
30. Slavojka Čagalj rođ. Đurić (Tekućica-Doboj, 1957.), umrla 15.6.2019.; sahranjena 17.6.2019.; Alibegovci.
29. Mijo Grgić Ivanov (Sivša, 1951.), umro 12.6.2019.; sahranjen 14.6.2019.; Sivša.
28. Kristina Bonić rođ. Rajkovača (Ularice, 1947.), umrla 12.6.2019.; sahranjena 13.6.2019.; Sivša.
27. Kata Bonić rođ. Mišković (Sivša, 1951.), umrla 6.6.2019.; sahranjena 12.6. 2019.; Sivša.
Svibanj: (3)
26. Neža Nikić rođ. Bezjak (Kicar - Slovenija, 1940.), umrla 29. 5. 2019.; sahranjena 31. 5. 2019.; Sivša.
25. Andrija Bilonić Marjana (Lončari, 1951.), umro 26. 5. 2019.; sahranjen 28. 5. 2019.; Komin.
24. Nikola Kutlić Ilije (Sivša, 1959.), umro 8. 5. 2019.; sahranjen 10. 5. 2019.; Sivša.
Travanj: (7)
23. Iva Brnadić rođ. Petrović (Alibegovci, 1939.), umrla 16. 4. 2019.; sahranjena 17. 4. 2019.; Alibegovci.
22. Anto Topalović Ante - Tunje (Sivša, 1939.), umro 15. 4. 2019.; sahranjen 16. 4. 2019.; Sivša.
21. Manda Dadić rođ. Ćosić (Sivša, 1940.), umrla 12. 4. 2019.; sahranjena 14. 4. 2019.; Sivša.
20. Franjo Jurić Mijin (Stanovi - Doboj, 1971.), umro 7. 4. 2019.; sahranjen 10. 4. 2019.; Alibegovci.
19. Marjan Pauković Ivin (Alibegovci, 1940.), umro 8. 4. 2019.; sahranjen 9. 4. 2019.; Alibegovci.
18. Mara Duvnjak rođ. Bilkić (Blaževci, 1935.), umrla 6. 4. 2019.; sahranjena 8. 4. 2019.; Bobare.
17. Pavo Barukčić Ilijin (Sivša, 1969.), umro 5. 4. 2019.; sahranjen 7. 4. 2019.; Sivša.
Ožujak: (3)
16. Pavo Baštijanović Ivanov (Sivša, 1938.), umro 26. 3 2019.; sahranjen 28. 3. 2019.; Sivša.
15. Ivan Risonjić Stipin (Omanjska, 1936.), umro 22. 3. 2019.; sahranjen 24. 3. 2019.; Sivša.
14. Mara Dugajić rođ. Duvnjak (Vrela, 1929.), umrla 8. 3. 2019.; sahranjena 11. 3. 2019.; Bobare.
Veljača: (6)
13. Ana-Josipa Zovko rođ. Duvnjak (Vrela, 1942.), umrla 27. 2. 2019.; sahranjena 2. 3. 2019.; Bobare.
12. Janja Marković Jurina (Alibegovci, 1936.), umrla 24. 2. 2019., sahranjena 27. 2. 2019.; Ularice.
11. Jozo Svalina Pejin (Omanjska - Netača, 1948.), umro 17. 2. 2019.; sahranjen 21. 2. 2019.; Sivša.
10. Mijo - Mijat Kulaš Ivanov (Sivša, 1956.), umro 13. 2. 2019., sahranjen 16. 2. 2019.; Sivša.
9. Željko Kikić Pavin (Omanjska, 1965.), umro 4. 2. 2019., sahranjen 6. 2. 2019.; Sivša.
8. Ivica Mandić Jurin (Lončari, 1948.), umro 3. 2. 2019., sahranjen 5. 2. 2019.; Lončari-Komin.
Siječanj: (7)
7. Zoran Crnogorac Stipin (Piljužići, 1966.), umro 24. 1. 2019., sahranjen 29. 1. 2019.; Bobare.
6. Mijo Mandir Antin (Sivša, 1940.), umro 24. 1. 2019., sahranjen 26. 1. 2019.; Sivša.
5. Ruža Jularić rođ. Risonjić (Omanjska, 1939.), umrla 15. 1. 2019., sahranjena 17. 1. 2019.; Sivša.
4. Anto Čupić Ivanov (Sivša, 1937.), umro 13. 1. 2019., sahranjen 16. 1. 2019.; Sivša.
3. Filip Mandir Ivin (Sivša, 1933.), umro 11. 1. 2019., sahranjen 12. 1. 2019., Sivša.
2. Mara Prakljačić rođ. Tokić (Omanjska, 1933.), umrla 6. 1. 2019., sahranjena 8. 1. 2019., Alibegovci.
1. Ljubica Grujo rođ. Bošnjak (Omanjska, 1949.), umrla 4. 1. 2019., sahranjena 6. 1. 2019., Sivša.
Prosinac (6)
54. Pejo Mandir Matin (Sivša, 1948.), umro 23. 12. 2018.; sahrana 25. 12. 2018.; Sivša
53. Janja Katić rođ. Ćosić (Sivša, 1936.), umrla 19. 12. 2018.; sahranjena 22. 12. 2018.; Sivša.
52. Ilija Zovko Matin (Piljužići, 1939.), umro 19. 12. 2018.; sahranjen 22. 12. 2018.; Bobare.
51. Kata Pranjić rođ. Kikić (Omanjska, 1945.), umrla 18. 12. 2018.; sahranjena 22. 12. 2018.; Sivša.
50. Ivan Blažević Andrije (Omanjska 1964.), umro 09. 12. 2018.; sahranjen 12. 12. 2018.; Sivša.
49. Kata Glavaš rođ. Katić (Omanjska 1958.), umrla 04. 12. 2018.; sahranjena 06. 12. 2018.; Bobare.
Studeni (4)
48. Mijo - Mile Nikić Ilijin (Sivša, 1942.), umro 27. 11. 2018.; sahranjen 29. 11. 2018.; Sivša.
47. Mara Martinović rođ. Dadić (Sivša, 1925.), umrla 14. 11. 2018.; sahranjena 17. 11. 2018.; Sivša.
46. Ana Katić rođ. Dadić (Sivša, 1931.), umrla 14. 11. 2018.; sahranjena 16. 11. 2018.; Sivša.
45. Gordana Zovko rođ. Adžaga (Omanjska, 1972.), umrla 06. 11. 2018.; sahranjena 08. 11. 2018.; Bobare.
Listopad (3)
44. Doma Bonić r. Matić (Alibegovci, 1939.), umrla 21. 10. 2018.; sahranjena 23. 10. 2018.; Sivša;
43. Ivan Jelić Ivin (Alibegovci, 1944.), umro 19. 10. 2018., sahranjen 22. 10. 2018.; Alibegovci;
42. Marijan Čupić Jurin (Omanjska, 1939.), umro 05. 10. 2018.; sahranjen 07. 10. 2018.; Sivša;
Rujan (6)
41. Jozo Matić Petrov (Alibegovci, 1946.), umro 28. 09. 2018.; sahranjen 30. 09. 2018.; Sivša;
40. Nikola Blažević Ilijin (Omanjska, 1935.), umro 27. 09. 2018.; sahranjen 29. 09. 2018.; Sivša;
39. Juro Čupić Matin (Omanjska, 1950.), umro 23. 09. 2018.; sahranjen 26. 09. 2018.; Sivša;
38. Janja Bilkić r. Križanović (Cerovac, 1943.), umrla 13. 09. 2018.; sahranjena 15. 09. 2018.; Bobare;
37. Stipo Artmagić Markov (Sivša, 1957.), umro 08. 09. 2018.; sahranjen 10. 09. 2018.; Sivša;
36. Mara Kikić r. Gavran (Ularice, 1935.), umrla 01. 09. 2018.; sahranjena 03. 09. 2018.; Sivša;
Kolovoz
35. Anđa Ivić r. Martinović (Omanjska, 1940.), umrla 22. 08. 2018.; sahranjena 25. 08. 018.; Sivša;
34. Ivan Marković Jurin (Alibegovci, 1942.), umro 11. 08. 2018.; sahranjen 14. 08. 2018.; Alibegovci;
Srpanj (10)
33. Anka Gavrić r. Brnadić (Alibegovci, 1935.), umrla 28. 07. 2018.; sahranjena 31. 07. 2018.; Alibegovci;
32. Ivka Varivoda r. Kovčić (Makljenovac, 1937.), umrla 26. 07. 2018.; sahranjena 29. 07. 2018.; Komin (Lončari);
31. Janja Jelić r. Petrović (Omanjska, 1941.), umrla 26. 07. 2018.; sahranjena 28. 07. 2018.; Sivša;
30. Janja Gašić r. Kopčić (Makljenovac, 1933.), umrla 23. 07. 2018.; sahranjena 25. 07. 2018.; Sivša;
29. Ana Joskić r. Marcikić (Jaruge, 1947.), umrla 20. 07. 2018.; sahranjena 25. 07. 2018.; Alibegovci;
28. Pejo Bonić Anin (Sivša, 1949.), umro 20. 07. 2018.; sahranjen 22. 07. 2018.; Sivša;
27. Perica Martinović Marijanov (Blaževci, 1978.,), umro 18. 07. 2018.; sahranjen 21. 07. 2018.; Bobare;
26. Anto Kulaš Ivin (Sivša, 1960.), umro 15. 07. 2018., sahranjen 18. 07. 2018.; Sivša;
25. Marta Krajina r. Blažević (Omanjska, 1941.), umrla 12. 07. 2018., sahranjena 14. 07. 2018.; Sivša;
24. Nedeljko Pranjić Jurin (Omanjska, 1944.), umro 04. 07. 2018., sahranjen 07. 07. 2018., Sivša;
Lipanj (2)
23. Ana Petrović r. Domazet (Ularice, 1930.), umrla 08. 06. 2018., sahranjena 11. 06. 2018., Alibegovci;
22. Anto Varenica Nikolin (Alibegovci, 1944.), umro 31. 05. 2018., sahranjen 02.06. 2018., Alibegovci;
Svibanj (5)
21. Ilija Ćosić Ivanov (Sivša, 1939.), umro 27. 05. 2018., sahranjen 29. 05. 2018., Sivša;
20. Pranja Risonjić r. Tokić (1934.), umrla 24. 05. 2018., sahranjena 27. 05. 2018., Sivša;
19. Dominik Tokić Matin (Omanjska, 1946.), umro 21. 05. 2018., sahranjen 22. 05. 2018., Sivša;
18. Mijo Džido Petrov (Miljanovci, 1946.), umro 03. 05. 2018., sahranjen 05. 05. 2018., Sivša;
17. Jozo Zovko Andrin (Piljužići, 1966.), umro 30. 04. 2018., sahranjen 04. 05. 2018., Bobare-Blaževci;
Travanj (5)
15. Ivica Tokić Franjin (Sr. Omanjska, 1958.), umro 21. 04. 2018., sahranjen 22. 04. 2018., Sivša;
14. Marta Pranjić Ivanova (Omanjska, 1940.), umrla 16. 04. 2018., sahranjena 19. 04. 2018., Sivša;
13. Marko Gavrić Ilijin (Sivša, 1952.), umro 09. 04. 2018., sahranjen 11. 04. 2018., Sivša;
12. Mato Katić Markov (Omanjska-Netača, 1939.), umro 08. 04. 2018., sahrana 10. 04. 2018., Sivša;
Veljača (6)
9. Mara Blažević r. Dadić (Sivša, 1944.), umrla 17.02.2018., sahranjena 19. 02. 2018., Sivša;
8. Mara Čupić r. Kikić (Omanjska, 1945.), umrla 15. 02. 2018., sahranjena 18. 02. 2018., Sivša;
7. Mato Varivoda Jurin (Lončari, 1944.), umro 10. 02. 2018., sahranjen 12. 02. 2018., Lončar-Komin;
6. Juro Kulaš Marijanov (Sivša, 1952.), umro 08. 02. 2018., sahranjen 10. 02. 2018., Sivša;
5. Stipo Glavaš Ivanov (Bobare, 1937.), umro 01. 02. 2018., sahranjen 03. 02. 2018., Bobare;
4. Jozo Lujić Matin (Alibegovci, 1948.), umro 31. 01. 2018., sahranjen 2. 02. 2018., Alibegovci;
Siječanj (3)
3. Kata Martinović r. Matošević (Omanjska, 1953.), umrla 19. 01. 2018., sahranjena 21. 01. 2018., Bobare;
2. Ana Zovko r. Glavaš (Blaževci, 1939.), umrla 17. 01. 2018., sahranjena 19. 01. 2018., Bobare;
1. Manda Filipović r. Jeleč (Miljanovci, 1931.), umrla 01. 01. 2018., sahranjena 02. 01. 2018., Lončari-Komin;
ŽUPA SV. ANTE PADOVANSKOG SIVŠA
74230 USORA
Tel/fax: +38732/893-144
session.counter ⇒ 1
session.timer.start ⇒ 1730982565
session.timer.last ⇒ 1730982565
session.timer.now ⇒ 1730982565
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
registry ⇒ {}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒
guest ⇒ 1
lastResetTime ⇒
resetCount ⇒
aid ⇒ 0
Application 0.002 seconds (+0.002); 0.59 MB (+0.588) - afterLoad
Application 0.138 seconds (+0.135); 3.61 MB (+3.025) - afterInitialise
Application 0.159 seconds (+0.022); 4.36 MB (+0.750) - afterRoute
Application 0.393 seconds (+0.234); 7.50 MB (+3.134) - afterDispatch
Application 0.413 seconds (+0.020); 7.92 MB (+0.420) - beforeRenderModule mod_custom (footer)
Application 0.440 seconds (+0.027); 7.94 MB (+0.026) - afterRenderModule mod_custom (footer)
Application 0.440 seconds (+0.000); 7.95 MB (+0.003) - beforeRenderModule mod_acymailing (Primajte obavijesti)
Application 0.479 seconds (+0.039); 8.78 MB (+0.834) - afterRenderModule mod_acymailing (Primajte obavijesti)
Application 0.479 seconds (+0.000); 8.76 MB (-0.025) - beforeRenderModule mod_articles_latest (Posljednje objavljeno)
Application 0.540 seconds (+0.060); 8.95 MB (+0.190) - afterRenderModule mod_articles_latest (Posljednje objavljeno)
Application 0.540 seconds (+0.000); 8.81 MB (-0.132) - beforeRenderModule mod_custom (Kontakt)
Application 0.546 seconds (+0.006); 8.84 MB (+0.026) - afterRenderModule mod_custom (Kontakt)
Application 0.546 seconds (+0.000); 8.84 MB (+0.002) - beforeRenderModule mod_custom (karta)
Application 0.547 seconds (+0.001); 8.85 MB (+0.005) - afterRenderModule mod_custom (karta)
Application 0.548 seconds (+0.000); 8.85 MB (-0.001) - beforeRenderModule mod_search (pretraživanje)
Application 0.566 seconds (+0.018); 8.87 MB (+0.024) - afterRenderModule mod_search (pretraživanje)
Application 0.566 seconds (+0.000); 8.87 MB (-0.003) - beforeRenderModule mod_sptab (Obavijesti)
Application 0.572 seconds (+0.006); 8.97 MB (+0.098) - beforeRenderModule mod_custom (Kršteni)
Application 0.574 seconds (+0.002); 8.97 MB (+0.005) - afterRenderModule mod_custom (Kršteni)
Application 0.576 seconds (+0.002); 8.99 MB (+0.019) - beforeRenderModule mod_custom (Preminuli)
Application 0.577 seconds (+0.002); 8.99 MB (+0.005) - afterRenderModule mod_custom (Preminuli)
Application 0.579 seconds (+0.002); 8.99 MB (-0.000) - beforeRenderModule mod_custom (Obavijesti)
Application 0.581 seconds (+0.001); 9.00 MB (+0.005) - afterRenderModule mod_custom (Obavijesti)
Application 0.581 seconds (+0.001); 8.98 MB (-0.018) - afterRenderModule mod_sptab (Obavijesti)
Application 0.582 seconds (+0.000); 8.96 MB (-0.019) - beforeRenderModule mod_custom (video)
Application 0.587 seconds (+0.005); 9.06 MB (+0.100) - afterRenderModule mod_custom (video)
Application 0.587 seconds (+0.000); 9.06 MB (-0.003) - beforeRenderModule mod_custom (Svjetlo riječi)
Application 0.588 seconds (+0.001); 9.06 MB (+0.005) - afterRenderModule mod_custom (Svjetlo riječi)
Application 0.588 seconds (+0.000); 9.06 MB (-0.003) - beforeRenderModule mod_custom (Institut)
Application 0.589 seconds (+0.001); 9.06 MB (+0.005) - afterRenderModule mod_custom (Institut)
Application 0.589 seconds (+0.000); 9.07 MB (+0.001) - beforeRenderModule mod_vvisit_counter (Posjetitelji)
Application 0.602 seconds (+0.012); 9.15 MB (+0.084) - afterRenderModule mod_vvisit_counter (Posjetitelji)
Application 0.602 seconds (+0.000); 9.13 MB (-0.022) - beforeRenderModule mod_breadcrumbs (putanja)
Application 0.644 seconds (+0.042); 9.15 MB (+0.026) - afterRenderModule mod_breadcrumbs (putanja)
Application 0.644 seconds (+0.000); 9.15 MB (-0.005) - beforeRenderModule mod_menu (glavni izbornik)
Application 0.673 seconds (+0.029); 9.30 MB (+0.156) - afterRenderModule mod_menu (glavni izbornik)
Application 0.673 seconds (+0.000); 9.30 MB (-0.007) - beforeRenderModule mod_custom (Logo)
Application 0.675 seconds (+0.001); 9.30 MB (+0.005) - afterRenderModule mod_custom (Logo)
Application 0.684 seconds (+0.009); 9.41 MB (+0.108) - afterRender
9.47 MB (9,931,824 Bytes)
SELECT `data`
FROM `jjyvt_session`
WHERE `session_id` = '5oa02iac7kum9vknk938a46ed5'
DELETE
FROM `jjyvt_session`
WHERE `time` < '1730981665'
SELECT `session_id`
FROM `jjyvt_session`
WHERE `session_id` = '5oa02iac7kum9vknk938a46ed5'
LIMIT 0, 1
INSERT INTO `jjyvt_session`
(`session_id`, `client_id`, `time`)
VALUES
('5oa02iac7kum9vknk938a46ed5', 0, '1730982565')
SELECT extension_id AS id, element AS "option", params, enabled
FROM jjyvt_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM jjyvt_usergroups AS a
LEFT JOIN jjyvt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `jjyvt_viewlevels`
SELECT folder AS type, element AS name, params
FROM jjyvt_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM jjyvt_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT time
FROM jjyvt_vvisit_counter USE INDEX(time)
ORDER BY time DESC
LIMIT 1;
UPDATE jjyvt_vvisit_counter
SET visits=visits+1, bots=bots+1
WHERE time=1730982600;
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 jjyvt_menu AS m
LEFT JOIN jjyvt_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 extension_id AS id, element AS "option", params, enabled
FROM jjyvt_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM jjyvt_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM jjyvt_template_styles as s
LEFT JOIN jjyvt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT a.rules
FROM jjyvt_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM jjyvt_assets AS a
LEFT JOIN jjyvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM jjyvt_categories as c
LEFT JOIN jjyvt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_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
LEFT JOIN `jjyvt_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=23
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 b.rules
FROM jjyvt_assets AS a
LEFT JOIN jjyvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.23' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id 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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jjyvt_content AS a
LEFT JOIN jjyvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jjyvt_categories AS c
ON c.id = a.catid
LEFT JOIN jjyvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jjyvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jjyvt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jjyvt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jjyvt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 23
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-07 12:29:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-07 12:29:25')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY c.lft,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 0, 9
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id 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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jjyvt_content AS a
LEFT JOIN jjyvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jjyvt_categories AS c
ON c.id = a.catid
LEFT JOIN jjyvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jjyvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jjyvt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jjyvt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jjyvt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 23
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-07 12:29:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-07 12:29:25')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY c.lft,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jjyvt_categories as c
LEFT JOIN jjyvt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_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=23
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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jjyvt_modules AS m
LEFT JOIN jjyvt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jjyvt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 164 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM jjyvt_acymailing_config
SELECT *
FROM jjyvt_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id 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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jjyvt_content AS a
LEFT JOIN jjyvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jjyvt_categories AS c
ON c.id = a.catid
LEFT JOIN jjyvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jjyvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jjyvt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jjyvt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jjyvt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_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 a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-07 12:29:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-07 12:29:25')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.created DESC
LIMIT 0, 5
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jjyvt_categories as c
LEFT JOIN jjyvt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_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=15
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 c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jjyvt_categories as c
LEFT JOIN jjyvt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_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=16
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 m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 196
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 196
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 196
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 196
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 195
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 195
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 195
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 195
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 194
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 194
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 194
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
WHERE m.published = 1
AND m.id = 194
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-07 12:29:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-07 12:29:25')
AND m.access IN (1,1)
AND m.client_id = 0
SELECT SUM(visits) AS visits
FROM jjyvt_vvisit_counter
WHERE '1=1'
AND time > 1730937600
SELECT extension_id AS id, element AS "option", params, enabled
FROM jjyvt_extensions
WHERE `type` = 'component'
AND `element` = 'com_weblinks'
UPDATE `jjyvt_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1730982565;s:18:\"session.timer.last\";i:1730982565;s:17:\"session.timer.now\";i:1730982565;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;}}'
, `time` = '1730982566'
WHERE `session_id` = '5oa02iac7kum9vknk938a46ed5'
12 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM jjyvt_modules AS m
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jjyvt_extensions
3 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id 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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jjyvt_content AS a
LEFT JOIN jjyvt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jjyvt_categories AS c
ON c.id = a.catid
LEFT JOIN jjyvt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jjyvt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jjyvt_contact_details AS contact
3 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jjyvt_categories as c
LEFT JOIN jjyvt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT b.rules
FROM jjyvt_assets AS a
LEFT JOIN jjyvt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM jjyvt_categories as c
LEFT JOIN jjyvt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jjyvt_categories AS cat JOIN jjyvt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM jjyvt_acymailing_list
1 × SELECT SUM(visits) AS visits
FROM jjyvt_vvisit_counter
1 × SELECT *
FROM jjyvt_acymailing_confi
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jjyvt_modules AS m
LEFT JOIN jjyvt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jjyvt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id, home, template, s.params
FROM jjyvt_template_styles as s
LEFT JOIN jjyvt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT id, rules
FROM `jjyvt_viewlevels
1 × SELECT b.id
FROM jjyvt_usergroups AS a
LEFT JOIN jjyvt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `jjyvt_session`
1 × SELECT folder AS type, element AS name, params
FROM jjyvt_extensions
1 × SELECT time
FROM jjyvt_vvisit_counter USE INDEX(time)
1 × SELECT `data`
FROM `jjyvt_session`
1 × SELECT *
FROM jjyvt_languages
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 jjyvt_menu AS m
LEFT JOIN jjyvt_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.rules
FROM jjyvt_assets AS a
1 × UPDATE `jjyvt_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1730982565;s:18:\"session.timer.last\";i:1730982565;s:17:\"session.timer.now\";i:1730982565;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;}}' , `time` = '1730982566'
1 × UPDATE jjyvt_vvisit_counter
SET visits=visits+1, bots=bots+1
1 × INSERT INTO `jjyvt_session` (`session_id`, `client_id`, `time`)
VALUES ('5oa02iac7kum9vknk938a46ed5', 0, '1730982565'
1 × DELETE
FROM `jjyvt_session`