Download Mobile App

Video Library

Featured Links

Medical Imaging Equipment
Trademed.com is our new marketplace where you can buy and sell Imaging equipment.

Automatic Calcium Score Assessment from Coronary CTA Shows Potential to Eliminate Need for Separate Scan

By MedImaging International staff writers
Posted on 02 Aug 2011

Proof-of-concept has been achieved with the first fully automated software that performs calcium scoring directly from a coronary computed tomography angiography (cCTA) study. This technology, the first to show strong correlation with the standard Agatston scoring, has the potential to eliminate the need for a separate calcium score (CS) exam, and thereby reduce costs and decrease patient radiation exposure.

This work in progress is based on Rcadia Medical Imaging (Newton, MA, USA) COR analyzer system technology for fully automatic detection of stenosis in cCTA studies.

CS is an important predictor of coronary artery disease that is typically used by cardiologists. Until recently, a separate calcium scoring CT study was frequently conducted prior to a cCTA exam. With the new generation of CT scanners, CS can be accomplished from cCTA; a separate CS study, which increases the patient’s radiation exposure, has the potential to be avoided. The feasibility of this approach has been demonstrated by a number of studies using semi-automatic segmentation of calcified lesions. Rcadia is developing a system based on a fully automatic approach designed to bring simplicity and consistency into this technique.

To evaluate the diagnostic performance of the system, a retrospective trial was conducted based on cCTA and standard calcium scoring studies of 215 patients. Calcium score automatically computed from cCTA by Rcadia’s software was compared to the Agatston score obtained from nonenhanced calcium scoring studies using the standard technique. The system demonstrated good correlation with the standard Agatston score, achieving 90% accuracy for the classification into five calcium score ranges (0, 1-10, 11-100, 101-400, and above 400). The company believes the trial is the first reported study to match an automatically computed calcium score from cCTA to the standard Agatston score from non-enhanced calcium scoring studies.

“The promising results of this first trial suggest that automatic calcium score assessment has potential to increase the value of the cCTA exam,” said Shai Levanon, president and CEO of Rcadia. “The software will be optimized and validated in future studies.” He noted, “The calcium scoring application is in line with the company’s vision of providing a comprehensive analysis of coronary arteries, including quantitative assessment of the total coronary plaque burden and introduction of an alternative to calcium score with better predictive value.”

Rcadia Medical Imaging, Ltd. develops and markets proprietary computerized systems that automatically detect clinical abnormalities in digital medical images, particularly for patient triage in emergency, life-threatening conditions. The company’s first US Food and Drug Administration (FDA)-cleared product, the COR analyzer system, provides fully automated, real-time analysis of coronary CT angiography to enable the practical application of cCTA in detecting significant coronary artery disease. The COR analyzer improves the utility of coronary CTA studies in the emergency department to triage chest pain patients and optimizes workflow in cardiology and radiology departments.

Related Links:
Rcadia Medical Imaging

Visit expo >

Gold Member

Ultrasound System

FUTUS LE

Gold Member

Electrode Solution and Skin Prep

Signaspray

Imaging Table

Stille imagiQ2

Silver Member

Solid State Kv/Dose Multi-Sensor

AGMS-DM+

Latest Imaging IT News

Channels

MRI

view channel

Image: PET/MRI can accurately classify prostate cancer patients (Photo courtesy of 123RF)

PET/MRI Improves Diagnostic Accuracy for Prostate Cancer Patients

The Prostate Imaging Reporting and Data System (PI-RADS) is a five-point scale to assess potential prostate cancer in MR images. PI-RADS category 3 which offers an unclear suggestion of clinically significant... Read more

Next Generation MR-Guided Focused Ultrasound Ushers In Future of Incisionless Neurosurgery

Essential tremor, often called familial, idiopathic, or benign tremor, leads to uncontrollable shaking that significantly affects a person’s life. When traditional medications do not alleviate symptoms,... Read more

Image: Shorter scan to diagnose prostate cancer can increase availability and reduce cost (Photo courtesy of 123RF)

Two-Part MRI Scan Detects Prostate Cancer More Quickly without Compromising Diagnostic Quality

Prostate cancer ranks as the most prevalent cancer among men. Over the last decade, the introduction of MRI scans has significantly transformed the diagnosis process, marking the most substantial advancement... Read more

World’s Most Powerful MRI Machine Images Living Brain with Unrivaled Clarity

The world's most powerful magnetic resonance imaging (MRI) scanner has generated its first images of the human brain, demonstrating new precision levels that could shed more light on the mysterious human... Read more

Ultrasound

view channel

Deep Learning Advances Super-Resolution Ultrasound Imaging

Ultrasound localization microscopy (ULM) is an advanced imaging technique that offers high-resolution visualization of microvascular structures. It employs microbubbles, FDA-approved contrast agents, injected... Read more

Image: Schematic diagram of the ultrasound-stimulated phase-shift nanoparticle drug delivery system for biofilm therapy (Photo courtesy of BIO Integration)

Novel Ultrasound-Launched Targeted Nanoparticle Eliminates Biofilm and Bacterial Infection

Biofilms, formed by bacteria aggregating into dense communities for protection against harsh environmental conditions, are a significant contributor to various infectious diseases. Biofilms frequently... Read more

AI-Guided Ultrasound System Enables Rapid Assessments of DVT

Deep vein thrombosis (DVT), a condition in which a blood clot is usually found in the leg, is a major cause of preventable hospital death in Europe and the United States. Patients have to wait for hours... Read more

Image: The QA protocol will ensure guided focused ultrasound devices and treatment is safe and function consistently (Photo courtesy of Chen Lab)

Focused Ultrasound Technique Gets Quality Assurance Protocol

In recent years, researchers have harnessed the potential of focused ultrasound (FUS) in combination with microbubbles to temporarily open the blood-brain barrier (BBB), a method that significantly enhances... Read more

Nuclear Medicine

view channel

New SPECT/CT Technique Could Change Imaging Practices and Increase Patient Access

The development of lead-212 (212Pb)-PSMA–based targeted alpha therapy (TAT) is garnering significant interest in treating patients with metastatic castration-resistant prostate cancer. The imaging of 212Pb,... Read more

New Radiotheranostic System Detects and Treats Ovarian Cancer Noninvasively

Ovarian cancer is the most lethal gynecological cancer, with less than a 30% five-year survival rate for those diagnosed in late stages. Despite surgery and platinum-based chemotherapy being the standard... Read more

AI System Automatically and Reliably Detects Cardiac Amyloidosis Using Scintigraphy Imaging

Cardiac amyloidosis, a condition characterized by the buildup of abnormal protein deposits (amyloids) in the heart muscle, severely affects heart function and can lead to heart failure or death without... Read more

Early 30-Minute Dynamic FDG-PET Acquisition Could Halve Lung Scan Times

F-18 FDG-PET scans are a way to look inside the body using a special dye, and these scans can be either static or dynamic. Static scans happen 60 minutes after the dye is administered into the body, showing... Read more

General/Advanced Imaging

view channel

Image: The Tyche machine-learning model could help capture crucial information. (Photo courtesy of 123RF)

New AI Method Captures Uncertainty in Medical Images

In the field of biomedicine, segmentation is the process of annotating pixels from an important structure in medical images, such as organs or cells. Artificial Intelligence (AI) models are utilized to... Read more

CT Coronary Angiography Reduces Need for Invasive Tests to Diagnose Coronary Artery Disease

Coronary artery disease (CAD), one of the leading causes of death worldwide, involves the narrowing of coronary arteries due to atherosclerosis, resulting in insufficient blood flow to the heart muscle.... Read more

$Image: An amyloid blood test can help identify patients who may forgo imaging evaluation for Alzheimer\'s disease (Photo courtesy of 123RF)$

Novel Blood Test Could Reduce Need for PET Imaging of Patients with Alzheimer’s

Alzheimer's disease (AD), a condition marked by cognitive decline and the presence of beta-amyloid (Aβ) plaques and neurofibrillary tangles in the brain, poses diagnostic challenges. Amyloid positron emission... Read more

CT-Based Deep Learning Algorithm Accurately Differentiates Benign From Malignant Vertebral Fractures

The rise in the aging population is expected to result in a corresponding increase in the prevalence of vertebral fractures which can cause back pain or neurologic compromise, leading to impaired function... Read more

Imaging IT

view channel

New Google Cloud Medical Imaging Suite Makes Imaging Healthcare Data More Accessible

Medical imaging is a critical tool used to diagnose patients, and there are billions of medical images scanned globally each year. Imaging data accounts for about 90% of all healthcare data1 and, until... Read more

Global AI in Medical Diagnostics Market to Be Driven by Demand for Image Recognition in Radiology

The global artificial intelligence (AI) in medical diagnostics market is expanding with early disease detection being one of its key applications and image recognition becoming a compelling consumer proposition... Read more

AI-Based Mammography Triage Software Helps Dramatically Improve Interpretation Process

An artificial intelligence (AI)-based mammography triage software is helping dramatically improve the interpretation process for healthcare providers. In a new study, researchers at the Scripps Green... Read more

Artificial Intelligence (AI) Program Accurately Predicts Lung Cancer Risk from CT Images

An artificial intelligence (AI) program accurately predicts the risk that lung nodules detected on screening CT will become cancerous, according to a study published in the journal Radiology.... Read more

Industry News

view channel

1 (99.897384643555): SET sql_mode = 'MYSQL40'

2 (60.081481933594): SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering

3 (273.22769165039): SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 294736407 ) ORDER BY menuid DESC LIMIT 1

4 (132.08389282227): DELETE FROM jos_session WHERE time < 1750354366 AND guest = 1 AND userid = 0

5 (36.001205444336): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1

6 (42.915344238281): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1

7 (30.994415283203): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1

8 (208.13941955566): SELECT * FROM jos_menu WHERE id = 294736407

9 (516.89147949219): SELECT dp.*, ch.title as channel, ch.name as channel_name, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 #AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

10 (748.1575012207): SELECT dp.*, ch.title as channel, ch.name as channel_name, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 #AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

11 (97.036361694336): SELECT dp.*, ch.title as channel, ch.name as channel_name, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 #AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

12 (967.97943115234): SELECT * FROM jos_deeppockets WHERE 1=1 AND cat=10 AND type='deeppockets_item' AND published='1' AND (id<>294736407) AND (fid=216) ORDER BY id DESC, `created` DESC LIMIT 0,16

13 (134.94491577148): SELECT * FROM jos_deeppockets WHERE 1=1 AND cat=10 AND type='deeppockets_item' AND published='1' AND (id<>294736407) AND (fid=216) ORDER BY id DESC, `created` DESC LIMIT 0,16

14 (!!!!! 3909.1110229492): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_item.fid=216 and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=294736407 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3

15 (!!!!! 3530.9791564941): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_item.fid=216 and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=294736407 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3

16 (!!!!! 1592.8745269775): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=294736407 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3

17 (!!!!! 1920.9384918213): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=294736407 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3

18 (291.10908508301): SELECT name,id,title FROM jos_deeppockets WHERE id=216 LIMIT 1

19 (35.04753112793): SELECT name,id,title FROM jos_deeppockets WHERE id=216 LIMIT 1

20 (355.00526428223): SELECT dp.*, ch.title as channel, ch.name as channel_name FROM jos_deeppockets as dp LEFT JOIN jos_deeppockets as ch ON ch.id = dp.fid WHERE 1=1 AND dp.id=294736406 AND dp.type='deeppockets_item' AND dp.published='1' LIMIT 1

21 (288.00964355469): SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736406 AND type='deeppockets_item' AND published='1' LIMIT 1

22 (303.03001403809): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

23 (339.03121948242): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

24 (53.167343139648): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

25 (46.014785766602): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

26 (464.91622924805): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

27 (339.98489379883): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

28 (65.088272094727): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

29 (48.87580871582): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

30 (345.23010253906): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

31 (339.98489379883): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

32 (96.797943115234): SELECT conference_items.channel_id, conference_items.tracking_code FROM conference_items LEFT JOIN conference_groups ON conference_groups.id = conference_items.group_id LEFT JOIN jos_deeppockets ON jos_deeppockets.id = conference_items.channel_id LEFT JOIN jos_journal ON jos_journal.cat = jos_deeppockets.cat AND jos_journal.real = 1 AND jos_journal.directory IS NOT NULL WHERE 1 = 1 ORDER BY conference_items.id

33 (186.92016601562): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294736406 LIMIT 1

34 (34.093856811523): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294736406 LIMIT 1

35 (222.92137145996): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets_archive AS dp WHERE dp.id = 294736406 LIMIT 1

36 (34.093856811523): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets_archive AS dp WHERE dp.id = 294736406 LIMIT 1

37 (50.067901611328): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294736406 LIMIT 1

38 (58.889389038086): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294736406 LIMIT 1

39 (32.186508178711): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets_archive AS dp WHERE dp.id = 294736406 LIMIT 1

40 (28.133392333984): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets_archive AS dp WHERE dp.id = 294736406 LIMIT 1

41 (854.9690246582): SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 294736407 ) ORDER BY ordering

42 (967.97943115234): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

43 (49.114227294922): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

44 (66.041946411133): SELECT * FROM jos_bannersmanager_banner WHERE `groupid` = 98 AND `site_id` = 10 AND `published` = 1

45 (41.961669921875): SELECT * FROM jos_bannersmanager_banner WHERE `groupid` = 99 AND `site_id` = 10 AND `published` = 1

46 (81.062316894531): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

47 (54.121017456055): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

48 (107.0499420166): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

49 (46.968460083008): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

50 (97.036361694336): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

51 (86.069107055664): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

52 (185.96649169922): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

53 (69.856643676758): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

54 (348.80638122559): SELECT name FROM jos_deeppockets WHERE id=294736407 LIMIT 1

55 (262.02201843262): SELECT name FROM jos_deeppockets_archive WHERE id=294736407 LIMIT 1

56 (56.982040405273): SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'

57 (61.03515625): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

58 (442.9817199707): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

59 (!!!!! 1360.8932495117): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

60 (66.041946411133): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

61 (159.02519226074): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

62 (58.889389038086): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

63 (103.95050048828): select cover from jos_number where journalid in (5) and cover is not null order by left(issue,2)+right(issue,2)*12 desc limit 1

64 (486.85073852539): SELECT fid FROM jos_deeppockets WHERE id=294736407 AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE id=294736407 AND published='1' LIMIT 1

65 (298.97689819336): SELECT id,name,sponsor_text FROM jos_deeppockets dp left outer join jos_channel_sponsor cs on dp.id=cs.fid WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id=216 ORDER BY `ordering`

66 (70.810317993164): select jos_twitters.link from jos_twitters where cat=10

67 (34.093856811523): select jos_facebook.link from jos_facebook where cat=10

68 (30.994415283203): select jos_google_plus.link from jos_google_plus where cat=10

69 (30.040740966797): select jos_linkedin.link from jos_linkedin where cat=10

70 (30.994415283203): SELECT fid FROM jos_deeppockets WHERE id=294736407 AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE id=294736407 AND published='1' LIMIT 1

71 (31.948089599609): SELECT id,name,sponsor_text FROM jos_deeppockets dp left outer join jos_channel_sponsor cs on dp.id=cs.fid WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id=216 ORDER BY `ordering`

72 (340.93856811523): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

73 (252.00843811035): SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

74 (46.014785766602): SELECT id,name,title FROM jos_deeppockets WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id != 294743300 AND id != 294743301 AND id != 294743302 AND id != 294743303 AND id != 294743304 AND id != 294743305 AND id != 294743306 AND id != 294743307 AND id != 294743308 AND id != 294743309 AND id != 294743310 AND metakey != 'aacc' ORDER BY `ordering`

75 (48.87580871582): SELECT show_live FROM jos_com_show_setting LIMIT 1

76 (31.948089599609): SELECT show_live FROM jos_com_show_setting LIMIT 1

77 (28.133392333984): SELECT show_live FROM jos_com_show_setting LIMIT 1

78 (29.087066650391): SELECT show_live FROM jos_com_show_setting LIMIT 1

79 (26.941299438477): SELECT show_live FROM jos_com_show_setting LIMIT 1

80 (27.894973754883): SELECT show_live FROM jos_com_show_setting LIMIT 1

81 (36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 1

82 (36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 1

83 (40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 1

84 (36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 1

85 (29.087066650391): SELECT show_live FROM jos_com_show_setting LIMIT 1

86 (29.087066650391): SELECT show_live FROM jos_com_show_setting LIMIT 1

87 (27.894973754883): SELECT show_live FROM jos_com_show_setting LIMIT 1

88 (27.894973754883): SELECT show_live FROM jos_com_show_setting LIMIT 1

89 (51.021575927734): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

90 (30.994415283203): SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

91 (32.901763916016): SELECT id,name,title FROM jos_deeppockets WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id != 294743300 AND id != 294743301 AND id != 294743302 AND id != 294743303 AND id != 294743304 AND id != 294743305 AND id != 294743306 AND id != 294743307 AND id != 294743308 AND id != 294743309 AND id != 294743310 AND metakey != 'aacc' ORDER BY `ordering`

92 (56.982040405273): SELECT show_live FROM jos_com_show_setting LIMIT 1

93 (32.901763916016): SELECT show_live FROM jos_com_show_setting LIMIT 1

94 (28.133392333984): SELECT show_live FROM jos_com_show_setting LIMIT 1

95 (27.894973754883): SELECT show_live FROM jos_com_show_setting LIMIT 1

96 (26.941299438477): SELECT show_live FROM jos_com_show_setting LIMIT 1

97 (27.894973754883): SELECT show_live FROM jos_com_show_setting LIMIT 1

98 (36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 1

99 (27.894973754883): SELECT show_live FROM jos_com_show_setting LIMIT 1

100 (28.133392333984): SELECT show_live FROM jos_com_show_setting LIMIT 1

101 (26.941299438477): SELECT show_live FROM jos_com_show_setting LIMIT 1

102 (26.941299438477): SELECT show_live FROM jos_com_show_setting LIMIT 1

103 (26.941299438477): SELECT show_live FROM jos_com_show_setting LIMIT 1

104 (33.855438232422): SELECT show_live FROM jos_com_show_setting LIMIT 1

105 (38.14697265625): SELECT show_live FROM jos_com_show_setting LIMIT 1

106 (66.995620727539): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

107 (41.961669921875): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

108 (75.817108154297): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

109 (56.982040405273): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

110 (74.863433837891): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

111 (42.915344238281): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

112 (414.13307189941): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

113 (367.87986755371): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

114 (50.067901611328): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

115 (334.9781036377): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.id=294736406 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

116 (674.00932312012): SELECT dp.name, dp.id, dp2.name as channel, ex.name as author_name, ex.specialization, ex.images FROM jos_deeppockets as dp LEFT JOIN jos_experts as ex ON ex.id = dp.author LEFT JOIN jos_deeppockets as dp2 ON dp2.id = dp.fid WHERE dp.author != 0 AND dp.cat = 10 AND dp.published = 1 AND ( (dp.fid = 294743300) OR (dp.fid = 294743301) OR (dp.fid = 294743302) OR (dp.fid = 294743303) OR (dp.fid = 294743304) OR (dp.fid = 294743305) OR (dp.fid = 294743306) OR (dp.fid = 294743307) OR (dp.fid = 294743308) OR (dp.fid = 294743309) OR (dp.fid = 294743310) ) ORDER BY RAND() LIMIT 1

117 (!!!!! 5510.0917816162): SELECT dp.name, dp.id, dp2.name as channel, ex.name as author_name, ex.specialization, ex.images FROM jos_deeppockets as dp LEFT JOIN jos_experts as ex ON ex.id = dp.author LEFT JOIN jos_deeppockets as dp2 ON dp2.id = dp.fid WHERE dp.author != 0 AND dp.cat = 10 AND dp.published = 1 AND ( (dp.fid = 294743300) OR (dp.fid = 294743301) OR (dp.fid = 294743302) OR (dp.fid = 294743303) OR (dp.fid = 294743304) OR (dp.fid = 294743305) OR (dp.fid = 294743306) OR (dp.fid = 294743307) OR (dp.fid = 294743308) OR (dp.fid = 294743309) OR (dp.fid = 294743310) ) ORDER BY RAND() LIMIT 1

118 (309.22889709473): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

119 (150.91896057129): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

120 (253.91578674316): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

121 (109.19570922852): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

122 (182.8670501709): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

123 (277.04238891602): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

124 (297.06954956055): SELECT * FROM trending_articles WHERE `journal_id` = 10 AND `timestamp` <= NOW() + INTERVAL 7 DAY ORDER BY `order`

125 (!!!!! 55624.008178711): SELECT * FROM jos_deeppockets WHERE jos_deeppockets.cat = 10 AND jos_deeppockets.type = 'deeppockets_item' AND jos_deeppockets.published = 1 AND jos_deeppockets.created + INTERVAL 14 DAY >= NOW() ORDER BY jos_deeppockets.hits DESC LIMIT 7

126 (!!!!! 1217.1268463135): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

127 (77.009201049805): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

128 (382.90023803711): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294736407 AND type='deeppockets_item' AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294736407 AND type='deeppockets_item' AND published='1' LIMIT 1

129 (!!!!! 807237.86354065): ( SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.video != '' AND dp.video_source != '' AND dp.cat = 10 AND dp.published = 1 AND dp.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) UNION ( SELECT dpa.id, dpa.name, dpa.title, dpa.video, dpa.video_source, dpa.created FROM jos_deeppockets_archive AS dpa WHERE dpa.video != '' AND dpa.video_source != '' AND dpa.cat = 10 AND dpa.published = 1 AND dpa.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) ORDER BY created DESC LIMIT 3

130 (116.10984802246): ( SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.video != '' AND dp.video_source != '' AND dp.cat = 10 AND dp.published = 1 AND dp.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) UNION ( SELECT dpa.id, dpa.name, dpa.title, dpa.video, dpa.video_source, dpa.created FROM jos_deeppockets_archive AS dpa WHERE dpa.video != '' AND dpa.video_source != '' AND dpa.cat = 10 AND dpa.published = 1 AND dpa.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) ORDER BY created DESC LIMIT 3

131 (60.081481933594): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294800513 LIMIT 1

132 (42.915344238281): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294800513 LIMIT 1

133 (63.896179199219): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294800359 LIMIT 1

134 (34.809112548828): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294800359 LIMIT 1

135 (43.869018554688): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294800361 LIMIT 1

136 (52.928924560547): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294800361 LIMIT 1

137 (498.05641174316): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

138 (439.88227844238): SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

139 (251.05476379395): SELECT name FROM jos_deeppockets WHERE id=216

140 (36.001205444336): SELECT name FROM jos_deeppockets WHERE id=216

141 (468.01567077637): SELECT *, DATE_FORMAT(publish_up,'%d %b %Y') AS date_publish_up, DATE_FORMAT(publish_down,'%d %b %Y') AS date_publish_down FROM jos_events WHERE state=1 AND publish_up > NOW() and extra_info REGEXP '((;)|(^))216((;)|($))' AND catid IN (0,110) ORDER BY publish_up ASC LIMIT 3

142 (427.0076751709): SELECT *, DATE_FORMAT(publish_up,'%d %b %Y') AS date_publish_up, DATE_FORMAT(publish_down,'%d %b %Y') AS date_publish_down FROM jos_events WHERE state=1 AND publish_up > NOW() and extra_info REGEXP '((;)|(^))216((;)|($))' AND catid IN (0,110) ORDER BY publish_up ASC LIMIT 3

143 (64.13459777832): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

144 (51.975250244141): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

145 (!!!!! 10125.875473022): TRUNCATE TABLE jos_trademed_module

146 (134.94491577148): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

147 (717.8783416748): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp LEFT JOIN jos_experts as exp ON exp.id = dp.author LEFT JOIN jos_deeppockets as ch ON dp.fid = ch.id WHERE 1=1 AND dp.cat=10 AND dp.id=294736407 AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link') AND dp.published='1' LIMIT 1

148 (472.7840423584): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

149 (67.949295043945): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1

150 (98.943710327148): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

151 (73.909759521484): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

152 (!!!!! 1641.9887542725): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='L' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) ORDER BY RAND() DESC LIMIT 6

153 (163.07830810547): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

154 (117.06352233887): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

155 (79.870223999023): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294736407 AND type='deeppockets_item' AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294736407 AND type='deeppockets_item' AND published='1' LIMIT 1

156 (51.975250244141): select distinct links.* from jos_textlinks links join jos_textlinks_placement placement on links.id=placement.link_id where journal_id=(10) and (channel_id=0 or channel_id is null)

157 (45.7763671875): select distinct links.* from jos_textlinks links join jos_textlinks_placement placement on links.id=placement.link_id where journal_id=(10) and (channel_id=0 or channel_id is null)

158 (37.908554077148): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1

159 (63.896179199219): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

160 (48.160552978516): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294736407 AND published='1' union SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294736407 AND published='1' LIMIT 1

161 (44.107437133789): select jos_twitters.link from jos_twitters where cat=10

162 (35.04753112793): select jos_facebook.link from jos_facebook where cat=10

163 (36.954879760742): select jos_google_plus.link from jos_google_plus where cat=10

164 (34.809112548828): select jos_linkedin.link from jos_linkedin where cat=10

165 (488.0428314209): update jos_bannersmanager_banner set impmade=impmade+1 where id in(14615,14202,14203)

166 (!!!!! 1467.9431915283): insert into jos_banners_delta values (14615,'2025-06-19 17:47:47','216.73.216.120','view'),(14202,'2025-06-19 17:47:47','216.73.216.120','view'),(14203,'2025-06-19 17:47:47','216.73.216.120','view')

Click for LinkXpress Reader Inquiry Service
Enter code to receive information:

Where I can find code?

LinkXpress

Download Mobile App

Video Library

Featured Links

Automatic Calcium Score Assessment from Coronary CTA Shows Potential to Eliminate Need for Separate Scan

Latest Imaging IT News

Channels

MedImaging

Channels

Features

Partner Sites

Archive: