API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 26th, 2017
381
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 53.43 KB | None | 0 0
raw download clone embed print report
  1. 170726 16:42:12   640 Connect   root@localhost as anonymous on
  2.           640 Query SET @@SESSION.sql_mode = ''
  3.           640 Init DB   sjkdfh
  4.           640 Query SET NAMES utf8mb4
  5.           640 Query SELECT `data`
  6. FROM `josa9_session`
  7. WHERE `session_id` = 'l1dc4gjqv45lpc37use57samp1'
  8.           640 Query SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  9. FROM `josa9_extensions`
  10. WHERE `type` = 'component'
  11.           640 Query SELECT id, rules
  12. FROM `josa9_viewlevels`
  13.           640 Query SELECT b.id
  14. FROM josa9_usergroups AS a
  15. LEFT JOIN josa9_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  16. WHERE a.id = 9
  17.           640 Query SELECT `folder` AS `type`,`element` AS `name`,`params`
  18. FROM josa9_extensions
  19. WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
  20. ORDER BY ordering
  21.           640 Query 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
  22. FROM josa9_menu AS m
  23. LEFT JOIN josa9_extensions AS e ON m.component_id = e.extension_id
  24. WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
  25. ORDER BY m.lft
  26.           640 Query SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  27. FROM `josa9_extensions`
  28. WHERE `type` = 'library' AND `element` = 'joomla'
  29.           640 Query SELECT *
  30. FROM josa9_languages
  31. WHERE published=1
  32. ORDER BY ordering ASC
  33.           640 Query SELECT id, home, template, s.params
  34. FROM josa9_template_styles as s
  35. LEFT JOIN josa9_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  36. WHERE s.client_id = 0 AND e.enabled = 1
  37.           640 Query SELECT `id`,`name`,`rules`,`parent_id`
  38. FROM `josa9_assets`
  39. WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_fields','com_finder','com_helloworld','com_imageshow','com_installer','com_jce','com_jhackguard','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')
  40.           640 Query SELECT `id`,`name`,`rules`,`parent_id`
  41. FROM `josa9_assets`
  42. WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
  43.           640 Query SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  44.             c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
  45.             c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  46.             c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
  47. FROM josa9_categories as c
  48. LEFT JOIN josa9_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
  49. LEFT JOIN `josa9_content` AS i ON i.`catid` = c.id AND i.state = 1
  50. WHERE (c.extension='com_content' OR c.extension='system') AND c.published = 1 AND s.id=8
  51. GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  52.                  c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
  53.                  c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  54.                  c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
  55. ORDER BY c.lft
  56.           640 Query SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' 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, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
  57.                             COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
  58. FROM josa9_content AS a
  59. LEFT JOIN josa9_categories AS c ON c.id = a.catid
  60. LEFT JOIN josa9_users AS ua ON ua.id = a.created_by
  61. LEFT JOIN josa9_users AS uam ON uam.id = a.modified_by
  62. LEFT JOIN josa9_categories as parent ON parent.id = c.parent_id
  63. LEFT JOIN josa9_content_rating AS v ON a.id = v.content_id
  64. WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND (a.catid = 8 OR a.catid IN (
  65. SELECT sub.id
  66. FROM josa9_categories as sub
  67. INNER JOIN josa9_categories as this ON sub.lft > this.lft AND sub.rgt < this.rgt
  68. WHERE this.id = 8)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-07-26 14:42:12') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-07-26 14:42:12')
  69. ORDER BY  c.lft,  a.title,  a.created   LIMIT 999
  70.           640 Query SELECT COUNT(*)
  71. FROM josa9_content AS a
  72. LEFT JOIN josa9_categories AS c ON c.id = a.catid
  73. LEFT JOIN josa9_users AS ua ON ua.id = a.created_by
  74. LEFT JOIN josa9_users AS uam ON uam.id = a.modified_by
  75. LEFT JOIN josa9_categories as parent ON parent.id = c.parent_id
  76. LEFT JOIN josa9_content_rating AS v ON a.id = v.content_id
  77. WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND (a.catid = 8 OR a.catid IN (
  78. SELECT sub.id
  79. FROM josa9_categories as sub
  80. INNER JOIN josa9_categories as this ON sub.lft > this.lft AND sub.rgt < this.rgt
  81. WHERE this.id = 8)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-07-26 14:42:12') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-07-26 14:42:12')
  82.           640 Query SELECT `m`.`tag_id`,`t`.*
  83. FROM `josa9_contentitem_tag_map` AS m
  84. INNER JOIN `josa9_tags` AS t  ON `m`.`tag_id` = `t`.`id`
  85. WHERE `m`.`type_alias` = 'com_content.category' AND `m`.`content_item_id` = 8 AND `t`.`published` = 1 AND t.access IN (1,1,5)
  86.           640 Query SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
  87.             c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
  88.             c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
  89.             c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  90. FROM josa9_categories as c
  91. LEFT JOIN josa9_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
  92. WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=8
  93. ORDER BY c.lft
  94.           640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  95. FROM josa9_fields AS a
  96. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  97. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  98. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  99. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  100. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  101. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  102. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  103. ORDER BY a.ordering ASC
  104.           640 Query SELECT `field_id`,`value`
  105. FROM `josa9_fields_values`
  106. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '114'
  107. 170726 16:42:13   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  108. FROM josa9_fields AS a
  109. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  110. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  111. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  112. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  113. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  114. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  115. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (9,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  116. ORDER BY a.ordering ASC
  117.           640 Query SELECT `field_id`,`value`
  118. FROM `josa9_fields_values`
  119. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '35'
  120. 170726 16:42:15   640 Query SELECT `field_id`,`value`
  121. FROM `josa9_fields_values`
  122. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '54'
  123. 170726 16:42:16   640 Query SELECT `field_id`,`value`
  124. FROM `josa9_fields_values`
  125. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '34'
  126. 170726 16:42:17   640 Query SELECT `field_id`,`value`
  127. FROM `josa9_fields_values`
  128. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '53'
  129. 170726 16:42:18   640 Query SELECT `field_id`,`value`
  130. FROM `josa9_fields_values`
  131. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '57'
  132. 170726 16:42:19   640 Query SELECT `field_id`,`value`
  133. FROM `josa9_fields_values`
  134. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '45'
  135. 170726 16:42:20   640 Query SELECT `field_id`,`value`
  136. FROM `josa9_fields_values`
  137. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '50'
  138. 170726 16:42:21   640 Query SELECT `field_id`,`value`
  139. FROM `josa9_fields_values`
  140. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '55'
  141. 170726 16:42:22   640 Query SELECT `field_id`,`value`
  142. FROM `josa9_fields_values`
  143. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '90'
  144. 170726 16:42:23   640 Query SELECT `field_id`,`value`
  145. FROM `josa9_fields_values`
  146. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '46'
  147. 170726 16:42:24   640 Query SELECT `field_id`,`value`
  148. FROM `josa9_fields_values`
  149. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '58'
  150. 170726 16:42:25   640 Query SELECT `field_id`,`value`
  151. FROM `josa9_fields_values`
  152. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '52'
  153. 170726 16:42:26   640 Query SELECT `field_id`,`value`
  154. FROM `josa9_fields_values`
  155. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '87'
  156. 170726 16:42:27   640 Query SELECT `field_id`,`value`
  157. FROM `josa9_fields_values`
  158. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '51'
  159. 170726 16:42:29   640 Query SELECT `field_id`,`value`
  160. FROM `josa9_fields_values`
  161. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '48'
  162. 170726 16:42:30   640 Query SELECT `field_id`,`value`
  163. FROM `josa9_fields_values`
  164. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '49'
  165. 170726 16:42:31   640 Query SELECT `field_id`,`value`
  166. FROM `josa9_fields_values`
  167. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '89'
  168. 170726 16:42:32   640 Query SELECT `field_id`,`value`
  169. FROM `josa9_fields_values`
  170. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '86'
  171.           640 Query SELECT `field_id`,`value`
  172. FROM `josa9_fields_values`
  173. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '56'
  174. 170726 16:42:33   640 Query SELECT `field_id`,`value`
  175. FROM `josa9_fields_values`
  176. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '60'
  177. 170726 16:42:34   640 Query SELECT `field_id`,`value`
  178. FROM `josa9_fields_values`
  179. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '85'
  180. 170726 16:42:35   640 Query SELECT `field_id`,`value`
  181. FROM `josa9_fields_values`
  182. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '88'
  183. 170726 16:42:36   640 Query SELECT `field_id`,`value`
  184. FROM `josa9_fields_values`
  185. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '83'
  186. 170726 16:42:37   640 Query SELECT `field_id`,`value`
  187. FROM `josa9_fields_values`
  188. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '84'
  189. 170726 16:42:38   640 Query SELECT `field_id`,`value`
  190. FROM `josa9_fields_values`
  191. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '47'
  192. 170726 16:42:39   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  193. FROM josa9_fields AS a
  194. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  195. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  196. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  197. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  198. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  199. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  200. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (10,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  201. ORDER BY a.ordering ASC
  202.           640 Query SELECT `field_id`,`value`
  203. FROM `josa9_fields_values`
  204. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '76'
  205. 170726 16:42:40   640 Query SELECT `field_id`,`value`
  206. FROM `josa9_fields_values`
  207. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '62'
  208. 170726 16:42:41   640 Query SELECT `field_id`,`value`
  209. FROM `josa9_fields_values`
  210. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '61'
  211. 170726 16:42:42   640 Query SELECT `field_id`,`value`
  212. FROM `josa9_fields_values`
  213. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '63'
  214. 170726 16:42:43   640 Query SELECT `field_id`,`value`
  215. FROM `josa9_fields_values`
  216. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '81'
  217. 170726 16:42:44   640 Query SELECT `field_id`,`value`
  218. FROM `josa9_fields_values`
  219. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '75'
  220. 170726 16:42:45   640 Query SELECT `field_id`,`value`
  221. FROM `josa9_fields_values`
  222. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '80'
  223. 170726 16:42:46   640 Query SELECT `field_id`,`value`
  224. FROM `josa9_fields_values`
  225. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '77'
  226. 170726 16:42:47   640 Query SELECT `field_id`,`value`
  227. FROM `josa9_fields_values`
  228. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '79'
  229. 170726 16:42:48   640 Query SELECT `field_id`,`value`
  230. FROM `josa9_fields_values`
  231. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '78'
  232. 170726 16:42:49   640 Query SELECT `field_id`,`value`
  233. FROM `josa9_fields_values`
  234. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '190'
  235. 170726 16:42:50   640 Query SELECT `field_id`,`value`
  236. FROM `josa9_fields_values`
  237. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '72'
  238. 170726 16:42:51   640 Query SELECT `field_id`,`value`
  239. FROM `josa9_fields_values`
  240. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '66'
  241. 170726 16:42:52   640 Query SELECT `field_id`,`value`
  242. FROM `josa9_fields_values`
  243. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '67'
  244. 170726 16:42:53   640 Query SELECT `field_id`,`value`
  245. FROM `josa9_fields_values`
  246. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '69'
  247. 170726 16:42:54   640 Query SELECT `field_id`,`value`
  248. FROM `josa9_fields_values`
  249. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '68'
  250. 170726 16:42:55   640 Query SELECT `field_id`,`value`
  251. FROM `josa9_fields_values`
  252. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '70'
  253. 170726 16:42:56   640 Query SELECT `field_id`,`value`
  254. FROM `josa9_fields_values`
  255. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '71'
  256. 170726 16:42:57   640 Query SELECT `field_id`,`value`
  257. FROM `josa9_fields_values`
  258. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '65'
  259. 170726 16:42:58   640 Query SELECT `field_id`,`value`
  260. FROM `josa9_fields_values`
  261. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '82'
  262. 170726 16:42:59   640 Query SELECT `field_id`,`value`
  263. FROM `josa9_fields_values`
  264. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '74'
  265. 170726 16:43:00   640 Query SELECT `field_id`,`value`
  266. FROM `josa9_fields_values`
  267. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '64'
  268. 170726 16:43:01   640 Query SELECT `field_id`,`value`
  269. FROM `josa9_fields_values`
  270. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '73'
  271. 170726 16:43:02   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  272. FROM josa9_fields AS a
  273. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  274. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  275. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  276. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  277. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  278. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  279. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (11,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  280. ORDER BY a.ordering ASC
  281.           640 Query SELECT `field_id`,`value`
  282. FROM `josa9_fields_values`
  283. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '142'
  284. 170726 16:43:03   640 Query SELECT `field_id`,`value`
  285. FROM `josa9_fields_values`
  286. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '132'
  287. 170726 16:43:04   640 Query SELECT `field_id`,`value`
  288. FROM `josa9_fields_values`
  289. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '59'
  290. 170726 16:43:05   640 Query SELECT `field_id`,`value`
  291. FROM `josa9_fields_values`
  292. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '133'
  293. 170726 16:43:06   640 Query SELECT `field_id`,`value`
  294. FROM `josa9_fields_values`
  295. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '131'
  296. 170726 16:43:07   640 Query SELECT `field_id`,`value`
  297. FROM `josa9_fields_values`
  298. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '127'
  299. 170726 16:43:08   640 Query SELECT `field_id`,`value`
  300. FROM `josa9_fields_values`
  301. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '126'
  302. 170726 16:43:09   640 Query SELECT `field_id`,`value`
  303. FROM `josa9_fields_values`
  304. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '154'
  305. 170726 16:43:10   640 Query SELECT `field_id`,`value`
  306. FROM `josa9_fields_values`
  307. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '134'
  308. 170726 16:43:11   640 Query SELECT `field_id`,`value`
  309. FROM `josa9_fields_values`
  310. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '128'
  311. 170726 16:43:12   640 Query SELECT `field_id`,`value`
  312. FROM `josa9_fields_values`
  313. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '138'
  314. 170726 16:43:13   640 Query SELECT `field_id`,`value`
  315. FROM `josa9_fields_values`
  316. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '143'
  317.           640 Query SELECT `field_id`,`value`
  318. FROM `josa9_fields_values`
  319. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '141'
  320. 170726 16:43:14   640 Query SELECT `field_id`,`value`
  321. FROM `josa9_fields_values`
  322. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '144'
  323. 170726 16:43:15   640 Query SELECT `field_id`,`value`
  324. FROM `josa9_fields_values`
  325. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '139'
  326. 170726 16:43:16   640 Query SELECT `field_id`,`value`
  327. FROM `josa9_fields_values`
  328. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '137'
  329. 170726 16:43:17   640 Query SELECT `field_id`,`value`
  330. FROM `josa9_fields_values`
  331. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '130'
  332. 170726 16:43:18   640 Query SELECT `field_id`,`value`
  333. FROM `josa9_fields_values`
  334. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '129'
  335. 170726 16:43:19   640 Query SELECT `field_id`,`value`
  336. FROM `josa9_fields_values`
  337. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '135'
  338. 170726 16:43:20   640 Query SELECT `field_id`,`value`
  339. FROM `josa9_fields_values`
  340. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '136'
  341. 170726 16:43:21   640 Query SELECT `field_id`,`value`
  342. FROM `josa9_fields_values`
  343. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '140'
  344. 170726 16:43:22   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  345. FROM josa9_fields AS a
  346. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  347. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  348. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  349. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  350. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  351. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  352. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (12,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  353. ORDER BY a.ordering ASC
  354.           640 Query SELECT `field_id`,`value`
  355. FROM `josa9_fields_values`
  356. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '105'
  357. 170726 16:43:23   640 Query SELECT `field_id`,`value`
  358. FROM `josa9_fields_values`
  359. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '108'
  360. 170726 16:43:24   640 Query SELECT `field_id`,`value`
  361. FROM `josa9_fields_values`
  362. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '120'
  363. 170726 16:43:25   640 Query SELECT `field_id`,`value`
  364. FROM `josa9_fields_values`
  365. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '111'
  366. 170726 16:43:26   640 Query SELECT `field_id`,`value`
  367. FROM `josa9_fields_values`
  368. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '151'
  369. 170726 16:43:27   640 Query SELECT `field_id`,`value`
  370. FROM `josa9_fields_values`
  371. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '152'
  372. 170726 16:43:28   640 Query SELECT `field_id`,`value`
  373. FROM `josa9_fields_values`
  374. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '100'
  375. 170726 16:43:29   640 Query SELECT `field_id`,`value`
  376. FROM `josa9_fields_values`
  377. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '95'
  378. 170726 16:43:30   640 Query SELECT `field_id`,`value`
  379. FROM `josa9_fields_values`
  380. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '149'
  381. 170726 16:43:31   640 Query SELECT `field_id`,`value`
  382. FROM `josa9_fields_values`
  383. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '150'
  384. 170726 16:43:32   640 Query SELECT `field_id`,`value`
  385. FROM `josa9_fields_values`
  386. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '92'
  387. 170726 16:43:33   640 Query SELECT `field_id`,`value`
  388. FROM `josa9_fields_values`
  389. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '91'
  390. 170726 16:43:34   640 Query SELECT `field_id`,`value`
  391. FROM `josa9_fields_values`
  392. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '93'
  393. 170726 16:43:35   640 Query SELECT `field_id`,`value`
  394. FROM `josa9_fields_values`
  395. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '101'
  396. 170726 16:43:36   640 Query SELECT `field_id`,`value`
  397. FROM `josa9_fields_values`
  398. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '102'
  399. 170726 16:43:37   640 Query SELECT `field_id`,`value`
  400. FROM `josa9_fields_values`
  401. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '122'
  402. 170726 16:43:38   640 Query SELECT `field_id`,`value`
  403. FROM `josa9_fields_values`
  404. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '115'
  405. 170726 16:43:39   640 Query SELECT `field_id`,`value`
  406. FROM `josa9_fields_values`
  407. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '113'
  408. 170726 16:43:40   640 Query SELECT `field_id`,`value`
  409. FROM `josa9_fields_values`
  410. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '119'
  411. 170726 16:43:41   640 Query SELECT `field_id`,`value`
  412. FROM `josa9_fields_values`
  413. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '147'
  414. 170726 16:43:42   640 Query SELECT `field_id`,`value`
  415. FROM `josa9_fields_values`
  416. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '116'
  417. 170726 16:43:43   640 Query SELECT `field_id`,`value`
  418. FROM `josa9_fields_values`
  419. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '112'
  420. 170726 16:43:44   640 Query SELECT `field_id`,`value`
  421. FROM `josa9_fields_values`
  422. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '104'
  423. 170726 16:43:45   640 Query SELECT `field_id`,`value`
  424. FROM `josa9_fields_values`
  425. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '107'
  426. 170726 16:43:46   640 Query SELECT `field_id`,`value`
  427. FROM `josa9_fields_values`
  428. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '97'
  429. 170726 16:43:47   640 Query SELECT `field_id`,`value`
  430. FROM `josa9_fields_values`
  431. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '109'
  432. 170726 16:43:48   640 Query SELECT `field_id`,`value`
  433. FROM `josa9_fields_values`
  434. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '94'
  435. 170726 16:43:49   640 Query SELECT `field_id`,`value`
  436. FROM `josa9_fields_values`
  437. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '148'
  438. 170726 16:43:50   640 Query SELECT `field_id`,`value`
  439. FROM `josa9_fields_values`
  440. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '110'
  441. 170726 16:43:51   640 Query SELECT `field_id`,`value`
  442. FROM `josa9_fields_values`
  443. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '106'
  444. 170726 16:43:52   640 Query SELECT `field_id`,`value`
  445. FROM `josa9_fields_values`
  446. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '117'
  447. 170726 16:43:53   640 Query SELECT `field_id`,`value`
  448. FROM `josa9_fields_values`
  449. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '98'
  450. 170726 16:43:54   640 Query SELECT `field_id`,`value`
  451. FROM `josa9_fields_values`
  452. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '118'
  453. 170726 16:43:55   640 Query SELECT `field_id`,`value`
  454. FROM `josa9_fields_values`
  455. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '121'
  456. 170726 16:43:56   640 Query SELECT `field_id`,`value`
  457. FROM `josa9_fields_values`
  458. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '153'
  459. 170726 16:43:57   640 Query SELECT `field_id`,`value`
  460. FROM `josa9_fields_values`
  461. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '103'
  462. 170726 16:43:58   640 Query SELECT `field_id`,`value`
  463. FROM `josa9_fields_values`
  464. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '99'
  465. 170726 16:43:59   640 Query SELECT `field_id`,`value`
  466. FROM `josa9_fields_values`
  467. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '96'
  468. 170726 16:44:00   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  469. FROM josa9_fields AS a
  470. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  471. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  472. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  473. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  474. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  475. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  476. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (13,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  477. ORDER BY a.ordering ASC
  478.           640 Query SELECT `field_id`,`value`
  479. FROM `josa9_fields_values`
  480. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '155'
  481. 170726 16:44:01   640 Query SELECT `field_id`,`value`
  482. FROM `josa9_fields_values`
  483. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '159'
  484. 170726 16:44:02   640 Query SELECT `field_id`,`value`
  485. FROM `josa9_fields_values`
  486. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '157'
  487. 170726 16:44:03   640 Query SELECT `field_id`,`value`
  488. FROM `josa9_fields_values`
  489. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '173'
  490. 170726 16:44:04   640 Query SELECT `field_id`,`value`
  491. FROM `josa9_fields_values`
  492. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '160'
  493. 170726 16:44:05   640 Query SELECT `field_id`,`value`
  494. FROM `josa9_fields_values`
  495. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '158'
  496. 170726 16:44:06   640 Query SELECT `field_id`,`value`
  497. FROM `josa9_fields_values`
  498. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '161'
  499. 170726 16:44:07   640 Query SELECT `field_id`,`value`
  500. FROM `josa9_fields_values`
  501. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '156'
  502. 170726 16:44:08   640 Query SELECT `field_id`,`value`
  503. FROM `josa9_fields_values`
  504. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '193'
  505. 170726 16:44:09   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  506. FROM josa9_fields AS a
  507. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  508. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  509. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  510. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  511. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  512. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  513. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (14,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  514. ORDER BY a.ordering ASC
  515.           640 Query SELECT `field_id`,`value`
  516. FROM `josa9_fields_values`
  517. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '165'
  518. 170726 16:44:10   640 Query SELECT `field_id`,`value`
  519. FROM `josa9_fields_values`
  520. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '164'
  521. 170726 16:44:11   640 Query SELECT `field_id`,`value`
  522. FROM `josa9_fields_values`
  523. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '172'
  524. 170726 16:44:12   640 Query SELECT `field_id`,`value`
  525. FROM `josa9_fields_values`
  526. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '168'
  527. 170726 16:44:13   640 Query SELECT `field_id`,`value`
  528. FROM `josa9_fields_values`
  529. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '171'
  530. 170726 16:44:14   640 Query SELECT `field_id`,`value`
  531. FROM `josa9_fields_values`
  532. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '170'
  533. 170726 16:44:15   640 Query SELECT `field_id`,`value`
  534. FROM `josa9_fields_values`
  535. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '163'
  536. 170726 16:44:16   640 Query SELECT `field_id`,`value`
  537. FROM `josa9_fields_values`
  538. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '166'
  539. 170726 16:44:17   640 Query SELECT `field_id`,`value`
  540. FROM `josa9_fields_values`
  541. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '169'
  542. 170726 16:44:18   640 Query SELECT `field_id`,`value`
  543. FROM `josa9_fields_values`
  544. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '162'
  545. 170726 16:44:19   640 Query SELECT `field_id`,`value`
  546. FROM `josa9_fields_values`
  547. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '167'
  548. 170726 16:44:20   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  549. FROM josa9_fields AS a
  550. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  551. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  552. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  553. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  554. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  555. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  556. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (15,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  557. ORDER BY a.ordering ASC
  558.           640 Query SELECT `field_id`,`value`
  559. FROM `josa9_fields_values`
  560. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '184'
  561. 170726 16:44:21   640 Query SELECT `field_id`,`value`
  562. FROM `josa9_fields_values`
  563. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '183'
  564. 170726 16:44:22   640 Query SELECT `field_id`,`value`
  565. FROM `josa9_fields_values`
  566. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '185'
  567. 170726 16:44:23   640 Query SELECT `field_id`,`value`
  568. FROM `josa9_fields_values`
  569. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '187'
  570. 170726 16:44:24   640 Query SELECT `field_id`,`value`
  571. FROM `josa9_fields_values`
  572. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '174'
  573.           640 Query SELECT `field_id`,`value`
  574. FROM `josa9_fields_values`
  575. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '186'
  576. 170726 16:44:25   640 Query SELECT `field_id`,`value`
  577. FROM `josa9_fields_values`
  578. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '177'
  579. 170726 16:44:26   640 Query SELECT `field_id`,`value`
  580. FROM `josa9_fields_values`
  581. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '178'
  582. 170726 16:44:27   640 Query SELECT `field_id`,`value`
  583. FROM `josa9_fields_values`
  584. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '179'
  585. 170726 16:44:28   640 Query SELECT `field_id`,`value`
  586. FROM `josa9_fields_values`
  587. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '182'
  588. 170726 16:44:30   640 Query SELECT `field_id`,`value`
  589. FROM `josa9_fields_values`
  590. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '175'
  591. 170726 16:44:31   640 Query SELECT `field_id`,`value`
  592. FROM `josa9_fields_values`
  593. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '176'
  594. 170726 16:44:32   640 Query SELECT `field_id`,`value`
  595. FROM `josa9_fields_values`
  596. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '181'
  597. 170726 16:44:33   640 Query SELECT `field_id`,`value`
  598. FROM `josa9_fields_values`
  599. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '189'
  600. 170726 16:44:34   640 Query SELECT `field_id`,`value`
  601. FROM `josa9_fields_values`
  602. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '188'
  603. 170726 16:44:35   640 Query SELECT `field_id`,`value`
  604. FROM `josa9_fields_values`
  605. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '180'
  606. 170726 16:44:36   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  607. FROM josa9_fields AS a
  608. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  609. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  610. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  611. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  612. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  613. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  614. WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (16,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  615. ORDER BY a.ordering ASC
  616.           640 Query SELECT `field_id`,`value`
  617. FROM `josa9_fields_values`
  618. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '123'
  619. 170726 16:44:37   640 Query SELECT `field_id`,`value`
  620. FROM `josa9_fields_values`
  621. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '124'
  622. 170726 16:44:38   640 Query SELECT `field_id`,`value`
  623. FROM `josa9_fields_values`
  624. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '145'
  625. 170726 16:44:39   640 Query SELECT `field_id`,`value`
  626. FROM `josa9_fields_values`
  627. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '125'
  628. 170726 16:44:40   640 Query SELECT `field_id`,`value`
  629. FROM `josa9_fields_values`
  630. WHERE `field_id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33) AND `item_id` = '146'
  631. 170726 16:44:42   640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  632. FROM josa9_fields AS a
  633. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  634. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  635. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  636. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  637. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  638. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  639. WHERE a.context = 'com_content.categories' AND (fc.category_id IS NULL OR fc.category_id IN (16,0,8)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  640. ORDER BY a.ordering ASC
  641.           640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  642. FROM josa9_fields AS a
  643. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  644. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  645. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  646. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  647. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  648. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  649. WHERE a.context = 'com_content.categories' AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  650. ORDER BY a.ordering ASC
  651.           640 Query SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  652. FROM josa9_modules AS m
  653. LEFT JOIN josa9_modules_menu AS mm ON mm.moduleid = m.id
  654. LEFT JOIN josa9_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  655. WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-07-26 14:42:12') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-07-26 14:42:12') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 1122 OR mm.menuid <= 0)
  656. ORDER BY m.position, m.ordering
  657.           640 Query SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
  658. FROM josa9_fields AS a
  659. LEFT JOIN `josa9_languages` AS l ON l.lang_code = a.language
  660. LEFT JOIN josa9_users AS uc ON uc.id=a.checked_out
  661. LEFT JOIN josa9_viewlevels AS ag ON ag.id = a.access
  662. LEFT JOIN josa9_users AS ua ON ua.id = a.created_user_id
  663. LEFT JOIN josa9_fields_groups AS g ON g.id = a.group_id
  664. LEFT JOIN `josa9_fields_categories` AS fc ON fc.field_id = a.id
  665. WHERE a.context = 'mod_custom.content' AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
  666. ORDER BY a.ordering ASC
  667.           640 Query SELECT *
  668. FROM josa9_easyblog_configs
  669. WHERE `name` = 'config'
  670.           640 Query select * from josa9_revslider_sliders where id=2
  671.           640 Query select * from josa9_revslider_slides where slider_id=2 order by slide_order
  672.           640 Query select * from josa9_revslider_layer_animations
  673.           640 Query select * from josa9_revslider_layer_animations
  674.           640 Query select * from josa9_revslider_layer_animations
  675.           640 Query select * from josa9_revslider_layer_animations
  676.           640 Query UPDATE `josa9_session`
  677. SET `data` = 'joomla|s:644:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjozOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjI6e3M6NzoiY291bnRlciI7aTo0NTtzOjU6InRpbWVyIjtPOjg6InN0ZENsYXNzIjozOntzOjU6InN0YXJ0IjtpOjE1MDEwNzYyMTE7czo0OiJsYXN0IjtpOjE1MDEwNzk2MjI7czozOiJub3ciO2k6MTUwMTA4MDEzMjt9fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6Mzp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9czo0OiJ1c2VyIjtPOjU6IkpVc2VyIjoxOntzOjI6ImlkIjtpOjA7fX19czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9\";'
  678.     , `time` = '1501080282'
  679. WHERE `session_id` = 'l1dc4gjqv45lpc37use57samp1'
  680.           640 Statistics   
  681.           640 Quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!