Subscribe to our newsletter for the latest news, productupdates, projects and much more.
Shop our huge range to buy flood lights, including outdoor flood lights, sensor flood lights, security floodlights and more. We have a range of commercial and residential flood lighting to suit your lighting needs. Buy an exterior flood light on your outdoor space today!
SELECT SQL_CALC_FOUND_ROWS arc_posts.ID
FROM arc_posts LEFT JOIN arc_term_relationships ON (arc_posts.ID = arc_term_relationships.object_id)
WHERE 1=1 AND (
arc_term_relationships.term_taxonomy_id IN (61)
) AND ((arc_posts.post_type = 'product' AND (arc_posts.post_status = 'publish' OR arc_posts.post_status = 'acf-disabled' OR arc_posts.post_status = 'wc-ywraq-new' OR arc_posts.post_status = 'wc-ywraq-pending' OR arc_posts.post_status = 'wc-ywraq-expired' OR arc_posts.post_status = 'wc-ywraq-accepted' OR arc_posts.post_status = 'wc-ywraq-rejected')))
GROUP BY arc_posts.ID
ORDER BY arc_posts.menu_order, arc_posts.menu_order ASC
LIMIT 0, 300