Pastie now auto-senses if line-wrap is a bad or good idea. Feedback?
## mark a section (Learn more)
Profile Information Application afterLoad: 0.001 seconds, 0.33 MB Application afterInitialise: 0.045 seconds, 3.09 MB Application afterRoute: 0.048 seconds, 3.30 MB Application afterDispatch: 0.252 seconds, 6.09 MB Application afterRender: 0.293 seconds, 7.56 MB Memory Usage 7974364 107 queries logged. 1. SELECT * FROM jos_session WHERE session_id = 'be616705540d8a6767d859a1833603fa' 2. DELETE FROM jos_session WHERE ( time < '1268662405' ) 3. SELECT * FROM jos_session WHERE session_id = 'be616705540d8a6767d859a1833603fa' 4. UPDATE `jos_session` SET `time`='1268663305',`userid`='1',`usertype`='Super Administrator',`username`='chris',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:8:{s:15:\"session.counter\";i:32;s:19:\"session.timer.start\";i:1268662949;s:18:\"session.timer.last\";i:1268663303;s:17:\"session.timer.now\";i:1268663303;s:22:\"session.client.browser\";s:91:\"Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:4:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"20\";}}}s:18:\"administrator::com\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:7:\"billets\";O:8:\"stdClass\":1:{s:5:\"model\";O:8:\"stdClass\":3:{s:20:\"categorieslimitstart\";i:0;s:10:\"categories\";O:8:\"stdClass\":3:{s:12:\"filter_order\";s:6:\"tbl.id\";s:16:\"filter_direction\";s:4:\"desc\";s:6:\"filter\";s:0:\"\";}s:18:\"categoriesparentid\";s:1:\"1\";}}}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:1:\"1\";s:4:\"name\";s:5:\"Chris\";s:8:\"username\";s:5:\"chris\";s:5:\"email\";s:19:\"chris@prothemer.com\";s:8:\"password\";s:65:\"8f66f16377912856c0c928bc4ef1db44:p4L3dYjcZQGwEerEUGi3GMSyGnkn2YVv\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-03-14 11:53:29\";s:13:\"lastvisitDate\";s:19:\"2010-03-15 14:22:29\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:69:\"admin_language=en-GB\nlanguage=en-GB\neditor=jce\nhelpsite=\ntimezone=2\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:70:\"/Volumes/Files/Sites/prothemer/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":5:{s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:3:\"jce\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:1:\"2\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"ecdf0d4a918acca1728694f059fc0cde\";}chartcount|i:5;' WHERE session_id='be616705540d8a6767d859a1833603fa' 5. SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 2 ORDER BY ordering 6. SELECT * FROM jos_components WHERE parent = 0 7. SELECT template FROM jos_templates_menu WHERE client_id = 1 AND menuid = 0 8. SELECT * FROM jos_billets_config 9. SHOW COLUMNS FROM jos_billets_fields LIKE 'checked_out' 10. SHOW FIELDS FROM jos_billets_config 11. SELECT DATE_SUB('2010-03-15 00:00:00', INTERVAL 1 MONTH) 12. SELECT DATE_ADD('2010-02-15 00:00:00', INTERVAL 1 DAY) 13. SHOW FIELDS FROM jos_billets_tickets 14. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-15 00:00:00' AND tbl.created_datetime <= '2010-02-16 00:00:00' 15. SELECT DATE_ADD('2010-02-16 00:00:00', INTERVAL 1 DAY) 16. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-16 00:00:00' AND tbl.created_datetime <= '2010-02-17 00:00:00' 17. SELECT DATE_ADD('2010-02-17 00:00:00', INTERVAL 1 DAY) 18. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-17 00:00:00' AND tbl.created_datetime <= '2010-02-18 00:00:00' 19. SELECT DATE_ADD('2010-02-18 00:00:00', INTERVAL 1 DAY) 20. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-18 00:00:00' AND tbl.created_datetime <= '2010-02-19 00:00:00' 21. SELECT DATE_ADD('2010-02-19 00:00:00', INTERVAL 1 DAY) 22. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-19 00:00:00' AND tbl.created_datetime <= '2010-02-20 00:00:00' 23. SELECT DATE_ADD('2010-02-20 00:00:00', INTERVAL 1 DAY) 24. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-20 00:00:00' AND tbl.created_datetime <= '2010-02-21 00:00:00' 25. SELECT DATE_ADD('2010-02-21 00:00:00', INTERVAL 1 DAY) 26. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-21 00:00:00' AND tbl.created_datetime <= '2010-02-22 00:00:00' 27. SELECT DATE_ADD('2010-02-22 00:00:00', INTERVAL 1 DAY) 28. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-22 00:00:00' AND tbl.created_datetime <= '2010-02-23 00:00:00' 29. SELECT DATE_ADD('2010-02-23 00:00:00', INTERVAL 1 DAY) 30. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-23 00:00:00' AND tbl.created_datetime <= '2010-02-24 00:00:00' 31. SELECT DATE_ADD('2010-02-24 00:00:00', INTERVAL 1 DAY) 32. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-24 00:00:00' AND tbl.created_datetime <= '2010-02-25 00:00:00' 33. SELECT DATE_ADD('2010-02-25 00:00:00', INTERVAL 1 DAY) 34. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-25 00:00:00' AND tbl.created_datetime <= '2010-02-26 00:00:00' 35. SELECT DATE_ADD('2010-02-26 00:00:00', INTERVAL 1 DAY) 36. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-26 00:00:00' AND tbl.created_datetime <= '2010-02-27 00:00:00' 37. SELECT DATE_ADD('2010-02-27 00:00:00', INTERVAL 1 DAY) 38. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-27 00:00:00' AND tbl.created_datetime <= '2010-02-28 00:00:00' 39. SELECT DATE_ADD('2010-02-28 00:00:00', INTERVAL 1 DAY) 40. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-02-28 00:00:00' AND tbl.created_datetime <= '2010-03-01 00:00:00' 41. SELECT DATE_ADD('2010-03-01 00:00:00', INTERVAL 1 DAY) 42. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-01 00:00:00' AND tbl.created_datetime <= '2010-03-02 00:00:00' 43. SELECT DATE_ADD('2010-03-02 00:00:00', INTERVAL 1 DAY) 44. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-02 00:00:00' AND tbl.created_datetime <= '2010-03-03 00:00:00' 45. SELECT DATE_ADD('2010-03-03 00:00:00', INTERVAL 1 DAY) 46. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-03 00:00:00' AND tbl.created_datetime <= '2010-03-04 00:00:00' 47. SELECT DATE_ADD('2010-03-04 00:00:00', INTERVAL 1 DAY) 48. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-04 00:00:00' AND tbl.created_datetime <= '2010-03-05 00:00:00' 49. SELECT DATE_ADD('2010-03-05 00:00:00', INTERVAL 1 DAY) 50. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-05 00:00:00' AND tbl.created_datetime <= '2010-03-06 00:00:00' 51. SELECT DATE_ADD('2010-03-06 00:00:00', INTERVAL 1 DAY) 52. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-06 00:00:00' AND tbl.created_datetime <= '2010-03-07 00:00:00' 53. SELECT DATE_ADD('2010-03-07 00:00:00', INTERVAL 1 DAY) 54. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-07 00:00:00' AND tbl.created_datetime <= '2010-03-08 00:00:00' 55. SELECT DATE_ADD('2010-03-08 00:00:00', INTERVAL 1 DAY) 56. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-08 00:00:00' AND tbl.created_datetime <= '2010-03-09 00:00:00' 57. SELECT DATE_ADD('2010-03-09 00:00:00', INTERVAL 1 DAY) 58. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-09 00:00:00' AND tbl.created_datetime <= '2010-03-10 00:00:00' 59. SELECT DATE_ADD('2010-03-10 00:00:00', INTERVAL 1 DAY) 60. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-10 00:00:00' AND tbl.created_datetime <= '2010-03-11 00:00:00' 61. SELECT DATE_ADD('2010-03-11 00:00:00', INTERVAL 1 DAY) 62. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-11 00:00:00' AND tbl.created_datetime <= '2010-03-12 00:00:00' 63. SELECT DATE_ADD('2010-03-12 00:00:00', INTERVAL 1 DAY) 64. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-12 00:00:00' AND tbl.created_datetime <= '2010-03-13 00:00:00' 65. SELECT DATE_ADD('2010-03-13 00:00:00', INTERVAL 1 DAY) 66. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-13 00:00:00' AND tbl.created_datetime <= '2010-03-14 00:00:00' 67. SELECT DATE_ADD('2010-03-14 00:00:00', INTERVAL 1 DAY) 68. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-14 00:00:00' AND tbl.created_datetime <= '2010-03-15 00:00:00' 69. SELECT DATE_ADD('2010-03-15 00:00:00', INTERVAL 1 DAY) 70. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.created_datetime >= '2010-03-15 00:00:00' AND tbl.created_datetime <= '2010-03-16 00:00:00' 71. SHOW FIELDS FROM jos_billets_ticketstates 72. SELECT * FROM jos_billets_ticketstates WHERE id = '0' 73. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 0 ORDER BY ordering ASC 74. SELECT * FROM jos_billets_ticketstates WHERE id = '0' 75. SELECT * FROM jos_billets_ticketstates WHERE id = '0' 76. SELECT * FROM jos_billets_ticketstates WHERE id = '2' 77. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 2 ORDER BY ordering ASC 78. SELECT * FROM jos_billets_ticketstates WHERE id = '1' 79. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 1 ORDER BY ordering ASC 80. SELECT * FROM jos_billets_ticketstates WHERE id = '1' 81. SELECT * FROM jos_billets_ticketstates WHERE id = '3' 82. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 3 ORDER BY ordering ASC 83. SELECT * FROM jos_billets_ticketstates WHERE id = '2' 84. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 2 ORDER BY ordering ASC 85. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.stateid IN ('2') 86. SELECT * FROM jos_billets_ticketstates WHERE id = '1' 87. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 1 ORDER BY ordering ASC 88. SELECT * FROM jos_billets_ticketstates WHERE id = '1' 89. SELECT * FROM jos_billets_ticketstates WHERE id = '3' 90. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 3 ORDER BY ordering ASC 91. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.stateid IN ('1', '3') 92. SELECT * FROM jos_billets_ticketstates WHERE id = '3' 93. SELECT tbl.* FROM jos_billets_ticketstates AS tbl WHERE tbl.enabled = 1 AND tbl.parentid = 3 ORDER BY ordering ASC 94. SELECT tbl.*, u.name AS user_name , u.username AS user_username , u.email AS user_email , td.* , states.img AS state_image , states.title AS state_title , label.title AS label_title , label.color AS label_color FROM jos_billets_tickets AS tbl LEFT JOIN jos_users AS u ON u.id = tbl.sender_userid LEFT JOIN jos_billets_ticketdata AS td ON td.ticketid = tbl.id LEFT JOIN jos_billets_ticketstates AS states ON tbl.stateid = states.id LEFT JOIN jos_billets_labels AS label ON tbl.labelid = label.id WHERE tbl.stateid IN ('3') 95. SHOW FIELDS FROM jos_billets_labels 96. SELECT tbl.* FROM jos_billets_labels AS tbl ORDER BY title 97. SELECT COUNT(*) FROM jos_billets_tickets AS db WHERE 1 AND db.stateid = '2' 98. SELECT COUNT(*) FROM jos_billets_tickets AS db WHERE 1 AND db.stateid = '2' AND db.firstresponse_by > '0' AND db.feedback_rating > '0' 99. SELECT COUNT(*) FROM jos_billets_tickets AS db WHERE 1 AND db.stateid = '2' AND db.firstresponse_by > '0' AND db.feedback_rating > '0' 100. SELECT DATE_SUB('2010-03-01', INTERVAL 1 MONTH) 101. SELECT COUNT(*) AS count, SUM(db.feedback_rating) AS ratings FROM jos_billets_tickets AS db WHERE 1 AND db.stateid = '2' AND db.firstresponse_by > '0' AND db.closed_datetime >= '2010-02-01' AND db.closed_datetime < '2010-03-01' 102. SELECT COUNT(*) AS count, SUM(db.feedback_rating) AS ratings FROM jos_billets_tickets AS db WHERE 1 AND db.stateid = '2' AND db.firstresponse_by > '0' AND db.closed_datetime >= '2010-03-01' AND db.closed_datetime < '2010-03-15 00:00:00' 103. SELECT m.* FROM jos_modules AS m WHERE published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY m.ordering, m.id 104. 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 105. SELECT * FROM jos_components WHERE `option` <> "com_frontpage" AND `option` <> "com_media" AND enabled = 1 ORDER BY ordering, name 106. SELECT COUNT(*) FROM jos_messages WHERE state = 0 AND user_id_to = 1 107. SELECT COUNT( session_id ) FROM jos_session WHERE guest <> 1 Language Files Loaded * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_system_nonumberelements.ini 1 * /Volumes/Files/Sites/prothemer/language/en-GB/en-GB.com_flexicontent.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_system_debug.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_billets.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_billets_feedbackhistory.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.plg_billets_googletranslate.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.tpl_khepri.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_submenu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_title.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_toolbar.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_amigos.menu.ini * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_billets.menu.ini * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_configurator.menu.ini * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_contact.menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_extplorer.menu.ini * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_flexicontent.menu.ini * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_jce.menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_poll.menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_search.menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_jupdateman.menu.ini * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_banners.menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_newsfeeds.menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.com_weblinks.menu.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_status.ini 1 * /Volumes/Files/Sites/prothemer/administrator/language/en-GB/en-GB.mod_cachecleaner.ini 1 Untranslated Strings Diagnostic None Untranslated Strings Designer None
This paste will be private.
From the Design Piracy series on my blog: