A Square:

SELECT COUNT(*) article_total 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 =1A 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 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 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 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 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 iID, iPubName, iPrefix FROM ad_publications ORDER BY iIDA database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.
SELECT p2.sName, p2.sExpertiseArea, p1.file_name, p2.sFileName, p2.iFileSize, p1.iFno, p1.as_main, p1.no, p1.category, p1.pub_date, title, short_desc, long_desc, iFid,author_name, long_desc as description FROM ad_NewA2_archive p1 LEFT OUTER JOIN ad_NewA2_faculty p2 ON p1.iFno = p2.iFid WHERE no='394'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.pub_date pub_date, a.author_name author_name, a.file_name file_name, a.as_main as_main, a.category category FROM ad_NewA2_archive a WHERE (category LIKE '%%') AND no <> ORDER BY pub_date 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.sForename, p2.sName, Comment , iCommentDate, showName FROM op_a2_comment p1 JOIN op_user p2 ON p1.iUserID = p2.iUserID WHERE iArticleID=394 ORDER BY iCommentDate DESC A database error has occured. If this happens again, please contact support@opalesque.com with a short description of the problem. Thank you.

No records found.