• Home
• News
• Catalog
• Artists
  • Awa 97
  • Tatiana Miath
• Top Videos
  • Ou T Konnet
  • De Tout Mon Coeur
  • Pousse Mon Son
  • O Soleil
• Store
• Contacts

JoomFish debug (new): reference_table=content id IN(79) language=english class=stdClass Tatiana MIATH - Ou T Konnet   < Prev [ Back ]

Main Menu Home News Catalog Artists Top Videos Ou T Konnet De Tout Mon Coeur Pousse Mon Son O Soleil Store Contacts

music lyrics| music | free music downloads | free music | gospel music lyrics | music videos | rap | rap music lyrics | rap music | people search | people magazine | people | free people saerch | tatiana miath | awa 97 | Copyright © 2008 Experts Consulting - devis creation site web - devis creation site internet

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'sefpatch'
 ORDER BY ordering
3
SELECT file, title FROM jos_sefexts WHERE title != ''
4
SELECT l.value AS title, s.file AS file FROM jos_jf_content AS l INNER JOIN jos_sefexts AS s ON s.id = l.reference_id WHERE l.reference_table = 'sefexts' AND l.reference_field = 'title' AND l.published > 0
5
SELECT name, link, id FROM jos_menu WHERE published > 0 AND link LIKE 'index.php?option=com_%'
6
SELECT l.value AS name, m.link AS link, m.id as id FROM jos_jf_content AS l INNER JOIN jos_menu AS m ON m.id = l.reference_id WHERE l.reference_table = 'menu' AND l.reference_field = 'name' AND l.published > 0 AND m.published > 0 AND m.link LIKE 'index.php?option=com_%'
7
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&id=79&lang=en&task=view'
8
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 90 )
 ORDER BY menuid DESC
LIMIT 1
9
DELETE FROM jos_session
 WHERE (
 ( time < '1328320405' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328320405' )
 AND guest = 1
 AND userid = 0
 )
10
SELECT *
 FROM jos_session
 WHERE session_id = '0d0f44092c66897834b609712e54c72b'
11
SELECT session_id
 FROM jos_session
 WHERE session_id = 'e843e46e1b5c4e28d540a9fe770dc967'
12
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e843e46e1b5c4e28d540a9fe770dc967','1328321305','','0','1' )
13
SELECT params
 FROM jos_mambots
 WHERE element = 'jfdatabase.systembot'
 AND folder = 'system'
14
SELECT * FROM jos_languages WHERE shortcode='en'
15
SELECT * FROM jos_languages WHERE iso='en'
16
SELECT joomlatablename,tablepkID FROM `jos_jf_tableinfo`
17
SELECT * FROM jos_languages ORDER BY ordering
18
SELECT *
 FROM jos_menu
 WHERE id = 90
19
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 79 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-03 20:08' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-03 20:08' )
 AND a.access <= 0
20
SELECT joomlatablename,tablepkID FROM `jos_jf_tableinfo`
21
SELECT * from jos_languages
22
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value 
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
	AND jf_content.published=1
   AND jf_content.reference_id IN(79)
   AND jf_content.reference_table='content'
23
SELECT a.id
 FROM jos_content AS a
 WHERE a.catid = 23
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-03 20:08' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-03 20:08' )
 ORDER BY a.ordering
24
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '79'
25
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
26
SELECT id FROM jos_mambots WHERE element = 'analytics' AND folder = 'content'
27
SELECT *
 FROM jos_mambots
 WHERE id = '37'
28
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
29
SELECT *
 FROM jos_mambots
 WHERE id = '39'
30
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
31
SELECT *
 FROM jos_mambots
 WHERE id = '39'
32
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
33
SELECT *
 FROM jos_mambots
 WHERE id = '39'
34
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
35
SELECT *
 FROM jos_mambots
 WHERE id = '39'
36
SELECT id FROM jos_mambots WHERE element = 'JoomSEO' AND folder = 'content'
37
SELECT *
 FROM jos_mambots
 WHERE id = '27'
38
SELECT * from jos_menu WHERE menutype = 'mainmenu' AND published = '1' ORDER BY ordering LIMIT 1
39
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
40
SELECT code FROM jos_languages WHERE active=1 AND iso='en' ORDER BY ordering
41
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_content.xml'
42
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
43
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 90 )
 ORDER BY ordering
44
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-03 20:08' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-03 20:08' )
 AND ( a.catid=17 )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
45
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
46
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
47
SELECT *
 FROM jos_mambots
 WHERE id = '39'
48
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
49
SELECT *
 FROM jos_mambots
 WHERE id = '39'
50
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
51
SELECT *
 FROM jos_mambots
 WHERE id = '39'
52
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
53
SELECT *
 FROM jos_mambots
 WHERE id = '39'
54
SELECT m.*, count(p.parent) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1'
GROUP BY m.id ORDER BY m.parent, m.ordering
55
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
56
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
57
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
58
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
59
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
60
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
61
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
62
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
63
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
64
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
65
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
66
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
67
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
68
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_virtuemart.xml'
69
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
70
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_contact.xml'
71
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
72
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
73
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=55'
74
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
75
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
76
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
77
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
78
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
79
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
80
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=79'
81
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
82
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=80'
83
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
84
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=81'
85
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
86
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=82'
87
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
88
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering
89
SELECT iso FROM jos_languages WHERE active=1 and code = 'english' ORDER BY ordering