Outdoor Lighting - Project Collection

selected filters

location: exterior

SELECT p.m_id, p.m_ref, p.m_shortdescription, p.m_finish, p.m_new, p.m_specialorder, i.m_image, s.m_name, s.m_id as s_id, (SELECT i2.m_image FROM s_products p2 INNER JOIN product_images i2 ON i2.m_productid = p2.m_id WHERE p2.m_ref = i2.m_ref ORDER BY CASE p2.m_primary WHEN 'Y' THEN '1' ELSE '999' END asc LIMIT 1) as productimage FROM s_products p INNER JOIN s_subcategories s ON s.m_id = p.m_subcategory INNER JOIN product_images i ON i.m_productid = p.m_id WHERE p.m_active = 'Y' AND p.m_specification = '' AND EXISTS ( SELECT 1 FROM s_filter_producttags WHERE product_id = p.m_id AND filtertag_id IN (2) ) AND p.m_primary = 'Y' ORDER BY s.m_order ASC, p.m_order ASC, s.m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '294' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Beaumont Spike

beaumont spike

OD-BEA-G

Beaumont

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '315' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Connaught Plus

connaught plus

OD-CONP-G

Connaught Plus

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '308' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Farringdon Plus, Black

farringdon plus, black

OD-FARP

Farringdon Plus

Black

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '307' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

farringdon pole

farringdon pole

OD-FPOLE

Farringdon Pole

Black

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '295' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Savoy

savoy

OD-SAV-G

Savoy

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '296' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Savoy Plus

savoy plus

OD-SAVP-G

Savoy Plus

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '291' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

new

sophie IP65 recessed

sophie ip65 recessed

DL-SOPWB

Sophie

White

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '297' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

new

Trafalgar GU10, Black

trafalgar gu10, black

OD-TRA-B

Trafalgar

Black

White

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '232' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Grosvenor II 80, Graphite

grosvenor ii 80, graphite

OD-GRO280-G

Grosvenor II

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '232' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Grosvenor II 30, Graphite

grosvenor ii 30, graphite

OD-GRO230-G

Grosvenor II

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '107' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Lanesborough

lanesborough

OD-LAN-G

Lanesborough

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '93' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Holborn SS

holborn ss

IPR-HOLSS

Holborn

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '98' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Hoxton CP

hoxton cp

IPR-HOXCP

Hoxton

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '156' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

new

Pyrenees IP65 350mA W 3000k

pyrenees ip65 350ma w 3000k

IPR-WRB

Pyrenees IP65

Black

White

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '174' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

new

Simplon IP65 350mA W 3000k

simplon ip65 350ma w 3000k

IPR-WSLB

Simplon IP65

Black

White

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '72' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Euston

euston

IPR-EUSSS

Euston

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '50' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Connaught

connaught

OD-CON-G

Connaught

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '214' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Waldorf 1 Graphite

waldorf 1 graphite

OD-WAL1-G

Waldorf I

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '154' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Plot 4 SS

plot 4 ss

IPR-PLOT4SS

Plot

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '147' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Paddington Round 30°

paddington round 30°

IPR-PADSSS30

Paddington

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '166' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Sapporo Square

sapporo square

OD-SAPS-GW

Sapporo Square

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '149' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Piccadilly Round SS

piccadilly round ss

IPR-PICRSS

Piccadilly

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '188' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Strand

strand

OD-STR-G

Strand

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '58' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Dorchester Wall Graphite

dorchester wall graphite

OD-DORW-G

Dorchester Wall

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '105' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Kyoto Medium

kyoto medium

OD-KYOM

Kyoto

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '122' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Mayfair

mayfair

OD-MAY-G

Mayfair

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '73' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Farringdon Spike Spot AC

farringdon spike spot ac

OD-FARR

Farringdon

Black

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '233' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Grosvenor 30, Graphite

grosvenor 30, graphite

OD-GRO30-G

Grosvenor I

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '233' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Grosvenor 80, Graphite

grosvenor 80, graphite

OD-GRO80-G

Grosvenor I

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '194' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Tokyo

tokyo

OD-TOKYO

Tokyo

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '190' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Suzuka Slot

suzuka slot

OD-SUZ-GW

Suzuka

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '215' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Waldorf 2 Graphite

waldorf 2 graphite

OD-WAL2-G

Waldorf II

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '218' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Yokahama

yokahama

OD-YOK

Yokohama

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '165' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Sapporo Long

sapporo long

OD-SAPL-GW

Sapporo Long

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '164' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Sanderson 80, Graphite

sanderson 80, graphite

OD-SAN80-G

Sanderson

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '104' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Kobe Large

kobe large

OD-KOBL

Kobe

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '57' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Dorchester Bollard Graphite

dorchester bollard graphite

OD-DORB80-G

Dorchester Bollard

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '29' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Berkeley II

berkeley ii

OD-BER2-G

Berkeley II

Dark Grey

SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '43' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;

Chiba

chiba

OD-CHIBA

Chiba

Dark Grey

© Project 2025
Privacy
Terms & Conditions