We use cookies to understand how you use our site and to improve your experience. This includes personalizing content and advertising. To learn more, click here. By continuing to use our site, you accept our use of cookies. Cookie Policy.
Higher Chest X-Ray Usage Catches Lung Cancer Earlier and Improves Survival
By MedImaging International staff writers Posted on 26 Mar 2025
Image: A study has linked increased use of chest X-rays to earlier lung cancer diagnosis and improved survival (Photo courtesy of 123RF)
Lung cancer continues to be the leading cause of cancer-related deaths worldwide. While advanced technologies like CT scanners play a crucial role in detecting lung cancer, more accessible and affordable tools, such as X-rays, are often easier for patients to obtain. However, it was not widely understood whether increasing the number of chest X-rays ordered by general practitioners (GPs) would result in benefits. The frequency of chest X-rays prescribed varies significantly across different GP practices, possibly because some GPs may have been unconvinced of the potential advantages for patients presenting with common symptoms. A new groundbreaking study has revealed a strong connection between the frequency of chest X-ray referrals by GPs and earlier diagnoses, as well as improved survival rates for lung cancer patients.
The study, conducted by researchers from the University of Sheffield (Sheffield, UK), analyzed data from over 170,000 lung cancer patients in England between 2014 and 2018, combined with chest X-ray referral rates from 7,400 GP practices. Published in the British Journal of General Practice, the findings demonstrated that patients at practices with higher rates of chest X-ray referrals were more likely to be diagnosed with lung cancer at an earlier, more treatable stage. These practices also saw a lower rate of diagnoses at later stages of cancer (stages three and four). Additionally, patients from these practices had better survival outcomes both one and five years post-diagnosis, compared to those from practices with lower chest X-ray usage. This study is the first of its kind to link chest X-ray referral rates with national cancer registry data, highlighting the significant impact of early diagnosis on survival.
“Lung cancer remains the leading cause of cancer deaths both in the UK and globally. This is an important step forward in our understanding of how to improve lung cancer detection,” said Dr. Stephen Bradley from the University of Sheffield’s School of Medicine and Population Health who was the lead author of the study. “Our research strongly suggests that increasing the use of chest X-rays for patients with relevant symptoms can lead to earlier diagnosis and, crucially, better chances of survival.”
1
(82.015991210938): SET sql_mode = 'MYSQL40'2
(58.889389038086): SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering3
(297.06954956055): SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 294804453 )
ORDER BY menuid DESC
LIMIT 14
(226.97448730469): DELETE FROM jos_session
WHERE
time < 1758239387
AND guest = 1
AND userid = 05
(41.007995605469): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 16
(33.140182495117): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 17
(30.994415283203): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 18
(311.13624572754): SELECT *
FROM jos_menu
WHERE id = 2948044539
(687.83760070801): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 110
(61.03515625): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 111
(882.86399841309): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND cat=10
AND type='deeppockets_item'
AND published='1'
AND (id<>294804453)
AND (fid=211)
ORDER BY id DESC, `created` DESC
LIMIT 0,1612
(159.97886657715): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND cat=10
AND type='deeppockets_item'
AND published='1'
AND (id<>294804453)
AND (fid=211)
ORDER BY id DESC, `created` DESC
LIMIT 0,1613
(!!!!! 3777.9808044434): 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=211
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=294804453 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 314
(!!!!! 3421.0681915283): 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=211
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=294804453 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 315
(!!!!! 1551.1512756348): 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=294804453 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 316
(!!!!! 1569.9863433838): 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=294804453 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 317
(411.03363037109): SELECT name,id,title FROM jos_deeppockets WHERE id=211 LIMIT 118
(123.97766113281): SELECT name,id,title FROM jos_deeppockets WHERE id=211 LIMIT 119
(566.00570678711): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 120
(83.92333984375): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 121
(534.0576171875): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 122
(71.048736572266): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 123
(73.909759521484): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 124
(97.036361694336): 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.id25
(426.05400085449): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294804453
LIMIT 126
(54.836273193359): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294804453
LIMIT 127
(894.06967163086): 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 = 294804453 )
ORDER BY ordering28
(!!!!! 1317.024230957): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 129
(82.969665527344): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 130
(!!!!! 4485.1303100586): SELECT
*
FROM
jos_bannersmanager_banner
WHERE
`groupid` = 98
AND
`site_id` = 10
AND
`published` = 131
(!!!!! 4289.8654937744): SELECT
*
FROM
jos_bannersmanager_banner
WHERE
`groupid` = 99
AND
`site_id` = 10
AND
`published` = 132
(128.98445129395): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 133
(51.021575927734): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 134
(143.05114746094): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294804453
LIMIT 135
(51.975250244141): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294804453
LIMIT 136
(167.8466796875): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 137
(110.86463928223): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 138
(77.962875366211): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 139
(57.93571472168): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 140
(97.990036010742): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 141
(72.002410888672): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 142
(370.97930908203): SELECT name FROM jos_deeppockets WHERE id=294804453 LIMIT 143
(117.06352233887): 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'44
(574.82719421387): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 145
(!!!!! 1766.9200897217): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 146
(76.055526733398): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 147
(148.05793762207): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 148
(66.041946411133): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 149
(128.03077697754): 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 150
(586.03286743164): SELECT fid FROM jos_deeppockets WHERE id=294804453 AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE id=294804453 AND published='1' LIMIT 151
(391.96014404297): 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=211
ORDER BY `ordering`52
(51.021575927734): select jos_twitters.link from jos_twitters where cat=1053
(30.040740966797): select jos_facebook.link from jos_facebook where cat=1054
(39.100646972656): select jos_google_plus.link from jos_google_plus where cat=1055
(36.954879760742): select jos_linkedin.link from jos_linkedin where cat=1056
(34.093856811523): SELECT fid FROM jos_deeppockets WHERE id=294804453 AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE id=294804453 AND published='1' LIMIT 157
(32.901763916016): 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=211
ORDER BY `ordering`58
(297.06954956055): SELECT fid FROM jos_deeppockets
WHERE cat=10
AND id=294804453
AND (type='deeppockets_item' OR type='deeppockets_item_link')
AND published='1'
LIMIT 159
(!!!!! 1332.9982757568): 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`60
(72.956085205078): SELECT show_live FROM jos_com_show_setting LIMIT 161
(40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 162
(41.007995605469): SELECT show_live FROM jos_com_show_setting LIMIT 163
(35.04753112793): SELECT show_live FROM jos_com_show_setting LIMIT 164
(32.186508178711): SELECT show_live FROM jos_com_show_setting LIMIT 165
(31.948089599609): SELECT show_live FROM jos_com_show_setting LIMIT 166
(31.948089599609): SELECT show_live FROM jos_com_show_setting LIMIT 167
(33.140182495117): SELECT show_live FROM jos_com_show_setting LIMIT 168
(30.994415283203): SELECT show_live FROM jos_com_show_setting LIMIT 169
(45.061111450195): SELECT show_live FROM jos_com_show_setting LIMIT 170
(32.901763916016): SELECT show_live FROM jos_com_show_setting LIMIT 171
(32.901763916016): SELECT show_live FROM jos_com_show_setting LIMIT 172
(32.901763916016): SELECT show_live FROM jos_com_show_setting LIMIT 173
(31.948089599609): SELECT show_live FROM jos_com_show_setting LIMIT 174
(75.817108154297): SELECT fid FROM jos_deeppockets
WHERE cat=10
AND id=294804453
AND (type='deeppockets_item' OR type='deeppockets_item_link')
AND published='1'
LIMIT 175
(42.915344238281): 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`76
(58.889389038086): SELECT show_live FROM jos_com_show_setting LIMIT 177
(40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 178
(36.954879760742): SELECT show_live FROM jos_com_show_setting LIMIT 179
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 180
(46.968460083008): SELECT show_live FROM jos_com_show_setting LIMIT 181
(36.954879760742): SELECT show_live FROM jos_com_show_setting LIMIT 182
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 183
(35.04753112793): SELECT show_live FROM jos_com_show_setting LIMIT 184
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 185
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 186
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 187
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 188
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 189
(36.001205444336): SELECT show_live FROM jos_com_show_setting LIMIT 190
(98.943710327148): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 191
(66.041946411133): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 192
(83.208084106445): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 193
(106.0962677002): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 194
(65.088272094727): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 195
(521.18301391602): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 196
(646.11434936523): 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 197
(426.05400085449): 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 198
(79.154968261719): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 199
(59.843063354492): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1100
(72.956085205078): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1101
(58.889389038086): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1102
(128.98445129395): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1103
(59.127807617188): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1104
(58.889389038086): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1105
(54.836273193359): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1106
(409.12628173828): SELECT * FROM trending_articles WHERE `journal_id` = 10 AND `timestamp` <= NOW() + INTERVAL 7 DAY ORDER BY `order`107
(!!!!! 25413.036346436): 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
7108
(600.09956359863): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294804453 AND type='deeppockets_item' AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294804453 AND type='deeppockets_item' AND published='1' LIMIT 1109
(!!!!! 8677.9594421387): (
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
3110
(104.90417480469): (
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
3111
(348.09112548828): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803337
LIMIT 1112
(48.87580871582): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803337
LIMIT 1113
(299.93057250977): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803276
LIMIT 1114
(82.015991210938): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803276
LIMIT 1115
(288.96331787109): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets_archive AS dp
WHERE
dp.id = 294803276
LIMIT 1116
(51.975250244141): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets_archive AS dp
WHERE
dp.id = 294803276
LIMIT 1117
(292.06275939941): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294802958
LIMIT 1118
(59.127807617188): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294802958
LIMIT 1119
(321.1498260498): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND id=294804453
AND (type='deeppockets_item' OR type='deeppockets_item_link')
AND published='1'
LIMIT 1120
(145.19691467285): SELECT name FROM jos_deeppockets WHERE id=211121
(91.075897216797): SELECT name FROM jos_deeppockets WHERE id=211122
(577.92663574219): 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 '((;)|(^))211((;)|($))' AND catid IN (0,110)
ORDER BY publish_up ASC LIMIT 3123
(508.06999206543): 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 '((;)|(^))211((;)|($))' AND catid IN (0,110)
ORDER BY publish_up ASC LIMIT 3124
(67.949295043945): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1125
(48.160552978516): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1126
(!!!!! 4972.9347229004): TRUNCATE TABLE jos_trademed_module127
(119.92454528809): 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=294804453
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 1128
(571.01249694824): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND id=294804453
AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1129
(57.93571472168): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND id=294804453
AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1130
(217.91458129883): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1131
(114.91775512695): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1132
(!!!!! 4739.0460968018): 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 6133
(129.93812561035): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1134
(68.187713623047): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1135
(50.067901611328): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294804453 AND type='deeppockets_item' AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294804453 AND type='deeppockets_item' AND published='1' LIMIT 1136
(44.107437133789): 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=211 or channel_id is null)137
(40.054321289062): 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=211 or channel_id is null)138
(46.014785766602): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1139
(91.075897216797): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1140
(61.988830566406): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294804453 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294804453 AND published='1'
LIMIT 1141
(109.91096496582): select jos_twitters.link from jos_twitters where cat=10142
(28.133392333984): select jos_facebook.link from jos_facebook where cat=10143
(26.941299438477): select jos_google_plus.link from jos_google_plus where cat=10144
(28.133392333984): select jos_linkedin.link from jos_linkedin where cat=10145
(396.9669342041): update jos_bannersmanager_banner
set impmade=impmade+1
where id in(14615,14202,14203)146
(!!!!! 1077.8903961182): insert into jos_banners_delta values (14615,'2025-09-19 00:04:47','216.73.216.184','view'),(14202,'2025-09-19 00:04:47','216.73.216.184','view'),(14203,'2025-09-19 00:04:47','216.73.216.184','view')