WordPress database error: [Unknown column 'sliders2.slider_status' in 'where clause']
SELECT sliders.*,
IF(sliders.thumbnail != '',
sliders.thumbnail,
IF(sliders.type != 'group',
(SELECT slides.thumbnail FROM wpec_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1),
''
)
) AS thumbnail,
IF(sliders.type != 'group',
(SELECT count(*) FROM wpec_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider),
(SELECT count(*) FROM wpec_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wpec_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id)
) AS slides
FROM wpec_nextend2_smartslider3_sliders AS sliders
LEFT JOIN wpec_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id
WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published'
ORDER BY ordering ASC
WordPress database error: [Unknown column 'sliders2.slider_status' in 'where clause']
SELECT sliders.*,
IF(sliders.thumbnail != '',
sliders.thumbnail,
IF(sliders.type != 'group',
(SELECT slides.thumbnail FROM wpec_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1),
''
)
) AS thumbnail,
IF(sliders.type != 'group',
(SELECT count(*) FROM wpec_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider),
(SELECT count(*) FROM wpec_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wpec_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id)
) AS slides
FROM wpec_nextend2_smartslider3_sliders AS sliders
LEFT JOIN wpec_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id
WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published'
ORDER BY ordering ASC
WordPress database error: [Unknown column 'sliders2.slider_status' in 'where clause']
SELECT sliders.*,
IF(sliders.thumbnail != '',
sliders.thumbnail,
IF(sliders.type != 'group',
(SELECT slides.thumbnail FROM wpec_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1),
''
)
) AS thumbnail,
IF(sliders.type != 'group',
(SELECT count(*) FROM wpec_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider),
(SELECT count(*) FROM wpec_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wpec_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id)
) AS slides
FROM wpec_nextend2_smartslider3_sliders AS sliders
LEFT JOIN wpec_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id
WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published'
ORDER BY ordering ASC
WordPress database error: [Unknown column 'sliders2.slider_status' in 'where clause']
SELECT sliders.*,
IF(sliders.thumbnail != '',
sliders.thumbnail,
IF(sliders.type != 'group',
(SELECT slides.thumbnail FROM wpec_nextend2_smartslider3_slides AS slides WHERE slides.slider = sliders.id AND slides.published = 1 AND slides.generator_id = 0 AND slides.thumbnail NOT LIKE '' ORDER BY slides.first DESC, slides.ordering ASC LIMIT 1),
''
)
) AS thumbnail,
IF(sliders.type != 'group',
(SELECT count(*) FROM wpec_nextend2_smartslider3_slides AS slides2 WHERE slides2.slider = sliders.id GROUP BY slides2.slider),
(SELECT count(*) FROM wpec_nextend2_smartslider3_sliders_xref AS xref2 LEFT JOIN wpec_nextend2_smartslider3_sliders AS sliders2 ON sliders2.id = xref2.slider_id WHERE xref2.group_id = sliders.id AND sliders2.slider_status LIKE 'published' GROUP BY xref2.group_id)
) AS slides
FROM wpec_nextend2_smartslider3_sliders AS sliders
LEFT JOIN wpec_nextend2_smartslider3_sliders_xref AS xref ON xref.slider_id = sliders.id
WHERE (xref.group_id IS NULL OR xref.group_id = 0) AND sliders.slider_status LIKE 'published'
ORDER BY ordering ASC
An informational film released by National Counter Terrorism Policing providing advice on actions to take to keep safe in the event of a firearms or weapons attack. https://lnkd.in/dQE-EcW #security #staysafe #counterterrorism #runhidetell
