Hedge Fund News - Alternative Investments - Hedge Funds Investors and Prime Broker

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 p2.iArticleID NOT IN (641971, 641972) AND p3.iType=1 UNION SELECT iID iArticleID, sTitle, DATE_FORMAT( sDate, '%d. %b.' ) sDate, sDate sDate1, '2' type, SUBSTRING( sBody, 1, 200 ) sBodyHalf FROM ad_industryupdates WHERE sActive =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 p1.sFilename,p2.iTRType,p1.iTRID FROM ad_tr_attachments p1 JOIN ad_technical_research p2 ON p1.iTRID = p2.iTRID where p2.iTRTypeId=1 ORDER BY p2.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 p1.sFilename,p2.iTRType,p1.iTRID FROM ad_tr_attachments p1 JOIN ad_technical_research p2 ON p1.iTRID = p2.iTRID where p2.iTRTypeId=2 ORDER BY p2.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 p1.sFilename,p2.iTRType,p1.iTRID FROM ad_tr_attachments p1 JOIN ad_technical_research p2 ON p1.iTRID = p2.iTRID where p2.iTRTypeId=3 ORDER BY p2.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 ad_roundtable WHERE sWebsiteName ='RoundtableJAPAN'A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.