/usr/sbin/mysqld, Version: 4.1.22-standard-log. started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id Command Argument 071114 9:47:14 1 Connect giiexpr@localhost on 1 Init DB giiexpr_customers 1 Query SET NAMES 'utf8' 1 Query SELECT note_id, note_text, UNIX_TIMESTAMP(note_timestamp) AS note_u_timestamp FROM memos WHERE customer_id=25611 ORDER BY note_timestamp DESC 1 Quit 071114 9:47:21 2 Connect giiexpr@localhost on 2 Init DB giiexpr_db 2 Query SET NAMES 'utf8' 2 Query SHOW TABLES LIKE 'prod\_chg' 2 Query SELECT * FROM `prod` WHERE prod_id='czaewxxfg2m9jQl' 2 Query SHOW COLUMNS FROM `prod` 2 Query SELECT chg_id FROM `prod_chg` WHERE chg_id='iKyqEF74So7QUH7' 2 Query INSERT INTO `prod_chg` (prod_id,prod_title,prod_type,prod_discont,prod_ready,pub_id,prod_published,prod_pub_prod_id,prod_pub_acct_id,prod_pub_doi,prod_pub_resp,prod_pub_prod_url,prod_rel_freq,prod_content_info,prod_info_type,prod_language,prod_broch_doc,prod_samp_doc,prod_samp_pgs,prod_exec_summ,prod_toc_doc,prod_e_title_tag,prod_meta_tags,prod_keywords,prod_comments,prod_changed,prod_export,prod_scoop_changed,prod_updated,chg_id,chg_date,chg_fields,chg_action,chg_staff_id) VALUES ('czaewxxfg2m9jQl','World Presentation Assembly and Management Platforms Markets','S',0,0,'3b33K3HM1NX9713','2007/11/13','N2B2',NULL,NULL,NULL,NULL,NULL,NULL,'W',NULL,'http://www.frost.com/prod/servlet/report-homepage.pag?repid=N2B2-01-00-00-00&ctxixpLink=FcmCtx3&ctxixpLabel=FcmCtx4',NULL,NULL,NULL,'http://www.frost.com/prod/servlet/report-homepage.pag?repid=N2B2-01-00-00-00&ctxixpLink=FcmCtx3&ctxixpLabel=FcmCtx4',NULL,'presentation management, assembly platforms','PRESENTATION MANAGEMENT ASSEMBLY PLATFORMS',NULL,1,1,1,'2007-11-14 09:47:21','iKyqEF74So7QUH7','2007-11-14 09:47:21',NULL,'u','8fqx20U7jS0TYrm') 2 Query UPDATE `prod` SET prod_id='czaewxxfg2m9jQl',prod_title='World Presentation Assembly and Management Platforms Markets',prod_type='S',prod_discont=0,prod_ready=0,pub_id='3b33K3HM1NX9713',prod_published='2007/11/13',prod_pub_prod_id='N2B2',prod_pub_acct_id=NULL,prod_pub_doi=NULL,prod_pub_resp=NULL,prod_pub_prod_url=NULL,prod_rel_freq=NULL,prod_content_info=NULL,prod_info_type='W',prod_language=NULL,prod_broch_doc='http://www.frost.com/prod/servlet/report-homepage.pag?repid=N2B2-01-00-00-00&ctxixpLink=FcmCtx3&ctxixpLabel=FcmCtx4',prod_samp_doc=NULL,prod_samp_pgs=NULL,prod_exec_summ=NULL,prod_toc_doc='http://www.frost.com/prod/servlet/report-homepage.pag?repid=N2B2-01-00-00-00&ctxixpLink=FcmCtx3&ctxixpLabel=FcmCtx4',prod_e_title_tag=NULL,prod_meta_tags='presentation management, assembly platforms',prod_keywords='PRESENTATION MANAGEMENT ASSEMBLY PLATFORMS',prod_comments=NULL,prod_changed=1,prod_export=1,prod_scoop_changed=1,prod_updated='2007-11-14 09:47:21' WHERE prod_id='czaewxxfg2m9jQl' 2 Quit 3 Connect giiexpr@localhost on 3 Init DB giiexpr_db 3 Query SET NAMES 'utf8' 3 Query SELECT * FROM `prod` WHERE prod_id='czaewxxfg2m9jQl' 3 Query SELECT pub_id,pub_code,pub_name FROM `pub` ORDER BY pub_code 071114 9:47:22 3 Query SELECT * FROM `prod_price` WHERE prod_id='czaewxxfg2m9jQl' ORDER BY prod_price_disp_price 3 Query SELECT prod_web_id,prod_web_desc,prod_web_html_title FROM `prod_web` WHERE prod_id='czaewxxfg2m9jQl' 3 Query SELECT prod_topic_id,topic_code,topic_name FROM `prod_topic` INNER JOIN `topic` ON `topic`.topic_id = `prod_topic`.topic_id WHERE prod_id='czaewxxfg2m9jQl' ORDER BY topic_code 3 Query SELECT prod_rel_id, prod_num, prod_title FROM prod_rel, prod WHERE ((prod_rel.prod_id='czaewxxfg2m9jQl') AND (prod.prod_id=rel_prod_id)) OR ((rel_prod_id='czaewxxfg2m9jQl') AND (prod.prod_id=prod_rel.prod_id)) ORDER BY prod_num 3 Quit 071114 9:47:24 4 Connect giiexpr@localhost on 4 Init DB giiexpr_db 4 Query SET NAMES 'utf8' 4 Quit 5 Connect giiexpr@localhost on 5 Init DB giiexpr_db 5 Query SET NAMES 'utf8' 5 Query SELECT SQL_CALC_FOUND_ROWS prod.*, pub.pub_code, GROUP_CONCAT(topic.topic_code ORDER BY topic.topic_code SEPARATOR ',
') AS topic_code FROM prod LEFT JOIN pub ON pub.pub_id = prod.pub_id LEFT JOIN prod_topic ON prod.prod_id = prod_topic.prod_id LEFT JOIN topic ON prod_topic.topic_id = topic.topic_id GROUP BY prod_num ORDER BY prod_num DESC LIMIT 0,25 071114 9:47:28 5 Query SELECT FOUND_ROWS() 5 Quit 071114 9:47:30 6 Connect Access denied for user 'readonly'@'adsl-76-245-68-102.dsl.wlfrct.sbcglobal.net' (using password: YES) 071114 9:47:45 7 Connect readonly@adsl-76-245-68-102.dsl.wlfrct.sbcglobal.net on giiexpr_db 7 Query SET NAMES utf8 7 Query SET character_set_results = NULL 7 Query SET SQL_AUTO_IS_NULL = 0 7 Query SELECT Config, nValue FROM MSysConf 7 Query SELECT `topic`.`topic_id` FROM `topic` 071114 9:47:48 7 Query SELECT `topic_id`,`topic_code`,`topic_name`,`topic_desc`,`topic_added`,`topic_updated` FROM `topic` WHERE `topic_id` = '1135j19991779A9' OR `topic_id` = '117R117H915y7Gq' OR `topic_id` = '11A35j15oP37915' OR `topic_id` = '11v5k39QWwT719J' OR `topic_id` = '13531m377m7991G' OR `topic_id` = '135U5153FF37391' OR `topic_id` = '1379533T17P3j19' OR `topic_id` = '13k1Z5fMZ5N7W5g' OR `topic_id` = '13m7Wn3593dk31x' OR `topic_id` = '13v97fv7b515eJ9' 7 Query SELECT `topic_id`,`topic_code`,`topic_name`,`topic_desc`,`topic_added`,`topic_updated` FROM `topic` WHERE `topic_id` = '15577f35u3K7Bn3' OR `topic_id` = '1595W53515517x3' OR `topic_id` = '159o11pR55x11Za' OR `topic_id` = '15ob935g793KC3x' OR `topic_id` = '1715a5555YEnb5s' OR `topic_id` = '171JA39jT519C91' OR `topic_id` = '17573n97ZV157Ud' OR `topic_id` = '1771177t9ptv1Wv' OR `topic_id` = '17733R71fWN3sR1' OR `topic_id` = '177U539971wBVKr' 7 Query SELECT `topic_id`,`topic_code`,`topic_name`,`topic_desc`,`topic_added`,`topic_updated` FROM `topic` WHERE `topic_id` = '177X931793m15Jh' OR `topic_id` = '179hF5L71Y3J591' OR `topic_id` = '17ee77d9pB1yv7H' OR `topic_id` = '17h3XguMgw57Cn9' OR `topic_id` = '17y155wD99T191u' OR `topic_id` = '19151Ncw77k13N9' OR `topic_id` = '191939z395Qr17J' OR `topic_id` = '191tt99r9159753' OR `topic_id` = '193n17PoA155Q3b' OR `topic_id` = '1955F91jB793799' 071114 9:47:58 7 Query SELECT prod.prod_num, concat("|",group_concat(topic.topic_code SEPARATOR "|"),"|") AS topic_list FROM prod JOIN prod_topic JOIN topic WHERE prod.prod_id = prod_topic.prod_id AND prod_topic.topic_id = topic.topic_id GROUP BY prod.prod_num 071114 9:48:50 7 Query SELECT `topic_id`,`topic_code`,'#S_C_H#' ,'#S_C_H#' ,`topic_added`,`topic_updated` FROM `topic` WHERE `topic_id` = '19BFEsh311b7933' OR `topic_id` = '19cqX1Z17y175j1' OR `topic_id` = '19F11rZ7E51vtE1' OR `topic_id` = '19h5x7tAty9377o' OR `topic_id` = '19Sfqc55J35DYoc' OR `topic_id` = '19srXbz1r37915X' OR `topic_id` = '19u7N7S97799qe9' OR `topic_id` = '1A193fS3z3W77n9' OR `topic_id` = '1aD1C5791319Yk5' OR `topic_id` = '1c5593135119Dri' 071114 9:49:03 7 Query SELECT `topic_id`,`topic_code`,'#S_C_H#' ,'#S_C_H#' ,`topic_added`,`topic_updated` FROM `topic` WHERE `topic_id` = '1c9M17cBKy959d1' OR `topic_id` = '1d3395h39353b3B' OR `topic_id` = '1Fb31799r917593' OR `topic_id` = '1H9r795997rm797' OR `topic_id` = '1iV1S5311a1RY53' OR `topic_id` = '1JhG4km6969EUtX' OR `topic_id` = '1kPL9n353H5nm9e' OR `topic_id` = '1L37S331TbS5z5h' OR `topic_id` = '1L7kEDWc7Kf5GE9' OR `topic_id` = '1L9b7nJtP5B139d'