1. SELECT folder AS TYPE, element AS name, params
    FROM jos_plugins
    WHERE published >= 1
    AND access <= 2
    ORDER BY ordering
  2. SELECT template
    FROM jos_templates_menu
    WHERE client_id = 1
    AND menuid = 0
  3. SELECT *
    FROM jos_components
    WHERE parent = 0
  4. SELECT COUNT(*)
    FROM jos_sections AS s
    WHERE s.scope = 'content'
  5. SELECT s.*, g.name AS groupname, u.name AS editor
    FROM jos_sections AS s
    LEFT JOIN jos_content AS cc
    ON s.id = cc.sectionid
    LEFT JOIN jos_users AS u
    ON u.id = s.checked_out
    LEFT JOIN jos_groups AS g
    ON g.id = s.access
    WHERE s.scope = 'content'
    GROUP BY s.id
    ORDER BY s.ordering , s.ordering
    LIMIT 0, 20
  6. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '21'
    AND a.published <> -2
  7. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '20'
    AND a.published <> -2
  8. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '19'
    AND a.published <> -2
  9. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '16'
    AND a.published <> -2
  10. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '15'
    AND a.published <> -2
  11. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '14'
    AND a.published <> -2
  12. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '13'
    AND a.published <> -2
  13. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '12'
    AND a.published <> -2
  14. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '9'
    AND a.published <> -2
  15. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '8'
    AND a.published <> -2
  16. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '7'
    AND a.published <> -2
  17. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '5'
    AND a.published <> -2
  18. SELECT COUNT( a.id )
    FROM jos_categories AS a
    WHERE a.SECTION = '2'
    AND a.published <> -2
  19. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 21
    AND a.state <> -2
  20. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 20
    AND a.state <> -2
  21. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 19
    AND a.state <> -2
  22. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 16
    AND a.state <> -2
  23. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 15
    AND a.state <> -2
  24. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 14
    AND a.state <> -2
  25. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 13
    AND a.state <> -2
  26. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 12
    AND a.state <> -2
  27. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 9
    AND a.state <> -2
  28. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 8
    AND a.state <> -2
  29. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 7
    AND a.state <> -2
  30. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 5
    AND a.state <> -2
  31. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 2
    AND a.state <> -2
  32. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 21
    AND a.state = -2
  33. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 20
    AND a.state = -2
  34. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 19
    AND a.state = -2
  35. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 16
    AND a.state = -2
  36. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 15
    AND a.state = -2
  37. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 14
    AND a.state = -2
  38. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 13
    AND a.state = -2
  39. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 12
    AND a.state = -2
  40. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 9
    AND a.state = -2
  41. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 8
    AND a.state = -2
  42. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 7
    AND a.state = -2
  43. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 5
    AND a.state = -2
  44. SELECT COUNT( a.id )
    FROM jos_content AS a
    WHERE a.sectionid = 2
    AND a.state = -2
  45. SELECT id, title, module, POSITION, content, showtitle, control, params
    FROM jos_modules AS m
    LEFT JOIN jos_modules_menu AS mm
    ON mm.moduleid = m.id
    WHERE m.published = 1
    AND m.access <= 2
    AND m.client_id = 1
    ORDER BY POSITION, ordering
  46. SELECT a.name, a.n_menu_link, a.n_menu_img
    FROM jos_components AS a
    INNER JOIN jos_components AS b
    ON b.id = a.parent
    WHERE b.OPTION = 'com_sections'
    AND b.parent = 0
    ORDER BY a.ordering ASC
  47. SELECT a.*, SUM(b.home) AS home
    FROM jos_menu_types AS a
    LEFT JOIN jos_menu AS b
    ON b.menutype = a.menutype
    GROUP BY a.id
  48. SELECT *
    FROM jos_components
    WHERE `option` <> "com_frontpage"
    AND `option` <> "com_media"
    AND enabled = 1
    ORDER BY ordering, name
  49. SELECT COUNT(*)
    FROM jos_messages
    WHERE state = 0
    AND user_id_to = 62
  50. SELECT COUNT( session_id )
    FROM jos_session
    WHERE guest <> 1

در خواست وراثت های ثبت شد
فایل های زبان بارگزاری شد