Tue, Jul 7, 2015
A A A
Welcome Guest
Free Trial RSS
Get FREE trial access to our award winning publications
Logon Details

  • SELECT sSessID FROM op_session WHERE sSessID = '' AND DATE_FORMAT( from_unixtime( iLastAct ) , '%Y-%m-%d' ) >= CURRENT_DATE( )A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • INSERT INTO op_session (sSessID, iUserID, sRememberLoginID, sUserIP, sUserAgent, iLastAct, iValidated, created_date) VALUES ('0646168b1355d3e20a800d0f771ca74f', '0', '', '54.80.153.53', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '1436291000', '0', '1436291000') ON DUPLICATE KEY UPDATE sUserAgent = 'CCBot/2.0 (http://commoncrawl.org/faq/)', sUserIP ='54.80.153.53', iUserID ='0', sRememberLoginID ='', iLastAct ='1436291000', iValidated = '0'A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT * FROM `ad_roundtable` WHERE YEAR( `sConuploaddate` ) = '2015' ORDER BY `scon_id` DESCA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.products_id FROM usr_web1_3.products_description p1 JOIN usr_web1_3.products p2 ON p1.products_id = p2.products_id WHERE BPActive=1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.products_id FROM usr_web1_3.featured p1 JOIN usr_web1_3.products_description p2 ON p1.products_id = p2.products_id JOIN usr_web1_3.products p3 ON p2.products_id = p3.products_id WHERE IsActive=1 ORDER BY p2.products_nameA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.products_id FROM usr_web1_3.products_description p1 JOIN usr_web1_3.products p2 ON p1.products_id = p2.products_id WHERE BsActive=1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT SearchText, counter FROM `op_tagged` WHERE SearchText not like '%Quantek%' order by counter desc A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT iTotal FROM usr_web1_1.ad_totalarticlesA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT MONTH(tsDate) tsDate, YEAR(tsDate) tsYear FROM ad_amb p1 JOIN join_amb_archivatomic p2 ON p1.iNewsletterID = p2.iNewsletterID JOIN ad_archiv_atomic p3 ON p3.iArticleID = p2.iArticleID WHERE iFlagActive =1 AND p3.iType=1 ORDER BY p1.iNewsletterID DESC LIMIT 0 , 1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.iNewsletterID, DATE_FORMAT( tsDate, '%d. %b.' ) tsDate, CASE WHEN tsDate <= DATE_SUB( CURDATE( ) , INTERVAL 6 MONTH ) THEN 1 ELSE 0 END chkSixMonths, p2.iArticleID, tsArticleDate, sTitle, sBody, sUrl, iCategory, iIsHot FROM ad_amb p1 JOIN join_amb_archivatomic p2 ON p1.iNewsletterID = p2.iNewsletterID JOIN ad_archiv_atomic p3 ON p2.iArticleID = p3.iArticleID WHERE iFlagActive =1 AND MONTH(tsDate)= AND YEAR(tsDate)= AND p3.iType=1 ORDER BY p1.iNewsletterID DESCA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p2.iArticleID, sTitle, tsArticleDate sDate1, '1' type, SUBSTRING( sBody, 1, 300 ) sBodyHalf FROM ad_amb p1 JOIN join_amb_archivatomic p2 ON p1.iNewsletterID = p2.iNewsletterID JOIN ad_archiv_atomic p3 ON p2.iArticleID = p3.iArticleID WHERE iFlagActive =1 AND MONTH(tsDate)= AND YEAR(tsDate)= AND p3.iType in(1,3,4) AND p1.iNewsletterID= UNION SELECT iID iArticleID, sTitle, sDate sDate1, '2' type, SUBSTRING( sBody, 1, 300 ) sBodyHalf FROM ad_industryupdates WHERE DATE_FORMAT(sDate,'%Y-%m-%d')=CURRENT_DATE() AND sActive =1 ORDER BY sDate1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.iArticleID, p2.sTitle, DATE_FORMAT( tsArticleDate, '%d. %b. %Y' ) tsArticleDate, p1.iNewsletterID, SUBSTRING( sBody, 1, 300 ) sBodyHalf FROM join_amb_archivatomic p1 JOIN ad_archiv_atomic p2 ON p1.iArticleID = p2.iArticleID WHERE p2.iType=2 AND p1.iNewsletterID = (SELECT p1.iNewsletterID FROM ad_amb p1 JOIN join_amb_archivatomic p2 ON p1.iNewsletterID = p2.iNewsletterID JOIN ad_archiv_atomic p3 ON p2.iArticleID = p3.iArticleID WHERE p3.iType=2 ORDER BY tsDate DESC LIMIT 0 , 1) ORDER BY iArticleIDA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.iArticleID, p2.sTitle, DATE_FORMAT( tsArticleDate, '%d. %b. %Y' ) tsDate, p1.iNewsletterID, SUBSTRING( sBody, 1, 300 ) sBodyHalf FROM join_amb_archivatomic p1 JOIN ad_archiv_atomic p2 ON p1.iArticleID = p2.iArticleID WHERE p2.iType=2 AND p1.iNewsletterID<> ORDER BY tsArticleDate DESC,iArticleID LIMIT 0, 8A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p2.iArticleID, sTitle, DATE_FORMAT( tsArticleDate, '%d. %b.' ) sDate, tsArticleDate sDate1, '1' type, SUBSTRING( sBody, 1, 300 ) sBodyHalf FROM ad_amb p1 JOIN join_amb_archivatomic p2 ON p1.iNewsletterID = p2.iNewsletterID JOIN ad_archiv_atomic p3 ON p2.iArticleID = p3.iArticleID WHERE iFlagActive =1 AND p3.iType=1 ORDER BY sDate1 DESC LIMIT 0, 14A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT AMBarticleTotal as article_total FROM ad_totalarticlesA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT iNewsletterID FROM ad_amb WHERE iFlagActive=1 ORDER BY iNewsletterID DESC LIMIT 0,1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT iAdsID, iPositionAfterTopic, sImageLink, sBannerURL, sHeight, sWidth FROM ad_siteads WHERE iIsActive =1 AND sType = "Side" ORDER BY iPositionAfterTopicA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT iAdsID, iPositionAfterTopic, sImageLink, sBannerURL, sHeight, sWidth FROM ad_siteads WHERE iIsActive =1 AND sType = "Home" ORDER BY iPositionAfterTopic limit 2A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT iContent, CASE WHEN iFlag=1 OR iFlag=2 THEN 1 ELSE 0 END blnExclusive, iType FROM op_top_temp WHERE iType <> 'M' ORDER BY iID, iType = 'F', iType = 'T', iType = 'S'A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT iWebinar, sTopic, sDescription, sAuthor, sPathToPhoto, tsDateWebinar, sTimeZone FROM `ad_define_webinar` WHERE tsDateWebinar >= CURRENT_TIMESTAMP( ) ORDER BY tsDateWebinar ASC LIMIT 0 , 1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT sTitle, sContent, sWebsiteName, file_name FROM ad_roundtable ORDER BY scon_id DESC LIMIT 0,1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT sLength FROM ad_frontend_layout WHERE sDivName='Oplaesque Tv' AND sLength>0 AND sLengthPub=1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT thumbimage, thumbtype, title, itemcomment,filepath FROM opalesquetv.op_seyret_items WHERE published=1 and homepage_video='yes' ORDER BY id DESC LIMIT 0,1 A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT SearchText, counter FROM `op_tagged` WHERE SearchText not like '%Quantek%' ORDER BY counter desc limit 55A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT a.no no FROM ad_NewA2_archive a LEFT OUTER JOIN ad_NewA2_faculty b ON a.`iFno` = b.iFid WHERE category <> 'Full A SQUARE issue of the week' AND a.iFno >1 AND sFileName IS NOT NULL AND TRIM( sFileName ) <> ''A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT a.no no, a.title title, a.short_desc short_desc, a.long_desc long_desc, a.category category, a.iFno, b.sFileName, b.sName, SUBSTRING_INDEX( a.long_desc, '.', 1 ) description FROM ad_NewA2_archive a LEFT OUTER JOIN ad_NewA2_faculty b ON a.`iFno` = b.iFid WHERE category <> 'Full A SQUARE issue of the week' AND a.iFno >1 AND sFileName IS NOT NULL AND TRIM( sFileName ) <> '' ORDER BY pub_date DESC LIMIT 0, 1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.iNewsletterID, p3.iArticleID, sTitle FROM ad_amb p1 JOIN join_amb_archivatomic p2 ON p1.iNewsletterID = p2.iNewsletterID JOIN ad_archiv_atomic p3 ON p3.iArticleID = p2.iArticleID WHERE iFlagActive =1 AND p3.iType=1 ORDER BY p3.iArticleID DESC LIMIT 0 , 1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT no, title FROM `ad_NewA2_archive` WHERE category <>'Full A SQUARE issue of the week' ORDER BY no DESC LIMIT 0,1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT a.no no, a.title title, a.short_desc short_desc, a.long_desc long_desc, a.category category, a.iFno, b.sFileName, b.sName, SUBSTRING_INDEX( a.long_desc, '.', 1 ) description FROM ad_NewA2_archive a LEFT OUTER JOIN ad_NewA2_faculty b ON a.`iFno` = b.iFid WHERE category <>'Full A SQUARE issue of the week' ORDER BY pub_date DESC LIMIT 0 , 1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.iId, p1.sTitle, p1.sLongDesc, p1.sFile FROM ad_trb_chart p1 JOIN ad_trb_chart_type p2 ON p1.sType = p2.iTypeID WHERE DATE_FORMAT( dtRegDate, '%d-%m-%Y' ) = ( SELECT DATE_FORMAT( dtRegDate, '%d-%m-%Y' ) FROM ad_trb_chart ORDER BY dtRegDate DESC LIMIT 0 , 1 ) AND p2.iIsActive =1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT p1.iId, p1.sTitle, p1.sLongDesc, p1.sFile FROM ad_trb_chart p1 JOIN ad_trb_chart_type p2 ON p1.sType = p2.iTypeID WHERE DATE_FORMAT( dtRegDate, '%d-%m-%Y' ) = ( SELECT DATE_FORMAT( dtRegDate, '%d-%m-%Y' ) FROM ad_trb_chart ORDER BY dtRegDate DESC LIMIT 0 , 1 ) AND p2.iIsActive =1 LIMIT 0 , 1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT * FROM ad_tr_attachments ORDER BY iTRID DESC LIMIT 0,1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
  • SELECT * FROM op_session WHERE iUserID ='0' ORDER BY created_date DESC LIMIT 0, 1A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.

Not a member yet?
Get Instant Access *

Why register?

Since 2003, Opalesque publishes news and research for finance professionals and investors. Some of this material is not directed at the retail public, therefore registration is required.

Click here for Reader Testimonials and click here to get FREE access to our award-winning publications.

Already a member?
Sign-in here

You can only login, if you are subscribed to our newsletter and your subscription period has already begun.
Cookies must be activated.

Opalesque logon
Password


(Case Sensitive)
 
  Forgot your password?
Today's Exclusives
Today's Other Voices
More Exclusives
Previous Opalesque Exclusives                                  
More Other Voices
Previous Other Voices                                               
Access Alternative Market Briefing