+ ~ -
 

The Waiting For Approval Magazines

Description

On this table of magazines awaiting approval, you will see the magazines are sorted chronologically by 'Days Waiting'. Please select the first that you see, and click on 'Correction Record,' as the Text Corrector of this magazine will have been waiting longest. You will be taken to the 'Correction Record' for that magazine.

Magazine List
User Access Filter

Sorry, there are currently no magazines available on this list.

Who's Online

We have 133 guests and 1 robot online.

Profile Information

Application afterLoad: 0.000 seconds, 0.28 MB
Application afterInitialise: 0.019 seconds, 1.00 MB
Application afterRoute: 0.023 seconds, 2.05 MB
Application afterDispatch: 0.099 seconds, 3.31 MB
Application afterRender: 0.148 seconds, 3.60 MB

Memory Usage

3812264

13 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'd2da743355ff1dec19b106dfd9b1997e'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1632158058' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'd2da743355ff1dec19b106dfd9b1997e'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'd2da743355ff1dec19b106dfd9b1997e','1632159858','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 164)
      ORDER BY menuid DESC
      LIMIT 0, 1
  8. SELECT is_moderator
      FROM jos_toc_users
      WHERE id_user = 0
  9. SELECT magazine.*,        volume.published AS published_volume,        periodical.published AS published_periodical,        block.cnt AS block_count, block.cnt AS count_block,        document.cnt AS document_count,        0 AS link_count
      FROM jos_toc_magazines AS magazine  
      LEFT JOIN jos_toc_volumes AS volume
      ON            (magazine.id_volume = volume.id)
      LEFT JOIN jos_toc_periodicals AS periodical
      ON            (volume.id_periodical = periodical.id)
      LEFT JOIN (SELECT id_magazine, COUNT(*) AS cnt            
      FROM jos_toc_blocks
      GROUP BY id_magazine) AS block
      ON           (magazine.id = block.id_magazine)
      LEFT JOIN (SELECT magazine_id, COUNT(*) AS cnt            
      FROM jos_toc_magazines_documents
      GROUP BY magazine_id) AS document          
      ON (magazine.id = document.magazine_id)
      LEFT JOIN (SELECT magazine_id, COUNT(*) AS cnt            
      FROM jos_toc_magazines_links
      GROUP BY magazine_id) AS link          
      ON (magazine.id = link.magazine_id)  
      WHERE (magazine.published = 1)
      AND (magazine.otc_access = 'volunteer')
      GROUP BY magazine.id
  10. SELECT magazine.*,        volume.published AS published_volume,        periodical.published AS published_periodical,        block.cnt AS block_count, block.cnt AS count_block,        document.cnt AS document_count,        0 AS link_count
      FROM jos_toc_magazines AS magazine  
      LEFT JOIN jos_toc_volumes AS volume
      ON            (magazine.id_volume = volume.id)
      LEFT JOIN jos_toc_periodicals AS periodical
      ON            (volume.id_periodical = periodical.id)
      LEFT JOIN (SELECT id_magazine, COUNT(*) AS cnt            
      FROM jos_toc_blocks
      GROUP BY id_magazine) AS block
      ON           (magazine.id = block.id_magazine)
      LEFT JOIN (SELECT magazine_id, COUNT(*) AS cnt            
      FROM jos_toc_magazines_documents
      GROUP BY magazine_id) AS document          
      ON (magazine.id = document.magazine_id)
      LEFT JOIN (SELECT magazine_id, COUNT(*) AS cnt            
      FROM jos_toc_magazines_links
      GROUP BY magazine_id) AS link          
      ON (magazine.id = link.magazine_id)  
      WHERE (magazine.published = 1)
      AND (magazine.otc_state = 'waiting_for_approval')
      AND (magazine.otc_access = 'volunteer')
      GROUP BY magazine.id
      ORDER BY title ASC
      LIMIT 20
  11. SELECT magazine.*,        volume.published AS published_volume,        periodical.published AS published_periodical,        block.cnt AS block_count, block.cnt AS count_block,        document.cnt AS document_count,        0 AS link_count
      FROM jos_toc_magazines AS magazine  
      LEFT JOIN jos_toc_volumes AS volume
      ON            (magazine.id_volume = volume.id)
      LEFT JOIN jos_toc_periodicals AS periodical
      ON            (volume.id_periodical = periodical.id)
      LEFT JOIN (SELECT id_magazine, COUNT(*) AS cnt            
      FROM jos_toc_blocks
      GROUP BY id_magazine) AS block
      ON           (magazine.id = block.id_magazine)
      LEFT JOIN (SELECT magazine_id, COUNT(*) AS cnt            
      FROM jos_toc_magazines_documents
      GROUP BY magazine_id) AS document          
      ON (magazine.id = document.magazine_id)
      LEFT JOIN (SELECT magazine_id, COUNT(*) AS cnt            
      FROM jos_toc_magazines_links
      GROUP BY magazine_id) AS link          
      ON (magazine.id = link.magazine_id)  
      WHERE (magazine.published = 1)
      AND (magazine.otc_state = 'waiting_for_approval')
      AND (magazine.otc_access = 'volunteer')
      GROUP BY magazine.id
  12. 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 <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 164 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  13. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None