-- Table structure for table `library_pdf`
--

CREATE TABLE `library_pdf` (
  `library_id` int(11) NOT NULL,
  `pdf_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `library_pdf`
--

INSERT INTO `library_pdf` (`library_id`, `pdf_id`) VALUES
(20, 47),
(22, 74),
(24, 71),
(24, 78),
(24, 79),
(24, 80),
(24, 82),
(24, 83),
(24, 84),
(25, 71),
(25, 78),
(25, 79),
(25, 80),
(25, 82),
(25, 83),
(25, 84),
(26, 71),
(26, 82),
(26, 83),
(26, 84),
(31, 71),
(31, 82),
(31, 83),
(31, 84),
(35, 80),
(36, 80),
(37, 80),
(40, 94),
(41, 94),
(42, 94),
(56, 115),
(56, 119),
(58, 119),
(59, 119);

-- --------------------------------------------------------

--
-- Table structure for table `manufacturers`
--

CREATE TABLE `manufacturers` (
  `manf_id` int(10) UNSIGNED NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  `coming_soon` tinyint(3) UNSIGNED NOT NULL,
  `brand_id` tinyint(3) UNSIGNED NOT NULL,
  `manf_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `search_banner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` smallint(6) NOT NULL,
  `region_id` smallint(6) NOT NULL,
  `city_id` mediumint(9) NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone1` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone2` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dt` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manufacturers`
--

INSERT INTO `manufacturers` (`manf_id`, `active`, `coming_soon`, `brand_id`, `manf_name`, `code`, `description`, `logo`, `url`, `search_banner`, `country_id`, `region_id`, `city_id`, `address`, `email1`, `email2`, `phone1`, `phone2`, `dt`) VALUES
(1, 1, 0, 2, 'Metalux', 'MTX', 'Commercial and Industrial LED Lighting.', '', '', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(2, 1, 0, 2, 'Invue', 'INV', 'Exterior Lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(3, 1, 0, 2, 'McGraw-Edison', 'MGE', 'Area, Site Lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(4, 1, 0, 2, 'Lumiereold', 'LUM', 'Landscape Lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(5, 1, 0, 4, 'Juno', 'JNO', 'Retail Lighting, Commercial, Residential. Downlights, Track.', '', 'https://juno.acuitybrands.com/en/', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(6, 1, 0, 4, 'Indy', 'IND', 'Retail Lighting. Commercial Lighting, Cylinders, Multiples, Downlights.', '', 'https://indy.acuitybrands.com/en/', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(7, 1, 0, 4, 'Aculux', 'ALX', 'Commercial and Residential downlighting.', '', 'https://aculux.acuitybrands.com/en/', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(9, 1, 0, 1, 'Erco', 'ERC', 'Retail Lighting', '', '', '', 237, 0, 0, '', '', '', '', '', '2015-07-05'),
(10, 1, 0, 1, 'Targetti', 'TRG', 'Retail Lighting', '', 'http://targettiusa.net/', 'images/mnf-search-banners/mnf-search-banners-1/10-Targetti_toplogo.jpg', 237, 0, 0, 'United States', '', '', '', '', '2015-07-05'),
(12, 1, 1, 4, 'Mark Architectural', 'MAR', 'Indoor lighting.', '', 'https://www.acuitybrands.com/brands/lighting/mark', '', 237, 0, 0, 'United States', '', '', '1-800-922-9641', '', '2015-07-05'),
(13, 1, 1, 4, 'Hydrel', 'HDR', 'Exterior, Interior', '', 'https://hydrel.acuitybrands.com/en/', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(14, 1, 1, 4, 'Peerless', 'PRL', 'Exterior, Interior', '', 'https://peerlesslighting.acuitybrands.com/en/', '', 237, 0, 0, '1', '', '', '', '', '2015-07-05'),
(17, 1, 0, 2, 'Portfolio', 'PRF', 'Commercial. Downlights, Cylinders', '', '', '', 237, 0, 0, '1', '', '', '', '', '2015-10-28'),
(18, 1, 0, 1, 'Axis Lighting', 'AXS', 'Interior Architectural', '', 'https://axislighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/18-axis_toplogo.jpg', 40, 294, 11213, '2505 SENKUS, LASALLE H8N 2X8, QC, CANADA', '', '', '514.948.6272', '', '2015-10-28'),
(19, 1, 0, 1, 'USAI Lighting', 'USA', 'Downlights, Adjustable Accent lighting, Cylinders. Commercial, Hospitality and Residential Applications.', '', 'http://www.usailighting.com/', '', 237, 2413, 83143, '11126 River Rd', 'info@usailighting.com', '', '(845) 565-8500', '', '2015-11-01'),
(20, 1, 1, 4, 'Gotham Lighting', 'GTM', 'Commercial Downlighting', '', 'https://gothamlighting.acuitybrands.com/en/', '', 237, 0, 0, 'Acuity Brands Lighting, One Lithonia Way Conyers, GA 30012', '', '', '770-922-9000', '', '2015-11-11'),
(21, 1, 0, 24, 'Focal Point', 'FOP', 'Commercial Downlighting, Adjustable, Wallwash, Linear Product, LED Troffers.', '', 'http://www.focalpointlights.com/', 'images/mnf-search-banners/mnf-search-banners-1/21-Focal_Point_toplogo.jpg', 237, 2394, 74338, '4141 S. Pulaski Road', '', '', '773.247.9494', '', '2015-11-12'),
(22, 1, 0, 6, 'Element (by Tech Lighting)', 'ELM', 'Downlights, Adjustable, Wallwashers, Multiples. Commercial and Residential.', '', 'http://www.element-lighting.com/', '', 237, 2394, 75001, '7400 Linder Ave', 'techsupport@generation-brands.com', '', '847.410.4400', '', '2015-11-12'),
(23, 1, 0, 1, 'Lumenwerx', 'LWX', 'Office, Commercial Troffer, Linear Suspended, Cove Luminaires', '', 'http://lumenwerx.com/en/home-chromawerx/', 'images/mnf-search-banners/mnf-search-banners-1/23-Lumenwerx_toplogo.jpg', 40, 294, 0, '393 St Croix, Suite B', '', '', '', '', '2016-02-05'),
(25, 1, 0, 1, 'Bega US', 'BGA', 'Exterior and Façade Architectural Lighting', '', '', '', 237, 0, 0, '1000 Bega Way', '', '', '', '', '2016-02-06'),
(26, 1, 0, 1, 'Architectural Lighting Works', 'ALW', 'Commercial and Architectural, Multiples, Linear, Linear.', '', '', '', 237, 0, 0, 'u', '', '', '', '', '2016-02-06'),
(27, 1, 0, 8, 'Birchwood Lighting', 'BWD', 'Linear architectural', '', 'https://www.birchwoodlighting.com/en/bw/home', 'images/mnf-search-banners/mnf-search-banners-1/27-Birchwood_toplogo.jpg', 237, 2385, 71526, '3340 East La Palma Ave Anaheim, California 92806', '', '', '', '', '2016-02-08'),
(28, 1, 0, 1, 'Moda Light', 'MDL', 'Flexible and Linear LED fixtures. White, RGB and Single Color Options', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-02-13'),
(29, 1, 0, 1, 'Delta Light', 'DLT', 'Commercial, Retail, Decorative Architectural', '', 'https://www.deltalight.us/en/?forceRegion=', 'images/mnf-search-banners/mnf-search-banners-1/29-Deltalight_toplogo.jpg', 83, 0, 0, '1', '', '', '', '', '2016-02-13'),
(30, 1, 0, 1, 'KIM Lighting', 'KIM', 'Area and Landscape Lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-02-14'),
(31, 1, 0, 1, 'Dasal Lighting', 'DSL', 'Commercial Downlights', '', '', '', 40, 0, 0, '1', '', '', '', '', '2016-02-14'),
(32, 1, 0, 5, 'Gardco', 'GDR', 'Area, Site Lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-02-14'),
(33, 1, 0, 2, 'HALO', 'HLO', 'Commercial and residential recessed, track and accent lighting.', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-02-16'),
(34, 1, 0, 1, 'Designplan', 'DPL', 'Indoor and Outdoor step lights, linear and commercial lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-02-17'),
(35, 1, 1, 1, 'Lumenpulse', 'LMP', 'Interior and Exterior Linear, Accent and Floodlighting', '', '', '', 40, 0, 0, '1', '', '', '', '', '2016-02-17'),
(36, 1, 0, 2, 'RSA Lighting', 'RSA', 'Multiples', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-03-08'),
(37, 1, 0, 2, 'Ametrix', 'AMT', 'Direct/Indirect Commercial Lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-03-08'),
(38, 1, 0, 2, 'io Lighting', 'IOL', 'Linear luminaires. Cove, Accent and Rail lighting', '', '', '', 237, 0, 0, '1', '', '', '', '', '2016-03-08'),
(39, 1, 1, 4, 'Lithonia Lighting', 'LTL', 'Interior and Exterior Commercial Lighting.', '', 'https://lithonia.acuitybrands.com/', '', 237, 0, 0, 'Acuity Brands Lighting, One Lithonia Way Conyers, GA 30012', '', '', '770-922-9000', '', '2016-03-20'),
(40, 1, 0, 1, 'Edge Lighting', 'EDG', 'Linear LED Luminaires for commercial and hospitality applications.', '', 'http://www.edgelighting.com/', '', 237, 2394, 74338, '1718 W. Fullerton Ave. 60614', 'info@edgelighting.com', '', '773-770-1195', '', '2016-05-04'),
(41, 1, 0, 1, 'Edison Price', 'EDP', 'Track, recessed downlights and adjustable. Commercial and hospitality applications.', '', 'http://www.epl.com/', 'images/mnf-search-banners/mnf-search-banners-1/41-EdisonPric_toplogo.jpg', 237, 2413, 83029, '41-50 22ND STREET', '', '', '718.685.0700', '', '2016-05-24'),
(42, 1, 0, 7, 'Current', 'GEL', 'Industrial, commercial, retail LED lighitng', '', 'http://www.gelighting.com/LightingWeb/na/', '', 237, 0, 0, 'GE', '', '', '', '', '2016-05-29'),
(43, 1, 0, 8, 'Intense Lighting', 'INL', 'Commercial and residential downlighting. recessed multiples, exterior lighting.', '', 'http://www.intenselighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/43-Intense_Lighting_toplogo.jpg', 237, 2385, 71526, '3340 East La Palma Ave', 'info@intenselighting.com', '', '714.630.9877', '', '2016-07-16'),
(44, 1, 0, 1, 'Louis Poulsen', 'LOU', 'Architectural Decorative Interior and Exterior Lighting', '', 'http://www.louispoulsen.com/usa/frontpage/', '', 237, 2390, 73118, '3260 Meridian Parkway', '', '', '(954) 349 2525', '', '2016-08-24'),
(45, 1, 0, 9, 'Litecontrol', 'LIC', 'Linear commercial LED lighting.', '', 'http://www.litecontrol.com/company/contact/', '', 237, 2402, 78610, '65 Spring Stree', '', '', '781 294 0100', '', '2016-10-23'),
(46, 1, 0, 5, 'Color Kinetics', 'CKN', 'Color changing and white light accent, flood lights', '', 'http://www.colorkinetics.com/', '', 237, 0, 0, '3 Burlington Woods Drive 4th Floor', '', '', '', '', '2016-11-19'),
(47, 1, 0, 1, 'Traxon Technologies (An OSRAM Business)', 'TRX', 'Color changing and white light accent and flood lighting.', '', 'https://www.osram.us/traxon/index.jsp', 'images/mnf-search-banners/mnf-search-banners-1/47-Traxon_toplogo.jpg', 237, 0, 0, 'Boston 200 Ballardvale Street, Wilmington', '', '', '', '', '2016-11-19'),
(48, 1, 0, 9, 'Hubbel', 'HBL', 'Commercial and Industrial. Interior and Exterior LED LUminaires.', '', 'http://www.hubbell.com/lighting_group.aspx', '', 237, 2387, 72885, 'Hubbell Incorporated 40 Waterview Drive', '', '', '', '', '2016-11-27'),
(51, 1, 0, 2, 'Lumiere', 'LMR', 'Landscape Lighting', '', 'http://www.cooperindustries.com/content/public/en/company/contact_us.html', '', 237, 2416, 84497, '1000 Eaton Boulevard', '', '', '', '', '2016-11-27'),
(52, 1, 0, 1, 'ABC LIGHTING', 'ABC', 'TEST', '', '', '', 237, 0, 0, 'TEST', '', '', '', '', '2017-11-25'),
(53, 1, 0, 24, 'Kenall', 'KNL', 'Indoor/Outdoor luminaires, Exit Signs & Emergency', '', 'https://kenall.com/Home', 'images/mnf-search-banners/mnf-search-banners-1/53-Kenall_toplogo.jpg', 237, 2430, 91054, '10200 55th Street, WI 53144', '', '', '800.453.6255', '', '2018-02-05'),
(54, 1, 0, 1, 'LightArt', 'LIA', 'Custom lighting fabrication and design studio', '', 'http://lightart.com/', '', 237, 0, 0, 'Seattle Studio, 4770 Ohio Ave S, Suite A, Seattle, WA, 98134', '', '', '', '', '2018-02-07'),
(55, 1, 0, 2, 'Corelite', 'CRL', 'Indoor lighting and controls solutions', '', 'http://www.cooperindustries.com/content/public/en/lighting.html', '', 237, 0, 0, 'USA', '', '', '', '', '2018-02-20'),
(56, 1, 0, 1, 'Amerlux', 'AMR', 'Lighting design company', '', 'http://www.amerlux.com/', '', 237, 2411, 82082, '178 Bauer Drive', '', '', '+1-973-882-5010', '+1-973-882-2605', '2018-02-22'),
(57, 1, 0, 1, 'Bartco Lighting', 'BRT', 'Linear LED & fluorescent strip fixtures.', '', 'https://www.bartcolighting.com/', '', 237, 2385, 71871, '5761 Research Drive', '', '', '714.230.3200', '', '2018-02-22'),
(58, 1, 0, 1, 'Beta-Calco lighting', 'BCL', 'Interior and exterior lighting', '', 'http://betacalco.com/', '', 40, 292, 10896, '25 Kodiak Crescent', 'sales@betacalco.com', '', '416 531 9942', '416 531 6199', '2018-02-22'),
(59, 1, 0, 5, 'Day-Brite', 'DBR', 'Indoor Commercial & Industrial', '', '', '', 237, 2411, 82185, '281 Hillmount Rd, Markham', '', '', '1-800-555-0050', '800-668-9008', '2018-02-24'),
(60, 1, 0, 2, 'IRIS', 'IRS', 'Architectural Residential and Commercial Recessed Downlighting', '', '', '', 237, 0, 0, 'USA', '', '', '', '', '2018-02-24'),
(61, 1, 0, 1, 'Prudential Lighting', 'PRU', 'Indoor technical lighting', '', 'http://www.prulite.com/', 'images/mnf-search-banners/mnf-search-banners-1/61-Pudential_toplogo.jpg', 237, 2385, 71972, '1774 E 21st Street', '', '', '', '', '2018-02-25'),
(62, 1, 0, 1, 'Cree', 'CRE', 'Indoor lighting, outdoor lighting, controls', '', 'http://www.cree.com/', '', 237, 2414, 83723, '4600 Silicon Drive', '', '', '', '', '2018-03-13'),
(63, 1, 0, 4, 'Holophane', 'HOL', 'Indoor and outdoor lighting systems for commercial, industrial, emergency, and demanding environments.', '', 'https://holophane.acuitybrands.com/en/', '', 237, 0, 0, 'USA', '', '', '', '', '2018-03-13'),
(64, 1, 0, 1, 'Tech Lighting', 'TCH', 'Recessed & General Illumination.', '', 'http://www.techlighting.com', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-14'),
(65, 1, 0, 1, 'Sistemalux', 'SLX', 'Interior/Exterior lighting', '', 'http://www.sistemalux.com/', '', 40, 294, 11276, '9320 Saint-Laurent Suite 100 Montreal, QC H2N 1N7', '', '', '', '', '2018-03-15'),
(66, 1, 0, 1, 'iGuzzini', 'IGZ', 'iGuzzini', '', '', '', 40, 0, 0, '9320 Saint-Laurent, Suite 100 Montreal, Qc, Canada H2N 1N7', '', '', '', '', '2018-03-15'),
(67, 1, 0, 5, 'Hadco', 'HDC', 'Exterior Lighting', '', 'http://www.lightingproducts.philips.com/search-tool.html?brand=Hadco#!f=%40Brand%3aHadco&brandId=c65e927d-5dab-463e-94ae-a2ee201519a8&isCatSearch=1', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-16'),
(68, 1, 0, 5, 'Stonco', 'STN', 'Outdoor General Purpose', '', 'http://www.lightingproducts.philips.com/search-tool.html#!f=%40HasNewProducts%3A1%2B%40Brand%3AStonco+Usa&p=1', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-16'),
(69, 1, 0, 5, 'Lightolier', 'LGL', 'Commercial Lighting, Residential Lighting, Outdoor Lighting, etc.', '', 'http://www.lightingproducts.philips.com', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-16'),
(70, 1, 0, 5, 'Lumec', 'LMC', 'Outdoor luminaires, bollards lights, light columns, poles, brackets, and wall sconces for public and commercial landscapes.', '', '', '', 40, 0, 0, '640 boulevard Curé-Boivin Boisbriand, QC J7G 2A7 Canada', '', '', '', '', '2018-03-16'),
(71, 1, 0, 5, 'Chloride', 'CLR', 'Emergency lighting, central emergency lighting systems, emergency ballast and accessories such as mounting plates and outdoor remote heads.', '', '', '', 237, 0, 0, '272 W Stag Park Service Rd Burgaw NC 28425-4437', '', '', '(910) 259-1000', '', '2018-03-16'),
(72, 1, 0, 12, 'BOOM', 'BOM', 'Indoor/outdoor luminaires.', '', 'https://www.bega-us.com/group.aspx?familyid=38', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-21'),
(73, 1, 0, 12, 'Limburg', 'LMB', 'Indoor luminaires', '', '', '', 237, 0, 0, '130 W. Monroe Ave. St. Louis, MO 63122', '', '', '', '', '2018-03-21'),
(74, 1, 0, 1, 'We-ef Lighting', 'WEF', 'Indoor/Outdoor luminaires', '', '', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-22'),
(75, 1, 0, 2, 'Neo-Ray', 'NER', 'Architectural Indirect/Direct Linear, Recessed and Surface Lighting', '', '', '', 237, 0, 0, '537 Johnson Avenue Brooklyn, NY 11237-1304', '', '', '', '', '2018-03-22'),
(76, 1, 0, 1, 'Visa Lighting', 'VIS', 'Indoor/Outdoor luminaires', '', 'https://www.visalighting.com', 'images/mnf-search-banners/mnf-search-banners-1/76-Visa_Lighting_toplogo.jpg', 237, 0, 0, 'VISA LIGHTING 1717 W. Civic Dr. Milwaukee, WI 53209', '', '', '', '', '2018-03-23'),
(77, 1, 0, 4, 'Winona Lighting', 'WNL', 'Asymmetric; Ceiling Mount; Flood And Spot; Linear; Marker And Step; Pendant; Sconce.', '', 'https://www.acuitybrands.com/brands/lighting/winona', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-27'),
(78, 1, 0, 4, 'Carandini', 'CRD', 'Carandini specializes in LED and fluorescent outdoor lighting including roadway lighting, street lighting, floodlighting, and industrial lighting applications.', '', '', '', 209, 0, 0, 'S.A. Verneda nº 66-70, E-08107 Martorelles (Barcelona)', '', '', '', '', '2018-03-27'),
(79, 1, 0, 1, 'Pure Lighting', 'PUR', 'Indoor lighting, outdoor lighting, modern lighting', '', 'http://www.purelighting.com/', '', 237, 0, 0, '1718 W. Fullerton Ave., Chicago, Illinois 60614', '', '', '', '', '2018-03-28'),
(80, 1, 0, 1, 'B-K Lighting', 'BKL', 'Indoor/outdoor lighting.', '', 'http://www.bklighting.com/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-29'),
(81, 1, 0, 4, 'American Electric Lighting', 'AEL', 'Outdoor LED and HID', '', 'https://www.acuitybrands.com/brands/lighting/american-electric-lighting#t=Products', '', 237, 0, 0, 'United States', '', '', '', '', '2018-03-29'),
(82, 1, 0, 1, 'Luminii', 'LMI', 'Architectural LED Lighting Products', '', 'https://www.luminii.com/', 'images/mnf-search-banners/mnf-search-banners-1/82-Luminii_toplogo.jpg', 237, 0, 0, '7777 Merrimac Ave Niles, IL 60714', '', '', '', '', '2018-03-29'),
(83, 1, 1, 4, 'Healthcare Lighting', 'HEL', 'Lighting solutions for patient-care settings and surgical, procedure and diagnostic applications.', '', 'https://www.acuitybrands.com/en/brands/lighting/healthcare-lighting', '', 237, 0, 0, '1170 Peachtree Street, NE Suite 2300  Atlanta, GA 30309-7676', '', '', '', '', '2018-03-29'),
(84, 1, 0, 1, 'Selux', 'SEL', 'Interior and Exterior Lighting', '', 'https://www.selux.us/usa/en/start', '', 237, 0, 0, 'Selux Corporation 5 Lumen Lane P.O. Box 1060 Highland, NY 12528', '', '', '', '', '2018-03-29'),
(88, 1, 0, 1, 'Delray Lighting', 'DRL', 'Indoor lighting', '', 'http://www.delraylighting.com', '', 237, 0, 0, 'United States', '', '', '', '', '2018-04-02'),
(89, 1, 0, 1, 'Vibia', 'VBA', 'Indoor/Outdoor luminaires', '', 'https://www.vibia.com/us/usa/', 'images/mnf-search-banners/mnf-search-banners-1/89-VIBIA_toplogo.jpg', 237, 2411, 0, '272 Fernwood Ave  Edison, NJ 08837  (New Jersey- USA)', 'sales@vibialight.com', '', '732 417 1700', '', '2018-04-02'),
(90, 1, 0, 1, 'Axolight', 'AXL', 'Indoor luminaires', '', 'http://www.axolightusa.com/usa/en_GB', '', 237, 0, 0, '22 Shelter Rock Lane, DANBURY, CT 06810', '', '', '', '', '2018-04-02'),
(91, 1, 0, 1, 'Blackjack Lighting', 'BJK', 'Indoor lighting.', '', 'http://www.blackjacklighting.com', 'images/mnf-search-banners/mnf-search-banners-1/91-blackjack_toplogo.jpg', 237, 2394, 74281, '1553 Barclay Blvd.', 'info@blackjacklighting.com', '', '', '', '2018-04-03'),
(92, 1, 0, 1, 'Artemide', 'ATM', 'Design, outdoor, architectural luminaires', '', 'https://www.artemide.net/en/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-04-03'),
(93, 1, 0, 1, 'NERI NORTH AMERICA', 'NNA', 'Outdoor lighting.', '', 'https://www.nerinorthamerica.com', '', 237, 2390, 73243, '1547 NW 79th Avenue', 'neri.us@neri.biz', '', 'T +1 786 315 4367', 'F +1 786 257 1336', '2018-04-03'),
(94, 1, 0, 1, 'Lumato', 'LMT', 'Suspended, wall, recessed, ceiling luminaires', '', 'http://www.lumatolighting.com/#', '', 237, 0, 0, '1035 Dairy Ashford Road Suite #120 Houston, Texas 77079', '', '', '', '', '2018-04-03'),
(95, 1, 0, 1, 'Acolyte', 'ACL', 'Indoor/Outdoor LED luminaires', '', 'https://www.acolyteled.com/', '', 237, 0, 0, '19 West 36th Street, 6th Floor New York, NY 10018', '', '', '', '', '2018-04-03'),
(96, 1, 0, 1, 'G Lighting', 'GLG', 'Indoor lighting', '', 'www.glighting.com', '', 237, 2406, 80852, '9777 Reavis Park Drive', 'sales@glighting.com', '', 'T. 800.331.2425', 'T. 314.631.6000', '2018-04-03'),
(97, 1, 0, 1, 'Cole Lighting', 'CLL', 'Indoor/Outdoor lighting', '', 'https://www.colelighting.com/', '', 237, 0, 0, 'United States', 'info@colelighting.com', '', '(626) 443-2473', '', '2018-04-03'),
(98, 1, 0, 1, 'Lumium Lighting', 'LML', 'Indoor luminaires', '', 'https://www.lumiumlighting.com/', '', 237, 0, 0, 'United States', '', '', '(760) 757-2530', '', '2018-04-03'),
(99, 1, 0, 1, 'Chameleon Lighting', 'CML', 'Chameleon Lighting strives to marry high performance and decorative lighting into a complete, convertible lighting system that is ever changing and evolving.', '', 'https://chameleonltg.com/', 'images/mnf-search-banners/mnf-search-banners-1/99-Chameleon_toplogo.jpg', 237, 0, 0, '241 CHESTERFIELD INDUSTRIAL BLVD CHESTERFIELD, MO 63005', '', '', '', '', '2018-04-03'),
(100, 1, 0, 1, 'Arcluce', 'ARL', 'Indoor/Outdoor LED luminaires', '', 'https://www.arcluce-us.com/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-04-04'),
(101, 1, 0, 1, 'LSI Industries', 'LSI', 'Commercial / industrial lighting', '', 'https://www.lsi-industries.com/', '', 237, 0, 0, '10000 Alliance Road | Cincinnati, Ohio 45242', '', '', '', '', '2018-04-04'),
(102, 1, 0, 1, 'Zumtobel', 'ZTB', 'Indoor luminaires', '', 'http://zumtobel.us/', 'images/mnf-search-banners/mnf-search-banners-1/102-Zumtobel_toplogo.jpg', 237, 0, 0, 'Highland, 3300 Route 9W, Highland New York, NY 12528', '', '', '+1 845 691 6262', '', '2018-04-05'),
(103, 1, 0, 1, 'WAC Lighting', 'WLG', 'Decorative; Track & Rail; Recessed; Task & Cove; Indoor/Outdoor.', '', 'www.waclighting.com', '', 237, 2413, 83145, '44 Harbor Park Drive, Port Washington', 'info@waclighting.com', '', '1.800.526.2588', '1.800.526.2585', '2018-04-05'),
(104, 1, 0, 9, 'Architectural Area Lighting', 'AAL', 'Exterior lighting', '', '', '', 237, 0, 0, '16555 East Gale Ave. City of Industry, CA 91745', '', '', '', '', '2018-04-05'),
(105, 1, 0, 9, 'Beacon', 'BCN', 'Commercial Outdoor Lighting', '', 'https://www.hubbell.com/beacon/en', '', 237, 0, 0, 'United States', '', '', '', '', '2018-04-06'),
(106, 1, 0, 1, 'Waldmann', 'WDN', 'Indoor lighting', '', 'www.waldmann.com', '', 83, 0, 0, 'Peter-Henlein-Straße 5  78056 Villingen-Schwenningen  Deutschland', 'sales.germany@waldmann.com', '', '+49 7720 601 0', '', '2018-04-06'),
(108, 1, 0, 1, 'v2 Lighting Group', 'V2L', 'Interior and exterior LED luminaires', '', '', '', 237, 0, 0, '276 East Gish Road San Jose, California 95112 USA', '', '', '', '', '2018-04-10'),
(110, 1, 0, 1, 'FC Lighting', 'FLG', 'Indoor and outdoor lighting.', '', 'https://www.fclighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/110-FClighting.jpg', 237, 2394, 0, '3609 Swenson Avenue', '', '', '(800) 900-1730', '', '2018-04-11'),
(111, 1, 0, 5, 'Ledalite', 'LDL', 'Indoor luminaires.', '', '', '', 40, 0, 0, '19750 - 92A Avenue Langley, BC V1M 3B2 CANADA', '', '', '', '', '2018-04-11'),
(112, 1, 0, 2, 'Shaper', 'SHP', 'Indoor and Outdoor Architectural Decorative Lighting', '', '', '', 237, 0, 0, '18001 E. Colfax Avenue Denver, CO 80011', '', '', '', '', '2018-04-11'),
(113, 1, 0, 1, 'Acclaim Lighting', 'ACM', 'High performance controller units for entertainment and architectural lighting demands.', '', '', '', 237, 0, 0, '6122 S. Eastern AVE Los Angeles CA 90040', '', '', '', '', '2018-04-12'),
(114, 1, 0, 1, 'Visual Lighting Technologies', 'VLT', 'Outdoor lighting.', '', 'http://www.vltcorp.com', '', 237, 2424, 88167, '1809 Hur Industrial Blvd, Cedar Park, TX 78613', 'info@vltcorp.com', '', '(949)581-9398', '', '2018-04-15'),
(115, 1, 0, 4, 'Eureka Lighting', 'EUR', 'Indoor Lighting', '', 'https://www.eurekalighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/115-Eureka_toplogo.jpg', 40, 294, 11276, '225 de Liege West # 200 Montreal, Qc H2P 1H4', 'info@eurekalighting.com', '', '514.385.3515', '', '2018-04-15'),
(116, 1, 0, 1, 'DALS Lighting', 'DAL', 'DALS Lighting, Inc. is a manufacturer of accent and architectural lighting products focusing on innovative and emerging LED technology.', '', '', '', 40, 0, 0, '80 de la Seigneurie Est Blainville, Québec J7C 4N1', '', '', '', '', '2018-04-16'),
(117, 1, 0, 1, 'Dado lighting', 'DAD', 'Fixtures the Thickness of Drywall', '', '', '', 237, 0, 0, '4700 Gilbert Suite 47-217  Western Springs, IL 60558', '', '', '', '', '2018-04-16'),
(118, 1, 0, 1, '3G Lighting', '3LG', 'Indoor lighting.', '', 'https://www.3glighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/118-3gLighting_toplogo.jpg', 40, 292, 10952, '51 Hanlan Road Woodbridge, Ontario L4L 3P5', 'info@3glighting.com', '', '888-448-0440', '', '2018-04-17'),
(119, 1, 0, 1, 'ACDC', 'ACD', 'Architectural LED Lighting', '', 'http://acdclighting.us/', 'images/mnf-search-banners/mnf-search-banners-1/119-acdc_toplogo.jpg', 237, 2413, 0, '3300 Route 9W Highland, NY 12528', 'sales@acdclighting.us', '', '+1 (410) 220 0088', '', '2018-04-17'),
(120, 1, 0, 4, 'A Light', 'ALT', 'Indoor lighting', '', 'https://www.alights.com/', 'images/mnf-search-banners/mnf-search-banners-1/120-alight_toplogo.jpg', 237, 2385, 72095, '3728 maritime way oceanside, california 92056', 'directorofsales@alights.com', '', '760.727.7675', '', '2018-04-17'),
(121, 1, 0, 1, 'Design Lighting Selection', 'DLS', 'Indoor lighting.', '', '', '', 237, 0, 0, 'DLS Lighting US  3135 SR 580, Suite 6  Safety Harbor, FL 34695', '', '', '', '', '2018-04-17'),
(122, 1, 0, 9, 'Antique Street Lamps', 'ASL', 'Decorative Outdoor Lights', '', 'https://www.acuitybrands.com/brands/lighting/antique-street-lamps#t=Products&f:@flightsource51681=[LED]', '', 237, 0, 0, 'United States', '', '', '', '', '2018-04-17'),
(123, 1, 0, 13, 'Certolux', 'CTL', 'Medical & Special Applications luminaires.', '', '', '', 40, 0, 0, '35 Oak Street, Toronto, ON M9N 1A1', '', '', '', '', '2018-04-17'),
(124, 1, 0, 1, 'ANP Lighting', 'ANP', 'Innovative Site Lighting', '', 'http://ww2.anplighting.com/', '', 237, 2385, 72035, '9044 Del Mar Avenue  Montclair, CA 91763', '', '', '909-982-1807', '', '2018-04-18'),
(125, 1, 0, 1, 'Arri AG', 'ARI', 'Indoor/outdoor lighting.', '', 'http://www.arri.com', '', 83, 0, 0, 'Türkenstrasse 89 80799 Munich', '', '', '+49 (0)89 3809 0', '', '2018-04-18'),
(126, 1, 0, 1, 'Archipelago Lighting', 'APL', 'Commercial and residential lighting.', '', '', '', 237, 0, 0, '4615 State Street Montclair CA, 91763', '', '', '', '', '2018-04-18'),
(127, 1, 0, 1, 'Artcraft Lighting', 'ARC', 'Interior and exterior lighting.', '', '', '', 40, 0, 0, '8525 Jules Leger Anjou, QC, H1J1A8', '', '', '', '', '2018-04-18'),
(128, 1, 0, 1, 'Barron Lighting Group', 'BLG', 'Indoor Outdoor Lighting', '', 'http://www.barronltg.com/index.php', '', 237, 2383, 71112, 'Barron Lighting Group Corporate Office 7885 N Glen Harbor Blvd Glendale, AZ 85307', '', '', '888.533.3948', '', '2018-04-18'),
(129, 1, 0, 1, 'Bover', 'BVR', 'Indoor/Outdoor Lighting', '', 'http://www.bover.es/en/', '', 237, 2391, 73447, '1231 Collier Road, Suite C Atlanta GA 30318 United States', 'info@boverusa.com', '', '+1 404 924 2342', '', '2018-04-19'),
(130, 1, 0, 1, 'Best Lights', 'BLS', 'Indoor Lighting.', '', 'www.bestlights.com', '', 237, 2403, 79417, '100 Park Drive, Troy, MI', 'info@bestlights.com', '', '(248) 588-4980', '', '2018-04-19'),
(131, 1, 0, 1, 'Brownlee Lighting', 'BWL', 'Indoor/Outdoor LED Lighting', '', 'http://www.brownlee.com/', '', 237, 2390, 73290, '4600 Dardanelle Drive Orlando, FL USA 32808-3832', '', '', '407.297.3677 or 800.318.6768', '', '2018-04-19'),
(132, 1, 0, 1, 'Dark', 'DRK', 'Indoor lighting.', '', 'http://www.dark.be', '', 22, 0, 0, 'DARK AT NIGHT NV VLIEGPLEIN 43', 'INFO@DARK.BE', '', '+32 [0]50 71 81 40', '', '2018-04-19'),
(133, 1, 0, 1, 'EcoSense Lighting', 'ESL', 'Indoor and Outdoor LED products.', '', '', '', 237, 0, 0, '837 NORTH SPRING STREET SUITE 103 LOS ANGELES, CA 90012', '', '', '', '', '2018-04-19'),
(134, 1, 0, 1, 'EverLast Lighting', 'ELL', 'LED lighting solutions for interior and exterior, commercial and industrial applications.', '', '', '', 237, 0, 0, '2021 WELLWORTH AVENUE JACKSON, MICHIGAN 49203​', '', '', '', '', '2018-04-19'),
(135, 1, 0, 1, 'Fluxwerx', 'FLX', 'Indoor lighting.', '', 'https://fluxwerx.com/', 'images/mnf-search-banners/mnf-search-banners-1/135-Fluxwex_toplogo.jpg', 40, 285, 9730, '9255 - 194th Street Surrey BC Canada V4N 4G1', 'serviceteam@fluxwerx.com', '', '604.549.9379', '', '2018-04-20'),
(136, 1, 0, 1, 'FSC Lighting', 'FSC', 'Energy-efficient LED fixtures', '', '', '', 237, 2385, 72182, '9120 Center Avenue, Rancho Cucamonga, CA 91730', 'info@fsclighting.com', '', '(877) 927-5913', '', '2018-04-20'),
(137, 1, 0, 1, 'Gantom', 'GNT', 'Lighting & Controls', '', 'http://www.gantom.com/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-04-20'),
(138, 1, 0, 1, 'First Light Technologies', 'FLT', 'Outdoor lighting.', '', 'www.firstlighttechnologies.com', '', 40, 285, 9733, '455 Banga Pl., Suite 104 Victoria, BC V8Z 6X5 Canada', 'info@firstlighttechnologies.com', '', '1.844.279.8754', '', '2018-04-20'),
(139, 1, 0, 1, 'Halco Lighting Technologies', 'HLT', 'Indoor and Outdoor luminaires.', '', '', '', 237, 0, 0, '2940 Pacific Drive Norcross, GA 30071', '', '', '', '', '2018-04-20'),
(140, 1, 0, 1, 'Holm', 'HLM', 'ARCHITECTURAL & LANDSCAPE LIGHTING', '', '', '', 237, 0, 0, '1940 Diamond Street San Marcos, CA 92078', '', '', '', '', '2018-04-20'),
(141, 1, 0, 1, 'Indessa Lighting', 'IDG', 'Indoor/outdoor lighting.', '', 'http://www.indessa.com', '', 237, 2428, 90249, '3808 N SULLIVAN RD, 17F SPOKANE, WA 99216', '', '', '(509) 924-0243', '', '2018-04-23'),
(142, 1, 0, 1, 'Litelab', 'LLB', 'Lighting Solutions for Museums, Retail and Architectural Environments', '', 'http://www.litelab.com/', '', 237, 2413, 82570, 'Litelab Corporation  251 Elm Street  Buffalo, New York 14203', '', '', '716.856.4300', '', '2018-04-23'),
(143, 1, 0, 1, 'LumenArt', 'LAT', 'Indoor lighting.', '', 'http://www.lumenartltd.com', 'images/mnf-search-banners/mnf-search-banners-1/143-Lumen_Art_toplogo.jpg', 237, 2394, 74338, '3333 W. 47th Street Chicago, IL 60632', 'Valerie.Hastings@LumenArt.com', '', '773-254-0744', '', '2018-04-23'),
(144, 1, 0, 1, 'Lucifer Lighting', 'LCF', 'Indoor/Outdoor Lighting', '', 'http://www.luciferlighting.com/', '', 237, 2424, 88826, 'Lucifer Lighting Company 3750 IH35 North San Antonio, TX 78219', '', '', '+1 210 227 7329', '', '2018-04-23'),
(145, 1, 0, 1, 'McFadden Lighting', 'MFL', 'Church, institutional and commercial lighting.', '', '', '', 237, 0, 0, '2601 Ohio Avenue St. Louis, MO 63118', '', '', '', '', '2018-04-23'),
(146, 1, 0, 1, 'North Star Lighting', 'NSL', 'Sportslighting, commercial, industrial and architectural lighting products.', '', 'https://nslights.com/', 'images/mnf-search-banners/mnf-search-banners-1/146-North_Star_toplogo.jpg', 237, 0, 0, '835 Industrial Drive, Elmhurst, IL 60126', '', '', '', '', '2018-04-23'),
(147, 1, 0, 24, 'OCL Architectural Lighting', 'OCL', 'Indoor and outdoor.', '', 'https://ocl.com/', 'images/mnf-search-banners/mnf-search-banners-1/147-OCL_toplogo.jpg', 237, 2406, 80852, '11902 Lackland Road St. Louis, MO 63146', '', '', '314.863.1895', '', '2018-04-23'),
(148, 1, 0, 1, 'Modern Forms', 'MFS', 'Indoor/outdoors lighting.', '', 'modernforms.com', '', 237, 2413, 83267, '44 Harbor Park Drive Port Washington, NY 11050', 'customerservice@modernforms.com', '', '1-866-810-6615', '', '2018-04-24'),
(149, 1, 0, 1, 'oxygen lighting', 'OXY', 'Indoor/Outdoor Lighting', '', 'http://www.oxygenlighting.com/index.cfm/app/index', '', 237, 2424, 88336, '201 Railhead Rd. Fort Worth, TX 76106', '', '', '', '', '2018-04-24'),
(150, 1, 0, 1, 'Rich Brilliant Willing', 'RBW', 'Indoor lighting.', '', 'www.richbrilliantwilling.com', '', 237, 2413, 83145, '50 Greene St 2nd Floor New York NY 10013', 'sales@richbrilliantwilling.com', '', '+1 212 388 1621', '', '2018-04-24'),
(151, 1, 0, 24, 'Pinnacle Architectural Lighting', 'PIN', 'Architectural lighting', '', 'http://www.pinnacle-ltg.com/', '', 237, 2386, 72521, '12655 E. 42nd Ave. Denver, CO 80239', '', '', '303.322.5570', '', '2018-04-24'),
(152, 1, 0, 1, 'Rambusch Lighting', 'RBL', 'Interior architecture through lighting.', '', '', '', 237, 0, 0, '160 Cornelison Ave. Jersey City NJ, 07304', '', '', '', '', '2018-04-24'),
(153, 1, 0, 1, 'Spectrum Lighting', 'STL', 'Commercial and Architectural Lighting.', '', '', '', 237, 0, 0, '994 Jefferson Street Fall River, MA 02721', '', '', '', '', '2018-04-24'),
(154, 1, 0, 1, 'Roberts Step-Lite Systems', 'RSL', 'Step Lights', '', '', '', 237, 0, 0, '8100 SW 15th St. Oklahoma City, OK 73128', '', '', '', '', '2018-05-01'),
(155, 1, 0, 1, 'Precision Architectural Lighting', 'PAL', 'architectural-grade lighting', '', '', '', 237, 0, 0, '4830 Timber Creek Drive Houston, Texas 77017', '', '', '', '', '2018-05-01'),
(156, 1, 0, 1, 'Self Electronics Germany GmbH', 'SEG', 'Indoor lighting.', '', 'http://www.self-electronics.de/index.php/default/index/lang/en', '', 83, 0, 0, 'August-Horch-Str.7,51149, Koeln', 'saleseu@self-electronics.com', '', '0049-2203-18501-0', '', '2018-05-02'),
(157, 1, 0, 1, 'Solas Ray Lighting', 'SLR', 'Indoor/Outdoor/Hazardous Location Lighting', '', 'https://www.solasray.com/', '', 237, 0, 0, 'United States', '', '', '765.298.8030', '', '2018-05-02'),
(158, 1, 0, 1, 'Solavanti Lighting', 'SLV', 'Indoor and outdoor', '', '', '', 237, 0, 0, '9659 Wendell Rd. Dallas TX 75243', '', '', '', '', '2018-05-02'),
(159, 1, 0, 1, 'SPI Lighting', 'SPI', 'Indoor and outdoor lighting.', '', 'http://www.spilighting.com/index.html', '', 237, 2430, 91114, '10400 N Enterprise Drive Mequon, WI 53092', 'contact@spilighting.com', '', '262.242.1420', '', '2018-05-02'),
(160, 1, 0, 1, 'Universal Lighting Technologies', 'ULT', 'LED Lighting', '', 'https://unvlt.com/', '', 237, 2423, 87855, '51 Century Blvd., Suite 230  Nashville, TN 37214-3683', 'webmaster@unvlt.com', '', '615-316-5100', '', '2018-05-02'),
(161, 1, 0, 14, 'Trace Lite', 'TCL', 'Commercial and industrial lighting', '', '', '', 237, 0, 0, '7885 N Glen Harbor Blvd Glendale, AZ 85307', '', '', '', '', '2018-05-02'),
(162, 1, 0, 1, 'Venture Lighting', 'VTL', 'Indoor and outdoor lighting.', '', 'www.venturelighting.com', '', 237, 2416, 85027, 'Venture Lighting International 2451 Enterprise Parkway East Twinsburg, Ohio 44087 USA', 'customerservice@venturelighting.com', '', '800-451-2606', '', '2018-05-03'),
(164, 1, 0, 1, 'Vista', 'VST', 'Professional outdoor lighting', '', 'http://www.vistapro.com/', '', 237, 2385, 72299, '1625 Surveyor Ave. Simi Valley, CA 93063', 'email@vistapro.com', '', '(805) 527-0987', '', '2018-05-03'),
(165, 1, 0, 30, 'Sternberg Lighting', 'SBG', 'Outdoor lighting.', '', 'http://www.sternberglighting.com/www-sternberglighting-com/', '', 237, 2394, 74943, 'Sternberg Lighting 555 Lawrence Ave. Roselle, IL 60172', 'contactus@sternberglighting.com', '', '847-588-3400', '800-621-3376', '2018-05-03'),
(166, 1, 0, 1, 'Viso', 'VSO', 'Indoor Lighting', '', 'http://visoinc.com/', '', 40, 292, 10896, 'Canada', '', '', '416.461.8476', '', '2018-05-03'),
(167, 1, 0, 14, 'specialtyLED', 'SPC', 'Commercial and decorative lighting.', '', '', '', 237, 0, 0, '7885 N Glen Harbor Blvd Glendale, AZ 85307', '', '', '', '', '2018-05-03'),
(168, 1, 0, 2, 'Fail-Safe', 'FSF', 'Lighting for healthcare, cleanroom, confinement, and vandal resistant applications', '', '', '', 237, 0, 0, '1121 Highway 74 South Peachtree City, GA 30269', '', '', '', '', '2018-05-03'),
(169, 1, 0, 1, 'Arancia Lighting', 'ARA', 'High quality lighting fixtures designed in Quebec Canada.', '', 'http://arancialighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/169-arancia_toplogo.jpg', 40, 294, 11276, '6048 Route 132 Ste-Catherine, QC', '', '', '514 737 2726', '', '2018-05-04'),
(170, 1, 0, 15, 'Alphabet', 'ABT', 'Indoor and outdoor lighting.', '', 'www.alphabetlighting.com', '', 237, 2386, 72558, 'Ledra Brands, Inc 15774 Gateway Circle Tustin, CA 92780', 'INFO@LEDRABRANDS.COM', '', '+1 (714) 259-9959', '', '2018-05-04'),
(171, 1, 0, 1, 'Abra Lighting', 'ABR', 'Indoor Luminaires', '', 'https://abralighting.com', '', 237, 0, 0, 'United States', '', '', '949-940-1155', '', '2018-05-04'),
(172, 1, 0, 1, 'CHAUVET Professional', 'CPL', 'Professional lighting.', '', 'www.chauvetprofessional.com', '', 237, 2390, 73375, '5200 N.W. 108th Avenue  Sunrise, FL 33351 USA', '', '', '(954) 577-4455', '', '2018-05-04'),
(174, 1, 0, 1, 'Ayre Architectural Lighting', 'AYR', 'Indoor lighting.', '', '', '', 237, 0, 0, '14 Bristol Drive, Unit B South Easton, MA 02375', '', '', '', '', '2018-05-04'),
(175, 1, 0, 1, 'Boca Flasher', 'BCF', 'Architectural LED systems', '', '', '', 237, 0, 0, '508 South Military Trail Deerfield Beach FL, 33442', '', '', '', '', '2018-05-04'),
(176, 1, 0, 1, 'Electrix Illumination', 'EXI', 'Indoor and outdoor lighting.', '', 'www.electrixillumination.com', '', 237, 2387, 72830, '45 Spring Street, New Haven, CT 06519', '', '', '203.776.5577', '', '2018-05-07'),
(177, 1, 0, 15, 'Bruck', 'BRC', 'Indoor/Outdoor Lighting', '', 'https://brucklighting.com/', '', 237, 2385, 72375, '15774 GATEWAY CIRCLE TUSTIN, CA', 'INFO@LEDRABRANDS.COM', '', '(714) 259-9959', '', '2018-05-07'),
(178, 1, 0, 1, 'Coronet', 'CRT', 'Indoor lighting.', '', 'www.coronetled.com', '', 237, 2413, 83145, '54 W 21ST STREET, SUITE 909  NEW YORK, NY 10010', 'INFO@CORONETLED.COM', '', '973.345.7660', '', '2018-05-07'),
(179, 1, 0, 1, 'Contraste Lighting', 'CNL', 'Indoor lighting.', '', '', '', 40, 0, 0, '1009, rue du Parc Industriel Lévis (Québec) G6Z 1C5', '', '', '', '', '2018-05-07'),
(180, 1, 0, 1, 'Elan Lighting', 'ELN', 'Indoor Lighting', '', 'https://www.elan-lighting.com/', '', 237, 0, 0, 'United States', '', '', '+1 (855) 226-7169', '', '2018-05-07'),
(181, 1, 0, 1, 'Eklipse Architectural Lighting', 'EAL', 'Architectural lighting', '', '', '', 40, 0, 0, '2090 rue Moreau, Suite 100 H1W 2M3 Montréal QC', '', '', '', '', '2018-05-07'),
(182, 1, 0, 1, 'Energie', 'ENG', 'Indoor Lighting', '', 'http://www.energielighting.com', '', 237, 2386, 72464, '5310 Ward Road, Suite 106 Arvada, CO 80002', '', '', '720 963 8055', '', '2018-05-08'),
(183, 1, 0, 1, 'Lighting Services Inc', 'LTS', 'Indoor lighting.', '', 'http://www.lightingservicesinc.com', '', 237, 2413, 0, '2 Holt Drive Stony Point NY 10980, USA', 'sales@mailLSI.com', '', '+1 (845) 942-2800', '+1 (800) 999-9574', '2018-05-08'),
(184, 1, 0, 16, 'Framburg', 'FRM', 'Ceiling and wall mounted fixtures', '', 'https://framburg.com/?landingpage=false', '', 237, 2394, 74232, '941 Cernan Drive Bellwood, IL 60104', 'framburg@framburg.com', '', '800-428-5367', '', '2018-05-08'),
(185, 1, 0, 16, 'House of Troy', 'HOT', 'Picture lights, swing arms and desk/office lamps', '', 'https://houseoftroy.com/?landingpage=false', '', 237, 2426, 89279, '902 Silver Ridge Road Hyde Park VT 05655', 'customerservice@houseoftroy.com', '', '800-428-5367', '', '2018-05-08'),
(186, 1, 0, 1, 'Komee USA', 'KME', 'Outdoor/indoor lighting.', '', 'www.komeeusa.com', '', 237, 2385, 71664, '19921 Harrison Ave, City of Industry, CA 91789', 'info@komeeusa.com', '', '(909) 598-7788', '', '2018-05-08'),
(187, 1, 0, 1, 'Humanscale', 'HMN', 'Indoor Lighting', '', 'https://www.humanscale.com/', '', 237, 2386, 0, '5675 DTC Blvd Suite 100 Greenwood Village, CO 80111', 'info@humanscale.com', '', '+1 800 400 0625', '', '2018-05-08'),
(188, 1, 0, 1, 'Gammalux Lighting Systems', 'GLS', 'Indoor applications', '', '', '', 237, 0, 0, '248 East Arrow Highway, San Dimas, CA 91773', '', '', '', '', '2018-05-08'),
(189, 1, 0, 1, 'GVA Lighting', 'GVA', 'Architectural Lighting', '', '', '', 40, 0, 0, '3400 Ridgeway Drive, # 14 Mississauga, Ontario L5L 0A2', '', '', '', '', '2018-05-08'),
(190, 1, 0, 1, 'Lindsley Lighting', 'LLT', 'Indoor/outdoor lighting.', '', 'www.lindsleylighting.com', '', 237, 2385, 72000, '4871 Sunrise Drive Suite 101 Marinez CA 94553', 'info@lindsleylighting.com', '', '925.254.1860', '', '2018-05-10'),
(191, 1, 0, 1, 'Legion Lighting Company', 'LLC', 'Indoor/outdoor lighting.', '', 'www.legionlighting.com', '', 237, 2413, 82566, '221 Glenmore Avenue, Brooklyn, NY 11207', 'sales@legionlighting.com', '', '718-498-1770', '', '2018-05-10'),
(192, 1, 0, 1, 'Heper', 'HPR', 'Outdoor lighting', '', '', '', 227, 0, 0, 'OSB Uygurlar Cd. No:1 Sincan 06935, Ankara', '', '', '', '', '2018-05-10'),
(195, 1, 0, 1, 'Intrigue Lighting', 'ING', 'Outdoor/indoor lighting.', '', 'www.intrigueled.com', '', 237, 2430, 91112, 'N60 W14592 Kaul Avenue  Menomonee Falls, WI  53051', '', '', '877 965 0005', '', '2018-05-10'),
(196, 1, 0, 1, 'Illuminated Lightpanels', 'ILP', 'LED Edge-lite Illumination', '', '', '', 237, 0, 0, 'Northwest 29th Street  Oakland Park, FL  33311', '', '', '', '', '2018-05-10'),
(197, 1, 0, 1, 'iLight Technologies', 'ILT', 'Architectural lighting', '', '', '', 237, 0, 0, '118 S. Clinton #370, Chicago, IL', '', '', '', '', '2018-05-10'),
(198, 1, 0, 1, 'Reggiani', 'RGN', 'Indoor/outdoor lighting.', '', 'http://www.reggianiusa.com', '', 237, 2411, 81819, '372 Starke Road - Carlstadt, NJ 07072', 'info@reggianiusa.com', '', '201 372 1717', '', '2018-05-11'),
(199, 1, 0, 1, 'Lucent Lighting', 'LCT', 'Professional Architectural Lighting', '', '', '', 237, 0, 0, '4750 Route 145 Durham, NY 12422', '', '', '', '', '2018-05-11'),
(200, 1, 0, 1, 'Rayon Lighting Group', 'RLG', 'Indoor/outdoor lighting.', '', 'www.rayonlighting.com', '', 237, 2385, 71972, '1303 Mirasol St.  Los Angeles, CA 90023', 'info@rayonlighting.com', '', '(323) 446-2626', '', '2018-05-11'),
(201, 1, 0, 1, 'Orgatech', 'OTH', 'Indoor/outdoor lighting.', '', 'www.orgatech.com', '', 237, 2385, 0, '205 West Blueridge Avenue Orange, CA 92865​', 'sales@orgatech.com', '', '(626) 969-6820', '', '2018-05-11'),
(202, 1, 0, 15, 'Molto Luce', 'MTL', 'Decorative and architectural lighting', '', '', '', 237, 0, 0, '15774 Gateway Circle Tustin, CA 92780', '', '', '', '', '2018-05-11'),
(203, 1, 0, 1, 'Luxx Box', 'LBX', 'Indoor lighting.', '', 'www.luxxbox.com', '', 14, 0, 0, '43 Kenyon St, Eagle Farm Q 4009', 'info@luxxbox.com', '', '+61 7 3257 2822', '+61401 667 824', '2018-05-14'),
(204, 1, 0, 1, 'MP Lighting', 'MPL', 'Commercial, institutional, industrial, hospitality, and residential applications.', '', '', '', 40, 0, 0, '16 West 4th Avenue Vancouver  British Columbia  Canada V5Y 1G3', '', '', '', '', '2018-05-14'),
(205, 1, 0, 1, 'Aurora', 'AUR', 'Indoor/outdoor lighting.', '', 'www.aurora.eu.com', '', 237, 2390, 0, '12035 34th St North St Petersburg Florida 33716', '', '', '+1 (727) 524 4270', '', '2018-05-14'),
(206, 1, 0, 1, 'Teka Illumination', 'TKL', 'Indoor/outdoor lighting.', '', 'www.tekaillumination.com', '', 237, 2385, 71987, '40429 Brickyard Drive  Madera, Ca 93636', '', '', '(559) 438-5800', '', '2018-05-15'),
(207, 1, 0, 1, 'Teron Lighting', 'TLI', 'Indoor/Outdoor Lighting', '', 'https://teronlighting.com/', '', 237, 2416, 84570, '33 Donald Drive Fairfield, OH 45014', '', '', '(513) 858-6004', '', '2018-05-15'),
(208, 1, 0, 1, 'Vivid Leds', 'VVL', 'Indoor lighting.', '', 'www.vividleds.us', '', 237, 2395, 75593, 'Sellersburg, IN 47172', '', '', '800-974-3570', '', '2018-05-16'),
(209, 1, 0, 1, 'No. 8 Lighting', 'N8L', 'Indoor lighting', '', '', '', 237, 0, 0, '526 Portal Street Cotati, CA 94931', '', '', '', '', '2018-05-16'),
(210, 1, 0, 1, 'Optic Arts', 'OTA', 'Indoor and outdoor lighting', '', '', '', 237, 0, 0, '1130 Monterey Pass Rd, Monterey Park, CA 91754', '', '', '', '', '2018-05-16'),
(211, 1, 0, 1, 'Starfire Lighting', 'SFL', 'Indoor Lighting', '', 'http://www.starfirelighting.com/index.php', '', 237, 2411, 82263, '7 Donna Drive Wood-Ridge, NJ 07075', 'info@starfirelighting.com', '', '(201) 438-9540', '', '2018-05-16'),
(212, 1, 0, 1, 'Zaneen', 'ZNE', 'Indoor/outdoor lighting.', '', 'www.zaneen.com', '', 40, 292, 10896, '30 Tycos Drive Toronto, Ontario Canada M6B 1V9', '', '', '416 247 9221', '', '2018-05-17'),
(213, 1, 0, 1, 'Wayne Tyler', 'WAT', 'Outdoor Bollards', '', 'http://www.waynetyler.com/home.html', '', 237, 2385, 72236, '5797 Chesapeake Court, San Diego, CA 92123', '', '', '(858) 560-4800', '', '2018-05-17'),
(214, 1, 0, 1, 'HessAmerica', 'HSA', 'Outdoor lighting.', '', 'www.hessamerica.com', '', 237, 2421, 87169, 'P.O. Box 28 Gaffney, SC 29342-0028', 'info@hessamerica.com', '', '+1 864-487-3535', '', '2018-05-17'),
(215, 1, 0, 1, 'MOJO Illumination', 'MJI', 'Indoor Illumination', '', 'http://mojoillum.com/', '', 237, 2386, 72704, '1501 West 124th Avenue Suite 600A Westminster, CO, 80234', 'sales@mojoillum.com', '', '1.877.600.2673', '', '2018-05-18'),
(216, 1, 0, 1, 'IMPACT Architectural Lighting', 'IAL', 'Indoor lighting.', '', 'www.impactltg.com', '', 237, 2406, 80852, '8431 Mid County Industrial saint louis, mo 63114', '', '', '314.427.1212', '', '2018-05-18'),
(217, 1, 0, 1, 'Industrial Lighting Products', 'INP', 'Commercial, industrial, and outdoor applications', '', '', '', 237, 0, 0, '519 CODISCO WAY SANFORD, FL 32771', '', '', '', '', '2018-05-18'),
(218, 1, 0, 1, 'Truly Green Solutions', 'TGS', 'Indoor/Outdoor', '', 'http://trulygreensolutions.com', '', 237, 2385, 71652, '9601 Variel Avenue Chatsworth, CA 91311', 'info@trulygreensolutions.com', '', '818-206-4404', '', '2018-05-18'),
(219, 1, 0, 18, 'ALM', 'ALM', 'World-class lighting solutions for large public spaces such as offices and hotels. The standard range is complimented by modified and custom solutions.', '', 'www.inter-lux.com/brands-category/alm/', '', 237, 2401, 77993, 'United States', '', '', '', '', '2018-05-21'),
(220, 1, 0, 1, 'i2Systems', 'I2S', 'Architectural, Retail, Elevator, Marine and Transit lighting', '', 'http://www.i2systems.com/statics/home/#', '', 237, 2387, 72823, '355 Bantam Lake Rd Morris, CT 06763 USA', 'info@i2systems.com', '', '+1.860.567.0708', '', '2018-05-21'),
(222, 1, 0, 18, 'Filix', 'FIX', 'High-quality outdoor LED luminaires designed with versatility and attention to detail. These robust luminaires have been featured in projects from internationally-renowned designers.', '', 'www.inter-lux.com/brands-category/filix/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-05-21'),
(223, 1, 0, 1, 'Griven', 'GVN', 'Outdoor, indoor and underwater LED lighting.', '', '', '', 237, 0, 0, 'P.O. Box 28 Gaffney, SC 29342', '', '', '', '', '2018-05-21'),
(224, 1, 0, 1, 'Leotek', 'LTK', 'Outdoor Lighting', '', 'https://leotek.com/#', '', 237, 2385, 72244, '1955 Lundy Avenue San Jose, CA 95131', '', '', '(408) 380-1788', '', '2018-05-21'),
(225, 1, 0, 18, 'Whitegoods', 'WGD', 'Luminaires that blend perfectly with adjoining surfaces to create the most integrated lighting schemes with one unified style and maximum efficiency of design.', '', 'www.inter-lux.com/brands-category/whitegoods/', '', 237, 2401, 77993, 'United States', '', '', '', '', '2018-05-22'),
(227, 1, 0, 9, 'Hubbell Outdoor Lighting', 'HUO', 'Outdoor Lighting', '', 'https://www.hubbell.com/hubbelloutdoorlighting/en/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-05-22'),
(228, 1, 0, 9, 'Columbia Lighting', 'CLM', 'Indoor lighting.', '', 'https://www.hubbell.com/columbialighting/en/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-05-22'),
(229, 1, 0, 1, 'Solid State Luminaires', 'SSL', 'Indoor and outdoor lighting.', '', 'https://www.solidstateluminaires.com/', 'images/mnf-search-banners/mnf-search-banners-1/229-SSL_toplogo.jpg', 237, 0, 0, '3609 Swenson Ave., St. Charles, IL 60174', '', '', '', '', '2018-05-22'),
(230, 1, 0, 1, 'King Luminaire', 'KNG', 'Outdoor Lighting', '', 'http://www.stresscretegroup.com/Home.aspx', '', 237, 2416, 84665, '1153 State Route 46 North P.O. Box 266 Jefferson, OH 44047', 'sales@stresscrete.com', '', '(440) 576-9073', '', '2018-05-22'),
(231, 1, 0, 1, 'SpecGrade LED', 'SGL', 'Outdoor Lighting', '', 'https://www.specgradeled.com/', '', 237, 2416, 84507, '153 OUTERBELT STREET COLUMBUS, OH 43213', '', '', '888 560 4060', '', '2018-05-23'),
(233, 1, 0, 1, 'SONARAY', 'SNR', 'Industrial and commercial lighting.', '', '', '', 237, 0, 0, '34 Lakeview Court Verona, VA 24482', '', '', '', '', '2018-05-23'),
(234, 1, 0, 9, 'Dual-Lite', 'DLL', 'Emergency & Exit Lighting.', '', '', '', 237, 0, 0, '40 Waterview Drive Shelton, Connecticut', '', '', '', '', '2018-05-23'),
(235, 1, 0, 1, 'Apogee Translite', 'ATL', 'Architectural and infrastructure lighting', '', '', '', 237, 0, 0, '593 Acorn Street Deer Park, NY 11729', '', '', '', '', '2018-05-23'),
(237, 1, 0, 1, 'ASL', 'AML', 'Indoor/outdoor lighting.', '', 'www.asllighting.com', '', 237, 2413, 82566, '25 Twelfth Street Brooklyn, NY 11215-3820', 'info@asllighting.com', 'order@asllighting.com', '(718) 369-1100', '', '2018-05-24'),
(238, 1, 0, 4, 'Luminaire LED', 'LUL', 'Indoor/Outdoor Lighting', '', 'https://luminaireled.acuitybrands.com/', 'images/mnf-search-banners/mnf-search-banners-1/238-LuminaireLED_toplogo.jpg', 237, 0, 0, 'United States', '', '', '', '', '2018-05-24'),
(239, 1, 0, 1, 'ConTech Lighting', 'CTC', 'Indoor lighting.', '', '', '', 237, 0, 0, '725 Landwehr Road Northbrook, IL 60062', '', '', '', '', '2018-05-24'),
(240, 1, 0, 1, 'Beghelli', 'BGL', 'Indoor/outdoor lighting.', '', 'www.beghelliusa.com', '', 237, 2390, 73251, '3250 Corporate Way Miramar, FL. 33025 USA', '', '', '(954) 442-6600', '', '2018-05-24'),
(241, 1, 0, 1, 'Elite Lighting', 'ELT', 'Indoor/outdoor lighting.', '', 'www.iuseelite.com', '', 237, 0, 0, 'United States', '', '', '+1 (323) 888-1973', '', '2018-05-24'),
(242, 1, 0, 1, 'LF Illumination', 'LIN', 'Indoor/outdoor lighting.', '', 'www.lfillumination.com', '', 237, 2385, 71652, '9200 Deering Avenue Chatsworth, CA 91311', '', '', '1-818-885-1335', '1-855-885-1335', '2018-05-25'),
(243, 1, 0, 1, 'Luraline Lighting', 'LRL', 'Indoor/Outdoor Lighting', '', 'https://www.luraline.lighting/home.html', '', 237, 2390, 73285, '2388 Northwest 150th Street Opa Locka, Florida 33054', '', '', '(305) 685-6588', '(800) 940-6588', '2018-05-25'),
(244, 1, 0, 1, 'Ligman Lighting', 'LGM', 'Outdoor lighting', '', '', '', 237, 0, 0, '7144 NE Progress Court Hillsboro, Oregon, 97124', '', '', '', '', '2018-05-25'),
(246, 1, 0, 1, 'Meteor Lighting', 'MET', 'Indoor/Outdoor Lighting', '', 'http://www.meteor-lighting.com/web/page/index.php', '', 237, 2385, 71664, '1300 John Reed Court, Unit B, City of Industry, California 91745', '', '', '(213) 255 2060', '', '2018-05-25'),
(247, 1, 0, 1, 'Lumascape', 'LMS', 'Outdoor lighting', '', '', '', 237, 0, 0, 'Unit 19, 1300 Industrial Road, San Carlos California, 94070, United States', '', '', '', '', '2018-05-25'),
(248, 1, 0, 1, 'Schreder', 'SHR', 'Outdoor Lighting', '', 'http://internal.schreder.com/en-us', '', 237, 2394, 74821, '1415 West 22nd Street, T Floor  Oak Brook, IL  60523  United States', 'b.hu@schreder.com', '', '+1 (847) 621-5130', '', '2018-05-28'),
(249, 1, 0, 1, 'TM Lighting', 'TML', 'Indoor lighting.', '', '', '', 236, 0, 0, 'Unit 10, 21 Wren St London, WC1X 0HF', '', '', '', '', '2018-05-28'),
(250, 1, 0, 1, 'Shockwave', 'SKW', 'Indoor lighting.', '', 'www.shockwave.saco.com', '', 237, 0, 0, 'United States', 'support@saco.com', '', '514.745.0310', '', '2018-05-28'),
(251, 1, 0, 1, 'Green Creative', 'GRC', 'Indoor Lighting', '', 'http://gc-lighting.com/', '', 237, 2385, 72233, '1200 Bayhill Drive, Suite 220 San Bruno, CA 94066', 'sales@greencreative.com', '', '(866) 774-5433', '', '2018-05-29'),
(252, 1, 0, 1, 'Insight Lighting', 'INS', 'Indoor lighting.', '', 'https://www.insightlighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/252-Insight_Lighting_toplogo.jpg', 237, 2412, 82399, '4341 Fulcrum Way NE Rio Rancho, New Mexico 87144', '', '', '(505) 345-0888', '', '2018-05-29'),
(253, 1, 0, 1, 'Astro Lighting Limited', 'ALL', 'Indoor lighting.', '', 'www.us.astrolighting.com', '', 237, 2411, 82186, '50 Division Street,  Suite 501 Somerville,  NJ 08876 USA', '', '', '1.800.240.7071', '', '2018-05-29'),
(254, 1, 0, 1, 'Amico', 'AMC', 'Indoor Lighting', '', 'http://www.amico.com/', '', 237, 2413, 82701, '71 East Industry Court Deer Park, New York 11729', '', '', '(631) 225-5695', '+1 (877) 462-6426', '2018-05-29'),
(255, 1, 0, 1, 'KKDC', 'KDC', 'Interior and exterior lighting.', '', '', '', 237, 0, 0, '560 Sylvan Ave Suite 1315 Englewood Cliffs New Jersey 07632', '', '', '', '', '2018-05-29');
INSERT INTO `manufacturers` (`manf_id`, `active`, `coming_soon`, `brand_id`, `manf_name`, `code`, `description`, `logo`, `url`, `search_banner`, `country_id`, `region_id`, `city_id`, `address`, `email1`, `email2`, `phone1`, `phone2`, `dt`) VALUES
(256, 1, 0, 1, 'Sonneman', 'SNM', 'Indoor lighting.', '', 'www.sonnemanawayoflight.com', '', 237, 2413, 83495, '151 Airport Drive | Wappingers Falls, NY 12590', 'info@sonnemanawayoflight.com', '', '845-926-5469', '', '2018-05-29'),
(257, 1, 0, 1, 'Fabbian Usa', 'FAB', 'Indoor Luminaires', '', 'https://www.fabbian.us/', '', 237, 2413, 83145, '307 W 38th St, Ste 1103 New York, NY 10018 USA', 'usa@fabbian.com', '', '+1 646 518 4160', '', '2018-05-29'),
(258, 1, 0, 1, 'Innermost', 'INM', 'Indoor lighting.', '', '', '', 237, 0, 0, '57 Saunders Hollow Rd, Old Lyme, CT 06371', '', '', '', '', '2018-05-29'),
(259, 1, 0, 1, 'LEDS C4', 'LC4', 'Indoor and outdoor lighitng.', '', '', '', 209, 0, 0, 'c/ Afores, s/n 25750 - Torà (Lleida) - Spain', '', '', '', '', '2018-05-29'),
(260, 1, 0, 1, 'Contardi USA', 'CNU', 'Indoor/Outdoor Luminaires', '', 'https://www.contardi-italia.com/usa_index.php', '', 237, 2413, 82566, '59 Pearl Street, Unit 21 - 11201 Brooklyn NY', 'sales@contardi-usa.com', '', '001 718-715-0717', '', '2018-05-30'),
(261, 1, 0, 1, 'Modular Lighting Instruments', 'MLI', 'Indoor lighting.', '', 'www.supermodular.com', '', 237, 0, 0, 'United States', 'john.yriberri@supermodular.com', '', '+1 412 398 6652', '', '2018-05-30'),
(263, 1, 0, 1, 'Optec', 'OPT', 'Outdoor Lighting', '', 'http://www.optecledlighting.com', '', 237, 2385, 72099, '1700 S. De Soto Place  Ontario, CA 91761', 'info@optecledlighting.com', '', '888-743-5220', '', '2018-05-30'),
(265, 1, 0, 1, 'SGM', 'SGM', 'Indoor lighting.', '', 'www.sgmlight.com', '', 237, 2390, 73290, '7806 Kingspointe Parkway, FL 32819 Orlando USA', 'ffr@sgmlight.com', '', '+1 (407) 440-3601', '', '2018-05-30'),
(266, 1, 0, 1, 'OM light', 'OML', 'Indoor and outdoor lighting.', '', '', '', 174, 0, 0, '4400-289 Vila Nova de Gaia, Porto. Portugal', '', '', '', '', '2018-05-30'),
(270, 1, 0, 1, 'American Lighting', 'ACG', 'Indoor & Architectural Lighting', '', 'http://www.americanlighting.com/index.html', '', 237, 2386, 72521, '11775 E. 45th AVE., DENVER, CO 80239', 'Sales@AmericanLighting.com', 'TechnicalSupport@AmericanLighting.com', '800.880.1180', '', '2018-05-30'),
(271, 1, 0, 20, 'Ai Lati Lights', 'AIL', 'Indoor lighting.', '', '', '', 109, 0, 0, '31055 Quinto di Treviso (TV) ITALY', '', '', '', '', '2018-05-30'),
(272, 1, 0, 1, 'Access Lighting', 'ACS', 'Indoor/outdoor lighting.', '', 'www.accesslighting.com', '', 237, 2385, 71883, '14410 Myford Road, Irvine, CA  92606', '', '', '+1-714-247-1270', '+1-800-828-5483', '2018-05-31'),
(273, 1, 0, 1, 'BuzziSpace', 'BZS', 'Indoor lighting.', '', '', '', 237, 0, 0, '1200 Redding Drive High Point, NC 27260', 'us@buzzi.space', '', '+1 336 821 3150', '', '2018-05-31'),
(274, 1, 0, 21, 'dweLED', 'DWL', 'Indoor/Outdoor LED Luminaires', '', 'http://www.waclighting.com/products/285', '', 237, 0, 0, 'United States', '', '', '', '', '2018-05-31'),
(275, 1, 0, 1, 'Boyd Lighting', 'BDL', 'Indoor lighting', '', 'https://boydlighting.com', '', 237, 2385, 0, '30 Liberty Ship Way Suite 3150 · Sausalito CA 94965', '', '', '', '', '2018-05-31'),
(276, 1, 0, 1, 'CSL', 'CSL', 'Indoor lighting.', '', 'http://www.csllighting.com', '', 237, 2385, 71664, '14508 Nelson Avenue City of Industry, CA 91744', '', '', '626.336.4511', '', '2018-05-31'),
(277, 1, 0, 1, 'Alma Light', 'AMA', 'Indoor and outdoor lighting.', '', '', '', 209, 0, 0, 'Cristobal de Moura, 195-197, 08019, Barcelona, Spain', '', '', '', '', '2018-05-31'),
(278, 1, 0, 1, 'Contraste', 'CNT', 'Indoor Luminaires', '', 'https://www.contrastlighting.com/index', '', 40, 294, 11230, '1009, rue du Parc-Industriel Lévis QC G6Z 1C5 Canada', '', '', '418-839-4624', '1 888-839-4624', '2018-05-31'),
(279, 1, 0, 1, 'Besa Lighting', 'BES', 'Indoor lighting.', '', 'www.besalighting.com', '', 237, 2416, 84425, '6695 Taylor Rd. Blacklick, OH 43004', '', '', '614.762.8900', '800.446.2372', '2018-05-31'),
(280, 1, 0, 1, 'EGLO', 'EGL', 'Indoor and outdoor lighting', '', '', '', 237, 0, 0, '3640 Royal South Parkway  Atlanta, GA 30349', '', '', '', '', '2018-05-31'),
(281, 1, 0, 1, 'Estiluz', 'ETZ', 'Indoor/outdoor lighting.', '', 'www.estiluzusa.com', '', 237, 2413, 83145, '330 West 38th Street Suite 710 New York, NY 10018. USA', 'info@estiluzusa.com', '', '+1 646 454 1285', '', '2018-06-01'),
(282, 1, 0, 1, 'Flos', 'FLS', 'Indoor/Outdoor Lighting', '', 'https://usa.flos.com/', '', 237, 2413, 82566, 'Flos USA, Inc. 110 York Street, 5th Fl Brooklyn, NY 11201', 'e-shop@flosusa.com', 'press@flosusa.com', '718.875.3472', '', '2018-06-01'),
(283, 1, 0, 1, 'Fredrick Ramond', 'FRD', 'Home and Outdoor Lighting', '', 'http://www.fredrickramond.com/', '', 237, 2416, 84395, '33000 PIN OAK PARKWAY AVON LAKE, OH 44012', 'service@hinkleylighting.com', '', '(440) 653-5500', '800.446.5539', '2018-06-01'),
(284, 1, 0, 1, 'Kuzco Lighting', 'KZC', 'Indoor/outdoor lighting.', '', 'www.kuzcolighting.com', '', 237, 2409, 81493, '3035 E. Lone Mountain Road Las Vegas, NV, USA, 89081', 'info@kuzcolighting.com', '', '', '', '2018-06-01'),
(285, 1, 0, 1, 'NEMO', 'NEM', 'Indoor and outdoor lighting.', '', '', '', 237, 0, 0, '625 Jersey Avenue, Unit 7 New Brunswick, NJ 08901', '', '', '', '', '2018-06-01'),
(286, 1, 0, 1, 'Hubbardton Forge', 'HBF', 'Indoor/Outdoor Lighting', '', 'https://www.hubbardtonforge.com', '', 237, 2426, 89230, 'Hubbardton Forge 154 Route 30 South Castleton, Vermont 05735', 'customerservice@vtforge.com', 'commercial@vtforge.com', '(800) 826-4766', '', '2018-06-01'),
(287, 1, 0, 1, 'Hoffmeister', 'HFM', 'Indoor/Outdoor', '', 'http://www.hoffmeister.de/en/', '', 83, 0, 0, 'Germany', 'gsieverding@hoffmeister.de', '', '+49 2355 5041-399', '+49 151 551 159 15', '2018-06-01'),
(288, 1, 0, 1, 'Feiss', 'FSS', 'Indoor/outdoor lighting.', '', 'www.feiss.com', '', 237, 0, 0, 'United States', 'customerservice@generation-brands.com', '', '1.800.969.3347', '', '2018-06-01'),
(289, 1, 0, 1, 'HUNZA', 'HNZ', 'Outdoor lighting.', '', '', '', 154, 0, 0, '130 Felton Mathew Ave Saint Johns Auckland 1072 New Zealand', '', '', '', '', '2018-06-01'),
(290, 1, 0, 1, 'Maxim Lighting', 'MAX', 'Indoor/outdoor lighting.', '', 'www.maximlighting.com', '', 237, 2385, 71664, '253 N Vineland Ave. City of Industry, CA 91746', '', '', '626.956.4200', '', '2018-06-04'),
(291, 1, 0, 1, 'Luceplan', 'LCP', 'Indoor/Outdoor Lighting', '', 'https://www.luceplanusa.com/', '', 237, 2413, 83145, '14 Wooster Street  New York, NY 10013', 'infous@luceplan.com', '', '+1 (212) 334 1809', '', '2018-06-04'),
(292, 1, 0, 1, 'Lee Broom', 'LEB', 'Indoor lighting.', '', '', '', 237, 2413, 0, '34 Greene Street New York NY 10013', '', '', '+1 212 804 8477', '', '2018-06-04'),
(293, 1, 0, 1, 'Hammerton Studio', 'HMS', 'Indoor and outdoor lighting', '', '', '', 237, 0, 0, '217 Wright Brothers Drive Salt Lake City, UT 84116', '', '', '', '', '2018-06-04'),
(294, 1, 0, 1, 'Norwell Lighting', 'NOR', 'Indoor/outdoor lighting.', '', 'www.norwellinc.com', '', 237, 2402, 78428, '82 Stevens Street East Taunton, MA 02718', 'customerservice@norwellinc.com', '', '508-977-9991', '', '2018-06-04'),
(295, 1, 0, 1, 'LZF Lamps', 'LZF', 'Indoor Luminaires', '', 'https://lzf-lamps.com', '', 209, 2033, 62861, 'Avenida Reino de Valencia 14 46370 Chiva Valencia Spain', '', '', '+34 962 524 780', '', '2018-06-04'),
(296, 1, 0, 1, 'Lotus LED Lights', 'LLL', 'Indoor lighting', '', '', '', 237, 0, 0, '3425 Radio Road, Suite 202 Naples, FL 34104', '', '', '', '', '2018-06-04'),
(297, 1, 0, 1, 'Hinkley Lighting', 'HNK', 'Indoor and outdoor lighting', '', '', '', 237, 0, 0, '33000 PIN OAK PARKWAY   AVON LAKE, OH 44012', '', '', '', '', '2018-06-04'),
(299, 1, 0, 1, 'Modern Verve', 'MDV', 'Indoor', '', 'https://modernverve.com', '', 237, 2428, 90230, '2909 16th Ave', 'info@modernverve.com', 'sales@modernverve.com', '(206) 265-2844', '', '2018-06-05'),
(300, 1, 0, 1, 'PLC Lighting', 'PLC', 'Indoor/outdoor lighting.', '', 'www.plclighting.com', '', 237, 2385, 71652, '9667 Owensmouth Avenue Unit 201 Chatsworth CA 91311', 'plclighting@plclighting.com', '', '(818) 349-1600', '', '2018-06-05'),
(301, 1, 0, 1, 'Ushio', 'USH', 'Indoor/Outdoor Lighting', '', 'https://www.ushio.com/', '', 237, 2385, 71708, '5440 Cerritos Ave. Cypress, CA 90630', 'customerservice@ushio.com', '', '(714) 236.8600', '', '2018-06-05'),
(303, 1, 0, 1, 'Ultralights', 'UTR', 'Indoor/outdoor lighting.', '', 'www.ultralightslighting.com', '', 237, 2383, 71167, '1936 E 18th Street Tucson, AZ 85716', 'info@ultralightslighting.com', '', '520-623-9829', '', '2018-06-05'),
(304, 1, 0, 1, 'Nora Lighting', 'NRL', 'Indoor/Exit&Emergency Lighting', '', 'http://www.noralighting.com/Default.aspx', '', 237, 2385, 71972, 'Nora Lighting, 6505 Gayhart Street, Commerce, CA 90040', '', '', '800.686.6672', '', '2018-06-05'),
(305, 1, 0, 1, 'Vermont Modern', 'VTM', 'Indoor lighting', '', '', '', 237, 0, 0, '154 Route 30 South  Castleton, VT 05735', '', '', '', '', '2018-06-05'),
(306, 1, 0, 1, 'Ricca Design', 'RCD', 'Indoor Lighting', '', 'http://www.riccadesign.com/en/index.html', '', 237, 2385, 71573, '468 North Camden Drive Beverly Hills, CA 90210', 'info@riccadesign.com', '', '(310) 601 3003', '', '2018-06-06'),
(307, 1, 0, 1, 'Eurofase', 'ERS', 'Indoor/Outdoor', '', 'http://www.eurofase.com/', '', 237, 2424, 88244, 'Eurofase Showroom, Suite #4002 2100 Stemmons Freeway', '', '', '(905) 695-2055', '1 (800) 660-5391', '2018-06-06'),
(308, 1, 0, 1, 'Sea Gull Lighting', 'SAG', 'Indoor and outdoor lightins.', '', 'http://www.seagulllighting.com/HomePage.cfm', '', 237, 0, 0, '301 W Washington St, Riverside, NJ 08075', '', '', '', '', '2018-06-06'),
(309, 1, 0, 1, 'Synchronicity', 'SHN', 'Indoor  lighting.', '', '', '', 237, 0, 0, '154 Route 30 South Castleton, Vermont 05735', '', '', '(800) 826-4766', '', '2018-06-06'),
(310, 1, 0, 1, 'Resident', 'RES', 'Indoor lighting.', '', 'www.resident.co.nz', '', 154, 0, 0, '61 Upper Queen Street Newton Auckland New Zealand', 'sales@resident.co.nz', '', '+64 9 601 9241', '', '2018-06-06'),
(311, 1, 0, 1, 'SLV Lighting', 'SLG', 'Indoor/Outdoor Lighting', '', 'https://www.slvlighting.com/en-us.html', '', 237, 2390, 73379, '5022 Joanne Kearney Boulevard Tampa, Florida 33619', '', '', '813-349-1900', '', '2018-06-06'),
(312, 1, 0, 1, 'Marset', 'MRS', 'Indoor and outdoor lighting.', '', '', '', 237, 0, 0, '20 West 22nd Street Suite 903 New York, NY 10010', '', '', '', '', '2018-06-06'),
(313, 1, 0, 1, 'TROY RLM LIGHTING', 'TRL', 'Indoor and outdoor lighting', '', '', '', 237, 0, 0, '14508 Nelson Ave., City of Industry California', '', '', '', '', '2018-06-06'),
(314, 1, 0, 1, 'Lumen Center Italia', 'LCI', 'Indoor/outdoor lighting.', '', 'www.lumencenteritalia.com', '', 109, 0, 0, 'Via Donatori del Sangue n.37 20010 Santo Stefano Ticino, MI Italia', 'info@lumencenteritalia.com', '', '0039 02 3654 4811', '', '2018-06-06'),
(315, 1, 0, 1, 'Ingo Maurer', 'IMR', 'Indoor', '', 'https://ingo-maurer.com/en/', '', 237, 2413, 83145, '​New York Showroom Ingo Maurer LLC 89 Grand Street; 10013', 'making-light@ingomaurer-usa.com', '', 'Tel. +1 212 965 8817', '', '2018-06-06'),
(316, 1, 0, 1, 'Pablo', 'PBL', 'Indoor lighting.', '', '', '', 237, 0, 0, '888 Marin Street San Francisco, CA 94124', 'info@pablodesigns.com', '', '+415 865 5000', '', '2018-06-06'),
(317, 1, 0, 1, 'ETi Solid State Lighting', 'ETI', 'Indoor/Outdoor Lighting', '', 'http://www.etissl.com/', '', 237, 2394, 75084, '720 Corporate Woods Parkway Vernon Hills, IL  60061', 'ETiorders@ETISSL.COM', 'warranty.service@ETISSL.COM', '1-855-384-7754', '', '2018-06-07'),
(318, 1, 0, 1, 'Lumi Bright', 'LBT', 'Indoor/outdoor lighting.', '', 'www.lumibright.co.uk', '', 236, 2380, 70496, 'Phase 2 Building Davy Way, Llay,Wrexham,  Wales,LL12 OPG,UK', 'sales@lumibright.co.uk', '', '+44 (0) 844 202 2466', '', '2018-06-07'),
(319, 1, 0, 1, 'DMF Lighting', 'DMF', 'Indoor Lighting', '', 'https://www.dmflighting.com/', '', 237, 2385, 71639, '1118 East 223rd Street Carson, California 90745, USA', 'info@dmflighting.com', '', '1.800.441.4422', '', '2018-06-07'),
(320, 1, 0, 1, 'Times Square Lighting', 'TSL', 'Indoor/outdoor lighting.', '', 'www.tslight.com', '', 237, 2413, 83428, '5 Holt Drive Stony Point, NY 10980', '', '', '(845) 947-3034', '', '2018-06-07'),
(321, 1, 0, 1, 'EarthTronics', 'ERT', 'Indoor lighting.', '', '', '', 237, 0, 0, '380 West Western Avenue Suite 301 Muskegon, MI 49440', '', '', '231-332-1188', '', '2018-06-07'),
(322, 1, 0, 1, 'FINELITE', 'FNT', 'Indoor lighting', '', 'http://www.finelite.com/home/', '', 237, 0, 0, '30500 Whipple Road Union City, CA 94587-1530', '', '', '', '', '2018-06-07'),
(323, 1, 0, 1, 'XtraLight', 'XTL', 'Indoor/Outdoor', '', 'http://www.xtralight.com/', '', 237, 2424, 88442, '8812 Frey Rd', 'info@xtralight.com', '', '+1 (877) 230 6310', '', '2018-06-07'),
(324, 1, 0, 1, 'Jesco Lighting Group', 'JLG', 'Indoor and outdoor lighting.', '', '', '', 237, 0, 0, '15 Harbor Park Drive  Port Washington, NY 11050', '', '', '800.527.7796', '', '2018-06-07'),
(325, 1, 0, 1, 'Crenshaw', 'CRW', 'Decorative indoor lighting', '', '', '', 237, 0, 0, '592 Paradise Lane SE, Floyd, VA 24091', '', '', '', '', '2018-06-07'),
(326, 1, 0, 1, 'Ambiance Lighting Systems', 'ALS', 'Indoor Lighting', '', 'http://www.ambiance-lighting.com/', '', 237, 0, 0, 'United States', 'Info@Ambiance-Lighting.com', 'Info@Ambiance-Lighting.com', '1.800.347.5483', '1.866.449.2821', '2018-06-08'),
(327, 1, 0, 1, 'ABOVE ALL', 'ABV', 'Outdoor/indoor lighting.', '', 'www.abovealllighting.com', '', 237, 2411, 82216, '1501 Industrial Way N.  Toms River, NJ 08755', 'info@abovealllighting.com', '', '866-222-8866', '', '2018-06-08'),
(328, 1, 0, 1, 'ELCO Lighting', 'ELC', 'Indoor Lighting', '', 'http://www.elcolighting.com/', '', 237, 2385, 71972, '2042 East Vernon Ave.  Los Angeles, CA 90058', 'customerservice@elcolighting.com', '', '(800) 522-2626', '', '2018-06-08'),
(329, 1, 0, 22, 'Nordeon', 'NRD', 'Indoor and outdoor lighting.', '', 'www.nordeon-usa.com', '', 237, 0, 0, 'p.o. Box 28 Gaffney, SC 29342, USA', 'info@nordeon-usa.com', '', '+1 864-487-3535', '', '2018-06-08'),
(330, 1, 0, 1, 'Feelux Lighting', 'FEL', 'Indoor LED Luminaires', '', 'http://www.feeluxlighting.com/', '', 237, 2391, 73755, '3000 Northwoods Parkway, Suite 165  Norcross, GA 30071', '', '', '(678) 668-7005', '', '2018-06-08'),
(331, 1, 0, 1, 'MaxLite', 'MXL', 'Indoor and outdoor lighting.', '', 'http://www.maxlite.com', '', 237, 0, 0, 'West Caldwell, NJ', 'info@maxlite.com', '', '973-244-7300', '', '2018-06-08'),
(332, 1, 0, 1, 'Koncept', 'KON', 'Indoor lighting', '', '', '', 237, 0, 0, '429 E. Huntington Drive Monrovia, CA 91016', '', '', '', '', '2018-06-08'),
(333, 1, 0, 1, 'EYE Lighting', 'EYE', 'Indoor Luminaires', '', 'http://eyelighting.com', '', 237, 2416, 84761, '9150 Hendricks Rd Mentor, OH 44060', '', '', '(888) 665-2677', '(440) 358-4700', '2018-06-08'),
(334, 1, 0, 1, 'Liteline', 'LEL', 'Indoor lighting.', '', '', '', 40, 0, 0, '90 West Beaver Creek Road Richmond Hill Ontario, Canada', '', '', '', '', '2018-06-08'),
(335, 1, 0, 1, 'Lutron', 'LTR', 'Indoor lighting', '', 'http://www.lutron.com/', '', 237, 2419, 85968, 'Lutron Electronics Co., Inc.  7200 Suter Road, 18036', 'mediarequest@lutron.com', 'customersatisfaction@lutron.com', '1.800.523.9466', '1.800.523.9466', '2018-06-11'),
(336, 1, 0, 1, 'Arturo Alvarez', 'AAZ', 'Indoor lighting.', '', 'www.arturo-alvarez.com', '', 209, 0, 0, 'Rúa Castiñeiras 108 A, 15895 O Milladoiro (A Coruña)', '', '', '00 34 981 81 46 00', '', '2018-06-11'),
(337, 1, 0, 1, 'Cooledge', 'CLD', 'Indoor and outdoor lighitng.', '', '', '', 40, 0, 0, '120-13551 Commerce Parkway Richmond, BC V6V 2L1, Canada', '', '', '', '', '2018-06-11'),
(338, 1, 0, 1, 'Studio Italia Design', 'SID', 'Decorative indoor lighting', '', '', '', 237, 0, 0, '465 West Main St Wyckoff, NJ 07481', '', '', '', '', '2018-06-11'),
(341, 1, 0, 1, 'Start Lighting', 'SLH', 'Indoor/Outdoor lighting.', '', 'https://www.start-lighting.com/', '', 237, 2386, 72536, '14 Inverness Drive East Suite F-156 Englewood, CO 80112', '', '', '866-862-9352', '', '2018-06-11'),
(342, 1, 0, 1, 'Remote Control Lighting', 'RCL', 'Indoor lighting.', '', '', '', 236, 0, 0, '42 Riverside Road London SW17 0BA', 'sales@rclighting.com', '', '+44 (0)20 8404 2400', '', '2018-06-11'),
(343, 1, 0, 1, 'Martinelli Luce Spa', 'MLS', 'Indoor/outdoor lighting.', '', 'www.martinelliluce.it', '', 109, 0, 0, 'Via Teresa Bandettini 55100 Lucca (Lu) - Italy', 'info@martinelliluce.it', '', '+39/0583.418315', '', '2018-06-11'),
(344, 1, 0, 1, 'TMS LIGHTING', 'TMS', 'Indoor lighting', '', '', '', 40, 0, 0, '247A Summerlea Road Brampton, Ontario Canada. L6T 4E1', '', '', '', '', '2018-06-11'),
(346, 1, 0, 1, 'Lumingen Technologies', 'LMG', 'Interior/Exterior Lighting', '', 'http://www.lumingen.com', '', 40, 285, 9715, '#155-19358 96 Ave, Surrey BC, Canada V4N 4C1', 'info@lumingen.com', '', '1-855-262-2111', '(604) 371-4112', '2018-06-11'),
(349, 1, 0, 1, 'Sigma Luminous', 'SIG', 'Indoor and outdoor lighting', '', '', '', 237, 0, 0, '36800 Plymouth Rd. Livonia, MI 48150', '', '', '', '', '2018-06-11'),
(351, 1, 0, 1, 'PMC Lighting', 'PMC', 'Indoor Lighting', '', 'http://www.pmclighting.com/', '', 237, 2420, 87071, '100 Gilbane Street Warwick, RI 02886', 'info@pmclighting.com', '', '401-738-7266', '', '2018-06-12'),
(352, 1, 0, 1, 'Skyler', 'SKY', 'Indoor/outdoor lighting.', '', 'www.skylertek.com', '', 237, 2385, 71526, '174 W Lincoln Ave, Anaheim, CA 92805', 'info@skylertek.com', '', '+1 657-859-3233', '', '2018-06-12'),
(353, 1, 0, 1, 'Ohyama Lights', 'OHY', 'Indoor/Outdoor', '', 'http://ohyamalights.com/', '', 237, 2430, 91199, '11111 80th Avenue  Pleasant Prairie, Wisconsin 53158', 'orders@ohyamalights.com', '', '262-925-6505', '', '2018-06-12'),
(354, 1, 0, 1, 'Canarm', 'CNM', 'Decorative indoor and outdoor lighting', '', '', '', 237, 0, 0, '808 Commerce Park Drive, Ogdensburg, New York, USA 13669', '', '', '', '', '2018-06-12'),
(355, 1, 0, 1, 'Landscape Forms', 'LSF', 'Outdoor lighting.', '', '', '', 237, 0, 0, '7800 E. Michigan Ave. Kalamazoo, MI 49048', '', '', '', '', '2018-06-12'),
(356, 1, 0, 1, 'Snowball Lighting Incorporated', 'SNW', 'Indoor/Outdoor/Decorative Lighting', '', 'http://www.snowball-inc.com/en', '', 237, 2424, 88299, '1555 Goodyear Drive. Suite A, EI Paso, Texas, 79936', 'sales@snowball-inc.com', '', '+1 915 227 7210', '', '2018-06-12'),
(357, 1, 0, 1, 'B Light', 'BLI', 'Indoor/Outdoor Lighting', '', 'https://www.b-light.it', '', 109, 0, 0, 'Via Galvani, 6 33083, Villotta di Chions (PN) Italy', 'info@b-light.it', '', '+39 0434 630835', '', '2018-06-12'),
(358, 1, 0, 1, 'Alumilite', 'AUL', 'Outdoor lighting.', '', '', '', 237, 0, 0, '5322 A Rafe Banks Drive  Flowery Branch, GA 30542', '', '', '', '', '2018-06-12'),
(359, 1, 0, 1, 'Eskodesign', 'ESD', 'Indoor lighting', '', '', '', 59, 0, 0, 'Solvangsvej 9, 4681 Herfølge', '', '', '', '', '2018-06-12'),
(360, 1, 0, 1, 'ARCUS', 'ARS', 'Outdoor and indoor lighting', '', '', '', 237, 0, 0, '2801 CAMINO DEL RIO SOUTH SAN DIEGO, CA 92108', '', '', '', '', '2018-06-13'),
(361, 1, 0, 1, 'Auroralight', 'AUI', 'Indoor/uotdoor lighting.', '', 'www.auroralight.com', '', 237, 2385, 0, '2742 Loker Avenue West Carlsbad, CA 92010', 'sales@auroralight.com', '', '(760) 931-2910', '(877) 942-1179', '2018-06-13'),
(362, 1, 0, 1, 'Lightheaded Lighting', 'LHT', 'Indoor/Lighting', '', 'http://lightheadedlighting.com/', '', 40, 285, 9662, '1150. 572 Nicola Place Port Coquitlam, BC Canada, V3B 0K4', 'info@lightheadedlighting.com', '', '604.464.5644', '1.800.464.9544', '2018-06-13'),
(363, 1, 0, 1, 'North America Lighting', 'NAL', 'Architectural, decorative and industrial lighting', '', '', '', 237, 0, 0, '11490 Robertson Dr. Manassas, VA 20109', '', '', '', '', '2018-06-13'),
(364, 1, 0, 1, 'Garden Light', 'GDL', 'Outdoor LED landscape lighting.', '', '', '', 237, 0, 0, 'Garden Light LED 6112 Benjamin Road Tampa, FL 33634', '', '', '', '', '2018-06-13'),
(365, 1, 0, 1, 'Lightnet', 'LNT', 'Indoor lighting.', '', 'www.lightnet-group.com', '', 237, 2390, 73243, 'Lightnet USA Inc. 123 NW 23rd Street Miami, FL 33127', 'info@lightnet.us', '', '+1 800 940 9092', '', '2018-06-13'),
(366, 1, 0, 1, 'N2M', 'N2M', 'Outdoor Lighting Solutions', '', 'https://n2mled.com/', '', 237, 0, 0, 'United States', '', '', '', '', '2018-06-13'),
(367, 1, 0, 1, 'Archilume', 'ARM', 'Indoor lighting', '', '', '', 40, 0, 0, '1027 Davie Street  Vancouver, British Columbia', '', '', '', '', '2018-06-13'),
(368, 1, 0, 1, 'Anolis', 'ANS', 'Indoor and outdoor lighting', '', '', '', 237, 0, 0, '12349 SW 53rd Street, Suite 202 Cooper City, Florida 33330', '', '', '', '', '2018-06-13'),
(369, 1, 0, 1, 'Xeleum', 'XLM', 'Indoor lighting', '', '', '', 237, 0, 0, '3430 Quantum Blvd Boynton Beach, FL 33426', '', '', '', '', '2018-06-14'),
(370, 1, 0, 1, 'Fidelux', 'FDL', 'Indoor/Outdoor lighting.', '', 'http://www.fidelux.com/', '', 237, 2387, 72795, '100 Great Meadow Road | Sixth Floor Hartford, CT 06109', 'sales@fidelux.com', 'Info@Fidelux.com', '1 203 774 5653', '', '2018-06-14'),
(371, 1, 0, 1, 'ALVA', 'ALV', 'Indoor & Outdoor Lighting', '', 'https://www.alvalight.com/', '', 237, 2385, 71571, '918 Parker Street Suite A14 Berkeley, CA, 94710 United State', 'info@alvalight.com', '', '(408)-394-3054', '', '2018-06-14'),
(372, 1, 0, 1, 'Tivoli', 'TVL', 'Indoor and outdoor lighting.', '', '', '', 237, 0, 0, 'Tivoli, LLC.  15602 Mosher Ave.  Tustin, CA 92780', '', '', '', '', '2018-06-14'),
(373, 1, 0, 1, 'Luce&Light', 'LLI', 'Indoor/Outdoor', '', 'https://www.lucelight.it/en/', '', 109, 0, 0, 'via della Tecnica 42  36031 Povolaro di Dueville  Vicenza, Italy', 'lucelight@lucelight.it', '', '+39 0444 360571', '', '2018-06-14'),
(374, 1, 0, 1, 'NAFCO', 'NFC', 'Indoor and outdoor lighting', '', 'https://nafcointernational.com/', '', 237, 0, 0, '206 West McWilliams Street Fond du Lac, WI 54935', '', '', '', '', '2018-06-14'),
(375, 1, 0, 1, 'CALI', 'CAL', 'Indoor Lighting', '', 'http://www.calilighting.com/', '', 237, 2385, 71526, '2034 E. Lincoln Ave. #431 Anaheim, CA 92806', '', '', '714-535-7900', '800-921-CALI (2254)', '2018-06-14'),
(376, 1, 0, 1, 'Orbit Illuminations', 'ORB', 'Indoor and outdoor lighting', '', 'http://www.orbit-illuminations.com/home.html', '', 40, 0, 0, '100 Birmingham Street, Suite 200 Toronto, ON, M8V 4E6', '', '', '', '', '2018-06-14'),
(378, 1, 0, 1, 'Manning Lighting', 'MNL', 'Interior and exterior lighting.', '', '', '', 237, 0, 0, '1810 North Ave, Sheboygan, WI 53083', '', '', '', '', '2018-06-15'),
(379, 1, 0, 1, 'PowerSecure Lighting', 'PSL', 'Indoor and outdoor lighting', '', 'http://www.powersecurelighting.com/', '', 237, 0, 0, '650 West Ave., Stamford, Connecticut 06902', '', '', '', '', '2018-06-15'),
(380, 1, 0, 1, 'Iluminarc', 'ILR', 'Indoor/outdoor lighting.', '', 'www.iluminarc.com', '', 237, 2390, 73375, 'Global Headquarters 5200 N.W. 108th Avenue Sunrise, FL 33351 USA', 'support@iluminarc.com', '', '(954) 577-4455', '(800) 762-1084', '2018-06-15'),
(381, 1, 0, 1, 'Neptun', 'NEP', 'Indoor/Outdoor Luminaires', '', 'http://www.neptunlight.com/', '', 237, 2394, 74658, '13950 W. Business Center Dr.  Lake Forest, IL 60045  USA', '', '', '847.735.8330', '888.735.8330', '2018-06-15'),
(382, 1, 0, 1, 'AV Poles and Lighting', 'AVL', 'Outdoor lighting.', '', '', '', 237, 0, 0, '43827 Division St. Lancaster, CA 93535', '', '', '', '', '2018-06-15'),
(383, 1, 0, 1, 'Kreon', 'KRE', 'Indoor/Outdoor Luminaires', '', 'https://www.kreon.com/en/north-america', '', 237, 2411, 81864, '20 Murray Hill Parkway NJ 07073 East Rutherford United States', '', '', '+1 (201) 298-44 48', '', '2018-06-15'),
(384, 1, 0, 1, 'The LED Company', 'TLD', 'Indoor and outdoor lighting', '', 'http://www.ledcohome.com/', '', 237, 0, 0, '160 McCormick Avenue Costa Mesa, CA 92626', '', '', '', '', '2018-06-15'),
(385, 1, 0, 1, 'National Lighting', 'NTL', 'Indoor lighting.', '', '', '', 237, 0, 0, '522 Cortlandt St. Belleville NJ 07109', '', '', '', '', '2018-06-15'),
(386, 1, 0, 1, 'Forma Lighting', 'FRL', 'Indoor/Outdoor Lighting', '', 'http://www.formalighting.com/', '', 109, 0, 0, 'Italy', '', '', '(+39) 02 9354 0300', '', '2018-06-18'),
(387, 1, 0, 1, 'Trilux', 'TLX', 'Indoor/Outdoor Lighting', '', 'https://www.trilux.com/en/', '', 237, 2391, 73870, '5126 S Royal Atlanta Dr.  Tucker, GA 30084', 'INFO.US@TRILUX.COM', '', '+1 770-274-2420', '', '2018-06-18'),
(388, 1, 0, 1, 'ES-SYSTEM', 'ESS', 'Indoor and outdoor lighting.', '', '', '', 173, 0, 0, 'ul. Przemyslowa 2 30-701 Krakow', '', '', '', '', '2018-06-18'),
(389, 1, 0, 1, 'Pure Edge Lighting', 'PEL', 'Indoor Luminaires', '', 'https://www.pureedgelighting.com', 'images/mnf-search-banners/mnf-search-banners-1/389-PureEdge_toplogo.jpg', 237, 2394, 74338, '1718 W. Fullerton Ave. | Chicago, Illinois 60614', 'info@PureEdgeLighting.com', '', '773.770.1195', '', '2018-07-06'),
(392, 1, 0, 4, 'Luminis', 'LMN', 'Interior and Exterior architectural luminaires', '', 'https://www.luminis.com/', 'images/mnf-search-banners/mnf-search-banners-1/392-Luminis_toplogo.jpg', 40, 294, 11321, '260 Labrosse, Pointe Claire QC H9R 5L5', 'info@luminis.com', '', '514 683-3883', '1 866-LUMINIS (586-4647)', '2018-10-04'),
(394, 1, 0, 1, 'LLI Achitectural Lighting', 'LAL', 'Solutions for a wide variety of commercial and high-end residential applications.', '', 'https://www.llialighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/394-LLI_Architectural_toplogo.jpg', 237, 2394, 74281, '1555 Barclay Blvd.  Buffalo Grove, IL 60089', 'cs@llialighting.com', '', '847-412-4880', '', '2018-10-04'),
(395, 1, 0, 1, 'LED Linear', 'LNR', 'Product families for interior and exterior lighting solutions.', '', 'https://www.ledlinearusa.com/', 'images/mnf-search-banners/mnf-search-banners-1/395-LED_Linear_toplogo.jpg', 237, 2413, 83009, '2186 Liberty Drive Niagara Falls, NY 14304, USA', '', '', '+1 716 283 4400', '', '2018-10-04'),
(396, 1, 0, 4, 'Cyclone', 'CYC', 'OUTDOOR AREA LIGHTING', '', 'http://www.cyclonelighting.com/', 'images/mnf-search-banners/mnf-search-banners-1/396-Cyclone_toplogo.jpg', 40, 294, 11638, 'Central Quebec 2175 Blvd. des Entreprises  Terrebonne, QC J6Y 1W9 Canada', 'fdesautels@cyclonelighting.com', '', '1-866-436-5500', '', '2018-10-05'),
(397, 1, 0, 1, 'JLC-Tech', 'JLC', 'T-BAR LED Luminaires', '', 'https://www.jlc-tech.com/', 'images/mnf-search-banners/mnf-search-banners-1/397-JLC_toplogo.jpg', 237, 2402, 78604, 'JLC TECH 370 Corporate Park, Pembroke, MA 02359', '', '', '', '', '2019-02-26'),
(404, 1, 0, 18, 'Stoane Lighting', 'MSL', 'Lighting products designed to be aesthetically simple without superfluous detail. They integrate seamlessly into any environment while delivering high-performance lighting.', '', 'https://www.inter-lux.com/brands-category/mike-stoane/', '', 237, 0, 0, '3741 Commerce Drive Suites 306-308 Baltimore, MD 21227', '', '', '', '', '2019-04-01'),
(407, 1, 0, 18, 'Sattler', 'SAT', 'An innovative portfolio of high-quality luminaires with various application options that make an impact due to their size and striking design.', '', 'https://www.inter-lux.com/brands-category/sattler/', '', 237, 2401, 77993, '3741 Commerce Drive Suites 306-308 Baltimore, MD 21227', '', '', '', '', '2019-04-01'),
(410, 1, 0, 18, 'Linea Light iLED', 'LNL', 'A wide range of high-performance LED luminaires and systems featuring functionality, style and design. Architectural and commercial applications include in-grade and recessed options.', '', 'https://www.inter-lux.com/brands-category/linea-light-iled/', '', 237, 2401, 77993, '3741 Commerce Drive Suites 306-308 Baltimore, MD 21227', '', '', '', '', '2019-04-01'),
(411, 1, 0, 1, 'StarTek Lighting America', 'STK', 'Indoor lighting.', '', 'https://starteklightingamerica.com/', '', 237, 2394, 75112, '1960 Swanson Ct, Gurnee, IL 60031, USA', '', '', '', '', '2019-10-03'),
(412, 1, 0, 1, 'Sun Valley Lighting', 'SVL', 'Architectural and Decorative Outdoor Lighting', '', 'http://usaltg.com/index.html', '', 237, 2385, 72119, 'Palmdale, CA 93551', '', '', '+1 800 877 6537', '', '2019-10-03'),
(414, 1, 0, 1, 'U.S. Architectural Lighting', 'ALG', 'Arhitectural End Decorateve Outdoor Lighting', '', 'http://usaltg.com/index.html', '', 237, 2385, 72119, 'Palmdale, CA 93551', '', '', '+1 800 877 6537', '+1 661 233 2001', '2019-10-03'),
(415, 1, 0, 1, 'H. E. Williams, Inc.', 'HEW', 'Indoor and Outdoor Architectural', '', 'https://www.hew.com/', 'images/mnf-search-banners/mnf-search-banners-1/415-HEWilliams_toplogo.jpg', 237, 2406, 80446, '831 W. Fairview Avenue Carthage, MO 64836', '', '', '', '', '2019-12-16'),
(418, 1, 0, 1, 'XAL Lighting', 'XAL', 'Luminaires and lighting systems for retail, office, hotel and residential spaces.', '', 'https://www.xalusa.com/', '', 237, 2413, 0, '133 West 19th Street 9th Floor New York, NY 10011', '', '', '', '', '2020-02-25'),
(420, 1, 0, 1, 'Tempo', 'TMP', 'Established in 1986, Tempo was founded on the premise that THEATRE safety illumination could be designed and produced to radically simplify the installation and maintenance process. Today, Tempo manufactures over 85% of cinema safety lighting in North America and provides total lighting solutions for theatre venues.', '', 'https://tempollc.com/', '', 237, 2385, 71883, '1961 McGaw Avenue Irvine, CA 92614', '', '', '', '', '2020-03-13'),
(421, 1, 0, 9, 'Alera Lighting', 'ALA', 'Alera Lighting features linear suspended and wall mounted products for commercial use. Applications for these products include office, retail, education, health care, corporate campus, air and rail transportation facilities, places of worship and youth centers.', '', 'https://www.hubbell.com/aleralighting/en/', '', 237, 0, 0, '701 Millennium Blvd Greenville', '', '', '', '', '2020-03-23'),
(424, 1, 0, 9, 'Compass', 'COM', 'Designed to reduce cost without sacrificing quality, Compass® Products by Hubbell Lighting, Inc. provide a value-driven, contractor-friendly product offering that can be purchased and installed without compromise.', '', 'https://www.hubbell.com/compassproducts/en/about', '', 237, 0, 0, '701 Millennium Blvd Greenville', '', '', '', '', '2020-03-24'),
(425, 1, 0, 9, 'Killark', 'KIL', 'Established in 1913, Killark has become a global provider of harsh and hazardous location products. The Killark range encompasses industrial and explosion proof fittings engineered to withstand the toughest extremes in climate from the dry and arid Middle East, tropical Asia to frozen Northern Canada.', '', 'https://www.hubbell.com/killark/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-25'),
(426, 1, 0, 9, 'Healthcare Solutions', 'HLS', 'Hubbell Incorporated, with a history dating back to 1888, began a series of acquisitions of prominent lighting businesses in 1963 that ultimately constituted Hubbell Lighting, Inc. In 2002, Hubbell acquired Lighting Corporation of America in one of the largest acquisitions in the history of the lighting industry, transforming Hubbell Lighting into one of the largest lighting manufacturers in North America. As a core business platform of Hubbell Incorporated, Hubbell Lighting draws great inspiration from the company\'s long history of proven performance since 1888 and its culture of new product innovation.', '', 'https://www.hubbell.com/hubbellhealthcaresolutions/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-25'),
(427, 1, 0, 9, 'Kurt Versen', 'KTV', 'For almost a century, Kurt Versen Company has been on the forefront combining art and science in the lighting industry. Our founder established a practice of designing high quality aesthetically pleasing lighting products, a standard we follow today. His invention of the legendary gooseneck lamp, which has evolved into one of the most prominent designs in lighting, resides in the Smithsonian Museum. Kurt’s innovative spirit continues to be seen in each of our products today and has been the foundation on which we built our company identity. Our philosophy is to design products to complement, rather than compete with, a broad range of architectural designs.', '', 'https://www.hubbell.com/kurtversen/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-25'),
(428, 1, 0, 9, 'Prescolite', 'PES', 'Since its founding in 1944, Prescolite has been a prominent force in the lighting industry. Our focus is on downlighting, track and surface products. Such notable industry advances as the first compact fluorescent downlight in the US, the first indoor HID downlight, the first compact fluorescent multi-voltage, multi-wattage, intelligent, electronic ballasts and our patented Virtual Source optics are all industry firsts pioneered by Prescolite. This leadership continues today with Prescolite at the forefront of recessed, surface and track lighting solutions for commercial and residential applications.', '', 'https://www.hubbell.com/prescolite/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-25'),
(429, 1, 0, 9, 'Hubbell Industrial Lighting', 'HLL', 'From its inception in 1963, Hubbell Lighting established its position in the lighting industry by producing outdoor lighting of the highest quality. Through an in-depth knowledge of the electrical distributor and contractor markets, Hubbell Lighting has been consistently able to combine innovative technology with practical lighting brand solutions and service oriented performance. Product innovations such as Perimaliter® wallpacks, Miniliter® and Microliter® floodlighting fixtures, and energy saving NRG® fixtures have led the way in creating value oriented, energy saving, environmentally friendly luminaires. The new Laramie® floodlight and Laredo wallpack families continue this tradition. Hubbell\'s design engineers use this pallet of luminaires to create lighting solutions for most any application challenges presented.', '', 'https://www.hubbell.com/hubbelloutdoorlighting/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-26'),
(430, 1, 0, 9, 'Progress Lighting', 'PRS', 'Progress Lighting is committed to manufacturing award-winning energy efficient products while educating individuals on new options available in solid-state lighting. With over a century of lighting technology, leadership and engineering, Progress Lighting offers the highest quality in residential and commercial lighting solutions bringing products that deliver aesthetic appeal, stellar performance, easy installation and value to the designer marketplace.', '', 'https://www.hubbell.com/progresslighting/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-26'),
(431, 1, 0, 9, 'Security Lighting', 'SCL', 'For over 30 years Security Lighting has been the industry leader in developing unique lighting solutions for national accounts in the restaurant, petroleum/c-stores, hospitality, self-storage and retail industries. As a manufacturer and a member of Hubbell Lighting, it offers a comprehensive selection of LED lighting products for all applications including site, exterior wall/building, landscaping, signage, interiors, décor and emergency/exit luminaries.', '', 'https://www.hubbell.com/securitylighting/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-27'),
(432, 1, 0, 9, 'Whiteway', 'WHY', 'Whiteway Lighting, a subsidiary of Hubbell Lighting is located in Rolling Meadows, IL focuses primarily in the Convenience Store and Petroleum markets.  Whiteway provides an all inclusive package addressing the market’s need for performance, aesthetics, and value, all with uncompromised quality. LED solutions backed by Hubbell Lighting\'s solid state lighting group feature best-in-class technology, dramatically reduced energy consumption, and a low total cost of ownership.', '', 'https://www.hubbell.com/whiteway/en', '', 237, 2421, 87181, '701 Millennium Blvd', '', '', '', '', '2020-03-27'),
(433, 1, 0, 1, 'Edison Lighting Group', 'ELG', 'Indoor Architectural Lighting', '', 'https://www.edisonlighting.ca/index.php', 'images/mnf-search-banners/mnf-search-banners-1/433-Edison_Group_toplogo.jpg', 40, 292, 10721, '1303 Ringwell Dr', '', '', '', '', '2020-04-15'),
(434, 1, 0, 1, 'test125', 'TST', 'TESTR', '', '', '', 237, 2394, 0, '800 weidner rd,', 'TEST@comcast.net', '', '8885556789', '', '2020-04-15'),
(437, 1, 0, 1, 'XXX', 'XXX', 'TEST', '', '', '', 237, 0, 0, '4444', '', '', '', '', '2020-04-17');

-- --------------------------------------------------------

--
-- Table structure for table `manufacturers_data`
--

CREATE TABLE `manufacturers_data` (
  `manf_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `note` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manufacturers_data`
--

INSERT INTO `manufacturers_data` (`manf_id`, `user_id`, `note`) VALUES
(10, 143, 'TRG@537551AST'),
(18, 76, 'AXS@678432ZSD'),
(19, 117, 'USA@198451STP'),
(21, 103, 'FOP@918674ELG'),
(23, 78, 'LWX@145693BSD'),
(26, 113, 'ALW@165348LTH'),
(27, 111, 'BWD@913782SK'),
(29, 134, 'DLT@893201GMS'),
(40, 75, 'EDG@512397BNS'),
(41, 122, 'EDP@654118BBS'),
(43, 112, 'INL@231654MX'),
(52, 141, 'ABC@123456XYZ'),
(53, 109, 'KNL@596284SDL'),
(56, 73, 'AMR@564561FBT'),
(57, 116, 'BRT@152648FRS'),
(61, 135, 'PRU@645642DNL'),
(76, 84, 'VIS@417053SJQ'),
(77, 133, 'test123'),
(79, 81, 'PUR@745098FAV'),
(80, 115, 'BKL@135644RYL'),
(82, 125, 'LMI@846595FBY'),
(89, 102, 'VBA@654837ULZ'),
(90, 114, 'AXL@1564861SNB'),
(91, 77, 'BJK@745645GFE'),
(95, 74, 'ACL@651378FNX'),
(98, 136, 'LML@4698531OFM'),
(99, 137, 'CML@354979GMS'),
(102, 80, 'ZMB@623489HJQ'),
(105, 82, 'WLD@426731SXT'),
(106, 83, 'LLI@510794HJI'),
(108, 87, 'FRM@034968LJW'),
(110, 101, 'ARA@093781NAS'),
(112, 118, '3GL@531646HLO'),
(113, 119, 'INS@896454KTH'),
(114, 120, 'LNR@135641ALF'),
(115, 124, 'LNS@234078FFX'),
(116, 126, 'ALI@456321ONF'),
(117, 127, 'CYL@876478HEP'),
(118, 128, 'EUR@639528NFK'),
(119, 129, 'JLC@253870PSG'),
(120, 130, 'FCL@433216CKT'),
(121, 131, 'SSL@788045GTS'),
(122, 132, 'OCL@689117FTF'),
(123, 138, 'NSL@197483DNL'),
(124, 139, 'LMD@124512EGS'),
(126, 142, 'ACD@824619HTH'),
(212, 290, 'zne_test');

-- --------------------------------------------------------

--
-- Table structure for table `manufacturer_reps`
--

CREATE TABLE `manufacturer_reps` (
  `manfrep_id` smallint(5) UNSIGNED NOT NULL,
  `manf_id` int(10) UNSIGNED NOT NULL,
  `rep_id` smallint(5) UNSIGNED NOT NULL,
  `country_id` smallint(5) UNSIGNED NOT NULL,
  `region_id` smallint(5) UNSIGNED NOT NULL,
  `city_id` mediumint(8) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manufacturer_reps`
--

INSERT INTO `manufacturer_reps` (`manfrep_id`, `manf_id`, `rep_id`, `country_id`, `region_id`, `city_id`) VALUES
(81, 1, 11, 237, 2385, 72236),
(80, 2, 11, 237, 2385, 72236),
(85, 5, 9, 237, 2394, 74338),
(91, 12, 9, 237, 2394, 74338),
(92, 14, 9, 237, 2394, 74338),
(79, 17, 11, 237, 2385, 72236),
(88, 18, 9, 237, 2394, 74338),
(64, 19, 9, 237, 2394, 74338),
(84, 20, 9, 237, 2394, 74338),
(61, 21, 10, 237, 2394, 74338),
(62, 22, 10, 237, 2394, 74338),
(89, 25, 9, 237, 2394, 74338),
(67, 27, 10, 237, 2394, 74338),
(83, 27, 11, 237, 2385, 72236),
(68, 29, 10, 237, 2394, 74338),
(95, 30, 10, 237, 2394, 74338),
(78, 33, 11, 237, 2385, 72236),
(90, 35, 9, 237, 2394, 74338),
(82, 36, 11, 237, 2385, 72236),
(86, 39, 9, 237, 2394, 74338),
(93, 43, 10, 237, 2394, 74338),
(94, 48, 10, 237, 2394, 74338);

-- --------------------------------------------------------

--
-- Table structure for table `media_partners`
--

CREATE TABLE `media_partners` (
  `media_id` int(11) NOT NULL,
  `sku` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(4) NOT NULL,
  `media_partner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo_large` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `dt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_partners`
--

INSERT INTO `media_partners` (`media_id`, `sku`, `active`, `media_partner`, `logo`, `logo_large`, `title`, `subtitle`, `description`, `url`, `tag_title`, `tag_description`, `dt`) VALUES
(6, 'LEDCHI', 0, 'LED CHINA', 'LED_CHINA_2016_LOGO.gif', 'LED_CHINA_2016.gif', 'LED CHINA', 'LED China 2016', 'LED CHINA  is the world\'s largest event dedicated to the entire LED industry supply chain and an one-stop platform to see finished LED products and components from LED lighting, displays, chips, packaging, materials, illuminates, manufacturing equipment, and testing instruments.\r\nAfter winning endorsement from the China Ministry of Commerce in 2012 and more than a decade of successful editions, LED CHINA is now widely recognized as one of the world’s most comprehensive platform to observe product trends, as well as new technologies and ideas in the LED industry from across the world and in particular Asia.\r\nHeld in conjunction with SIGN CHINA 2016 and DIGITAL SIGNAGE 2016, LED CHINA 2016 will showcase the latest in sign production technologies and LED lighting products and innovations all in one venue!', 'http://www.ledlightingchina-sh.com/zh-CN#_ga=1.230545816.547644608.1445186240', 'LED China 2016', 'LED China 2016', '2015-10-18 12:42:55'),
(7, 'FORUM', 0, 'FORUM LED EUROPE', 'ForumLEDEurope2015.jpg', '', 'FORUM LED EUROPE', '08 & 09 December 2016. Congress Center of Lyon', 'ForumLED : An encounter of supply with demand for LED lighting products\r\nand components \r\n120 exhibitors, 3 000 visitors et 250 congress participants.\r\n\r\nA global event for LED lignthing\r\nA unique platform for information, discussions, networking and new business.\r\n\r\nForumLED in 2016 :\r\n- An international congress at the highest level in the world with the top\r\nworld\r\n- 120 exhibitors covering the entire value chain of LED lighting : from the\r\ncomponent to the complete lighting\r\n- A platform devoted to innovation bringing together laboratories,\r\nUniversities and Grandes Ecoles\r\n- A start-up area and an Investor Forum to stimulate growth in the sector\r\n\r\nForumLED Europe is designed for developing companies and successful LED\r\nlighting projects.\r\n\r\n\r\n\r\nCDO Events\r\nLaurent GITENET\r\nPhone : + 33 (0)4 37 40 31 65 - Fax : +33 (0)4 37 40 31 69\r\nEmail : info@forumled.com - Site web : www.forumled.com\r\n152 Grande rue de Saint Clair, Immeuble Le portant\r\n69300 Caluire et Cuire - France', 'http://www.ldlmlocal.com/media_partners.php', 'ForumLED Europe 2016', 'Over the last 6 years, ForumLED Europe has become the most important event dedicated to LED technology ecosystem lighting in Europe. ForumLED Europe is both an international congress', '2015-10-21 23:06:54'),
(8, 'ILUMT', 0, 'ILLUMINOTRONICA', 'logo_illuminotronica_ledelum.jpg', '', 'ILLUMINOTRONICA', 'PADUA 6-8 October 2016', 'The unique professional event in Italy devoted to \"visible\" technologies and its applications\r\nThe reference point for all lighting professionals, smart home and electronics specialists .\r\n\r\nA highly specialized public , composed of decision makers, buyers, energy managers, plant designers, installers, system integrators, architects, lighting designers, technical offices of municipalities, and lighting designers.\r\n\r\nA unique occasion in Italy to be updated, develop business, meet lighting experts, know home automation technologies, focusing on solutions and products for the wellbeing and security of people.', 'http://illuminotronica.it/?utm_source=Ledelum&utm_medium=banner&utm_term=Illuminotronica&utm_campaign=Illuminotronica2016', 'ILLUMINOTRONICA', 'ILLUMINOTRONICA 2016', '2015-12-28 22:57:57'),
(9, 'LPS', 0, 'LUGER RESEARCH', 'LpS2016.jpg', '', 'LpS 2016', '6th International LED professional Symposium +Expo', 'Luger Research is the organizer of the LED professional Symposium +Expo (LpS). The LpS is an annual event and meeting point for experts from international lighting industries and research, which takes place at the Festspielhaus in Bregenz, Austria. With about 60 lectures, several workshops, 1,500 expected visitors and around 100 exhibitors, this event is one of the world’s leading lighting technology conferences. The sixth LpS will cover trends and technologies for future lighting solutions under the motto: Smart Technologies for Lighting Innovations from September 20th to 22nd, 2016.', 'http://www.LpS2016.com', 'Luger Research', '6th International LED professional Symposium +Expo', '2016-03-30 22:55:00'),
(11, 'ACM', 0, 'Advanced Conferences & Meetings', '160628-LTE-Ledelum_500x250_banner.jpg', 'ACM.jpg', 'LightingTech Egypt', '26-27 Septemner 2016. Dusit Thani Lakeview Cairo, Egypt', 'Advanced Conferences & Meetings FZ-LLC is a premium business-to-business events company focusing on the dynamic and ever changing requirements of the MENA region. Our events are highly efficient networking and learning opportunities, bringing senior decision makers together and providing upto-\r\nthe-minute information on industry trends, government initiatives, technological advances and developments in regulation. As such, they act not only as extremely effective tools for gaining competitive advantage, but also as high level platforms for change in the industries they serve.\r\n\r\nWith our headquarters in Dubai, UAE and with regional representation in Qatar, Saudi Arabia, Lebanon, Egypt, and Iraq, Advanced Conferences & Meetings operates across the MENA region, combining our local knowledge and contacts with the latest international standards.\r\n\r\nWhether you are looking to enter a new sector, source partnerships, connect with leading solution and service providers or gain knowledge of market trends, legislations and the latest technical developments, Advanced Conferences & Meetings give you access to expert decision makers and thought leaders alongside the means to network effectively amongst key business prospects.', 'http://www.lightingtechegypt.com', 'LightingTech Egypt conference', 'LightingTech Egypt conference', '2016-07-03 12:45:22');

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `pf_id` int(11) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `lead_time` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`pf_id`, `project_id`, `lead_time`, `price`, `user`) VALUES
(278, 48, '', '', 0),
(294, 0, '18', '100', 0),
(295, 1, '19', '24', 0),
(298, 1, '', '', 0),
(301, 50, '', '', 0),
(310, 11, '788', '25', 0),
(311, 45, '', '500', 0),
(312, 11, '15', '79', 0),
(314, 45, '200', '1000', 0),
(316, 45, '', '', 0),
(319, 45, '', '', 0),
(325, 45, '2 weeks', '500', 0),
(1356, 23, '', 'k', 0),
(1960, 260, '', '', 0),
(1978, 260, '', '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `news_id` int(10) UNSIGNED NOT NULL,
  `sku` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `advertiser` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku_media` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img_pos` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `disp_order` smallint(5) UNSIGNED NOT NULL,
  `dt` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`news_id`, `sku`, `active`, `location`, `advertiser`, `sku_media`, `title`, `subtitle`, `description`, `url`, `img`, `alt`, `img_pos`, `tag_title`, `tag_description`, `disp_order`, `dt`) VALUES
(4, 'n1', 1, 'Lyon', 'LUCI', NULL, 'Seminar on urban lighting brings together Lyon and Montreal', 'Lyon and the Centre Jacques Cartier. 2 December 2015', 'A seminar on urban lighting was organised by the INSA Lyon and the Centre Jacques Cartier on 2 December 2015 in Lyon.\r\n\r\nIt took place within the framework of the Entretiens Jacques Cartier, a series of seminars, conferences and events by the Centre Jacque Cartier, an organisation that promotes cooperation between France and Canada.\r\nThe seminar brought together some of the key actors in public lighting in France such as AFE (French Lighting Association), ACE (Association of French lighting designers), Cluster Lumière and LUCI, as well as the City of Lyon, to discuss urban lighting with representatives from the City of Montreal and IESNA (Illuminating Engineering Society of North America).', 'http://www.luciassociation.org/seminar-on-urban-lighting-brings-together-lyon-and-montreal/', '', '', 'top', 'urban lighting', 'A seminar on urban lighting was organised by the INSA Lyon and the Centre Jacques Cartier on 2 December 2015 in Lyon.', 9, '2015-10-21 00:10:00'),
(5, 'N2', 1, 'Glasgow', 'LUCI', NULL, 'The Economic and Cultural Benefits of Light Festivals', 'LUCI Culture Commission', 'This report is the result of a study realized by the LUCI Culture Commission chaired by the City of Glasgow, in collaboration with Cambridge Policy Consultants. Through contacts with 26 cities hosting more than 30 light events and detailed case studies from 10 cities (Chartres, Durham, Eindhoven, Glasgow, Gothenburg, Jerusalem, Lyon, Medellin, Montreal and Osaka), the report includes a wealth of information on how cities measure and demonstrate the success of their events', 'http://www.luciassociation.org/toolsressources/', '', '', 'top', 'The Economic and Cultural Benefits of Light Festivals', 'This report is the result of a study realized by the LUCI Culture Commission chaired by the City of Glasgow, in collaboration with Cambridge Policy Consultants.', 0, '2015-12-10 23:51:22'),
(6, 'N3', 1, 'Publication', 'LUCI', NULL, 'The Social Dimensions of Light', 'Publication', 'The publication aims to define the concept of social lighting and draws attention to concrete experiences and exemplary practices in this domain with case studies from 12 cities world-wide such as Medellin, Bangkok, Rotterdam, Copenhagen, Gwangju, Brussels, and Le Havre, among others.\r\n\r\nIt is a product of the LUCI Urban Strategies Commission chaired by the City of Liege which had initiated a reflection on the social dimensions of light in collaboration with the University of Liege (LEMA).', 'http://www.luciassociation.org/toolsressources/', 'N3_SocialDimensionsLight.jpg', '', 'right', 'The Social Dimensions of Light', 'The publication aims to define the concept of social lighting and draws attention to concrete experiences and exemplary practices in this domain with case studies from 12 cities world-wide such as Medellin, Bangkok, Rotterdam, Copenhagen, Gwangju, Brussels, and Le Havre, among others.', 0, '2015-12-10 23:55:39'),
(7, 'N4', 1, 'Publication', 'LUCI', NULL, 'Cities & Lighting', 'Publication', 'LUCI’s bi-annual magazine showcases urban lighting projects worldwide and addresses the key issues in the domain.\r\n\r\nThe second edition features a focus on heritage lighting, an interview with the Chairman of the International Year of Light 2015 Steering Committee, as well as articles on various lighting initiatives from around the world.', 'http://www.luciassociation.org/toolsressources/', 'N4-LUCI-Cities_Lighting.jpg', '', 'right', 'Cities & Lighting', 'LUCI’s bi-annual magazine showcases urban lighting projects worldwide and addresses the key issues in the domain.', 3, '2015-12-11 00:01:18'),
(8, 'N5', 1, 'Gothenburg', 'LUCI', NULL, 'City under Microscope -Gothenburg', '20-23 April 2016, Sweden', 'Gothenburg city is approaching its 400th year\r\nanniversary in 2021. While many preparations are being made for this celebration, Gothenburg is already set for one of its greatest leaps forward in modern times. With a focus on building a close-knit and sustainable city.\r\n\r\nGothenburg is set to grow by\r\nalmost a third of its population in the next 20 years!\r\n\r\nThis creates a great opportunity to develop the city’s public spaces.\r\nA denser city will make our work with urban lighting all the more important, both for the everyday city life and for dining the city\r\nitself – its past and future.\r\nWe are very pleased and proud to host a LUCI City under Microscope in Gothenburg. This event is an expression of one of LUCI’s core purposes – to bring cities and people together to exchange experiences and ideas.\r\n\r\nWe are glad to invite our partner and neighbor city, Alingsås, one of the latest members of LUCI, to take part in the programme.', 'http://www.luciassociation.org/wp-content/uploads/2015/11/Teaser-Gothenburg.pdf', 'N5_City_Microscope_Gothenburg.jpg', '', 'top', 'City under Microscope -Gothenburg', 'Gothenburg city is approaching its 400th year\r\nanniversary in 2021. While many preparations are being made for this celebration,', 2, '2015-12-11 00:11:19'),
(9, 'N6', 1, 'usa', 'SORAA', NULL, 'Soraa\\\'s LED Lighting Perfectly Illuminates The Innovative Andrei Duman Gallery', 'Fremont, CA| December 07, 2015', 'Soraa, the world leader in GaN on GaN™ LED technology, announced that its LED lamps have been installed at the new Andrei Duman Gallery in the high end mall—Westfield Topanga outside Los Angeles. Soraa LED lights redefines gallery design by illuminating differentiated space with no clear boundaries and also perfectly illuminates the award-winning images from the accomplished aerial, travel and nature photographer. \r\n\r\nFor Duman, lighting his work in the gallery, which opened in Fall 2015, was an important consideration—colors had to be rendered exactly. Light is a critical element in capturing images—and it’s critical to the accurate display of color in art photography. In addition, the innovative design of the gallery required lighting that could be carefully controlled to accentuate the space and also be used to illuminate precise points on the artwork. Duman and his lighting designer insisted upon Soraa LEDs to illuminate his intimate 1,500 sq. ft. gallery and the “display trees,” from which 12 double-sided images in glass frames hang and appear to float in the air.', 'http://www.soraa.com/news/soraa-December-07-2015', '', '', 'top', 'Soraa’s LED Lighting Perfectly Illuminates', 'Soraa, the world leader in GaN on GaN™ LED technology, announced that its LED lamps have been installed at the new Andrei Duman Gallery in the high end mall—Westfield Topanga outside Los Angeles.', 10, '2015-12-11 00:40:12'),
(10, 'N7', 1, 'USA', 'Targetti', NULL, 'Antonio Cuccoli named Targetti VP of sales in North America', 'October 16, 2015 - Targetti USA', 'October 16, 2015 - Targetti USA, the new North American operations for the Targetti Group, has appointed Antonio Cuccoli as vice-president of sales for North America. \r\n \r\n \r\n“Antonio has spent the last eight years serving in a sales management capacity for Targetti so he is  familiar with our products”, said Marie Paris, U.S. business development manager with the company. “His new role will help our new independent sales organization maximize and expand our U.S. presence”.\r\n \r\nCuccoli most recently served as a lighting-sales representative in the north-east region for Targetti Poulsen USA, the company said. He will be based in New Jersey.', 'http://www.targetti.us/', '', '', 'top', 'Targetti USA', 'Targetti USA, the new North American operations for the Targetti Group, has appointed Antonio Cuccoli as vice-president of sales for North America.', 11, '2015-12-11 00:48:47'),
(11, 'N8', 1, 'Milan', 'Artemide', NULL, 'Artemide illuminates the Michelangelo’s Pietà Rondanini', 'Milan, April 10, 2015', 'The Rondanini Pietà on display from May at its new venue in the former Spanish Hospital at the Sforza Castle in Milan\r\n Milan, April 10, 2015 – Michelangelo’s masterpiece returns on display with a new set-up designed by Architect Michele De Lucchi and a lighting project especially conceived and implemented by Artemide.\r\n The lighting project designed for the Pietà is sober and minimal, with no interference with the visual enjoyment of the place. Glaring is perfectly controlled, so that visitors can admire the work undisturbed. The lighting bodies used in the project are non-invasive, concealed, and arranged solely along the hall’s perimeter.\r\n Artemide has illuminated the large exhibiting venue with next-generation LED projectors that produce uniform, pleasant, and well-balanced light, ideal to accommodate both the work and visitors.\r\n Direct lighting of the sculpture is obtained with especially-designed LED shapers enhancing the work’s harmony. The delicate light and dark contrast produced by the light of Artemide allows good perception of forms and enhances the substance of white marble without interfering with the subject’s natural expressivity.\r\n The light of Artemide is arranged in order to ensure perfect lighting consistency between the rear and front of the sculpture, which is shown backward to the public. The perfect balance between ambient lighting and work lighting is allowed by smart and perfectly controlled operation of all lighting bodies.\r\n The undisputed skill of Artemide has resulted into the creation of a “silent,” unobtrusive light enhancing the expressive and dramatic intensity of Michelangelo’s Pietà without causing discomfort.', 'http://www.artemide.it/blog/en/portfolio/artemide-illumina-la-pieta-rondanini/', 'N8_Artemide_Pieta_Rondanini.jpg', '', 'right', 'Artemide illuminates the Michelangelo’s Pietà Rondanini', 'The Rondanini Pietà on display from May at its new venue in the former Spanish Hospital at the Sforza Castle in Milan', 5, '2015-12-11 00:56:20'),
(12, '00006', 1, 'Samsung', 'Samsung', NULL, 'Samsung Introduces Smart Lighting Module to Simplify and Improve Connectivity in IoT Lighting Applications', 'Smart Lighting Module (SLM)', 'Samsung Electronics introduced a multi-purpose Smart Lighting Module (SLM) – the most fundamental IoT building block – for the fast-growing, smart building and smart city markets. By providing the core building block for a wide variety of potential smart lighting systems, Samsung’s SLM will play a key role in speeding up system development, lowering risk, improving system quality and reducing time to market for smart lighting manufacturers. The module will be sampled with Samsung smart lighting partners and will be shipped to OEMs in April.', 'http://www.led-professional.com/products/led-driver-ics-modules/samsung-introduces-smart-lighting-module-to-simplify-and-improve-connectivity-in-iot-lighting-applications', 'Samsung_SLM.jpg', '', 'top', 'Samsung Introduces Smart Lighting Module', 'Samsung Introduces Smart Lighting Module', 8, '2016-04-10 00:38:11'),
(13, '00007', 1, 'Tridonic’s innovative', 'Tridonic’s innovative', NULL, 'The “Internet of Light” – the Key to the “Internet of Things”', 'Tridonic’s innovative', 'The Internet of Things is the next industrial revolution. As a specialist for innovative lighting components and systems, Tridonic is convinced that lighting will play a decisive role in the Internet of Things (IoT). Therefore, Tridonic developed the toolbox net4more which will not only connect luminaires with each other, but deliver a value add that goes far beyond lighting. Where do we stand today?\r\n\r\nSometime in 2016 the number of connected devices will overtake the number of people on the planet for the first time. According to calculations by Gartner, the US market research company, last year around five billion devices were able to communicate via the Internet – whether smartphones or tablets, smart electricity meters, cars or factory machines. In 2016 the figure is expected to rise to between seven and eight billion. That\'s more than the 7.4 billion people currently living in the world. Analysts are already talking about 24 to 35 billion connected devices by 2020. This Internet of Things is expanding at the rapid pace of more than 40 percent per year. Market researchers from BI Intelligence expect total expenditure on hardware, application development and system integration to reach 6,000 billion dollars in the next five years.\r\n\r\nThe Internet of Things is booming because of the large number of applications and the added value for users. Smartphones can be used to shop online, check in for a flight or find your way round an unfamiliar city. Electricity meters automatically send energy consumption data; traffic lights, washing machines, cars and trains all give early warnings that they need servicing, and pc boards in factories tell assembly robots which components they should pick.', 'http://www.led-professional.com/technology/electronics/the-201cinternet-of-light201d-2013-the-key-to-the-201cinternet-of-things201d', 'net4more.jpg', 'Tridonic’s innovative', 'top', 'Tridonic’s innovative', 'The “Internet of Light” – the Key to the “Internet of Things”', 10, '2016-04-10 00:44:03'),
(14, '00008', 1, 'Nichia Corporation', 'Nichia Corporation', NULL, 'Nichia Corporation and Future Lighting Solutions Announce Partnership', 'March 14, 2016', 'Nichia Corporation, the pioneer and the leader in LED technology and Future Lighting Solutions (FLS), the world-class leader and innovator in demand creation, marketing and distribution of solid-state lighting technologies, today announce a new distribution agreement covering the Americas and Europe*.\r\n“Nichia has long been the leader in the LED industry, and now we are partnered with the leading global solid-state lighting solutions provider. Collaborating with FLS is a major step for Nichia in the general lighting market. Nichia will continue to develop world leading LED products and can now market these to an even wider network of lighting providers, through FLS.” said Shinichi (Steve) Yuasa, CEO, Nichia Americas & Europe.\r\n\r\n“Future Lighting Solutions is delighted to add Nichia to our line card with their broad product portfolio.  We look forward to a long-term, successful partnership with Nichia, and are thrilled to now be positioned better than ever to offer our customers a broadened portfolio of solid-state lighting solutions” said Jamie Singerman, Corporate Vice-President, Future Lighting Solutions.\r\n\r\nFor more information about Nichia please visit www.nichia.com and for availability through Future Lighting Solutions, please visit www.FutureLightingSolutions.com', 'http://www.futurelightingsolutions.com/en/information-center/press-releases/Documents/PRFLS_Nichia_en.pdf', '', '', 'top', 'Nichia Corporation', 'Nichia Corporation, the pioneer and the leader in LED technology and Future Lighting Solutions', 6, '2016-04-10 00:49:19'),
(15, '00009', 1, 'Osram', 'Osram', NULL, 'Osram Names Lamps Business Branch LEDVANCE', 'Osram Press Release.', 'Osram, one of the world\'s leading lighting manufacturers, continues to make progress with the carve-out of its general lighting lamps business. After the supervisory board of Osram Licht AG approved the carve-out of the unit in June 2015, the name of the new company has now also been decided. “We have opted for a combination of the terms ‘LED’ and ‘advance’ and will call the newly established company LEDVANCE,” said Olaf Berlien, Chief Executive Officer of Osram Licht AG. “The name reflects the trend toward LED in the lighting market as well as the opportunities arising from this development – opportunities LEDVANCE will actively exploit.”\r\n\r\nThe product portfolio of LEDVANCE covers traditional lighting, modern LED lamps and standardized over-the-counter (OTC) luminaires, as well as connected and intelligent lighting solutions for smart homes and smart buildings. LEDVANCE will be led by Jes Munk Hansen (47), a Dane who has already been at the helm of the lamps business for one year after previously heading Osram’s important Americas business. Oliver Neubrand (45) will be responsible for finance, Erol Kirilmaz (43) for sales and marketing, Peter Mannhart (56) for operations, and Bettina Kahr-Geleng (45) for human resources. “Together with this internationally experienced and highly motivated management team, I’m looking forward to leading LEDVANCE jointly with our more than 10,000 proficient and committed employees into a future of sustained success,” said Hansen. “I see good growth opportunities especially in the area of standardized OTC luminaires.”', 'http://www.osram.com/osram_com/', '', '', 'top', 'Osram Names Lamps Business Branch LEDVANCE', 'Osram, one of the world\'s leading lighting manufacturers,', 7, '2016-04-10 00:54:33'),
(16, '00010', 1, 'PISCATAWAY, N.J.', 'PISCATAWAY, N.J.', NULL, 'The Connected Lighting Alliance Endorses ZigBee 3.0 for Residential Lighting', 'PISCATAWAY, N.J. (March 11 2016)', 'The Connected Lighting Alliance [TCLA] announced today the endorsement of ZigBee 3.0, as the preferred open standard for residential connected lighting applications, simplifying choices for both lighting companies and consumers.\r\n\r\nWith ZigBee Light Link, previously endorsed by TCLA, being merged in to the new ZigBee 3.0 standard, the TCLA member companies studied and evaluated the new proposition. The conclusion was that ZigBee 3.0 exceeds the benefits of ZigBee Light Link and that therefore the new ZigBee 3.0 better meets the requirements of the lighting industry in the residential market.\r\n\r\n‘ZigBee 3.0 simplifies the choice for the lighting industry and consumers, because it enhances interoperability between connected lamps and controls from different suppliers, providing a single solution for smart lighting in the home.’ said Frank van Tuijl, Secretary General of The Connected Lighting Alliance.\r\n\r\n“The ZigBee Alliance and The Connected Lighting Alliance have worked closely for many years to bring product interoperability to the residential connected lighting marketplace,” said Tobin Richardson, President and CEO of the ZigBee Alliance. “We are very excited to now be taking the next step together in support of ZigBee 3.0, our latest interoperable ecosystem which brings together all previous standalone ecosystems into a single solution. ZigBee 3.0 delivers the confidence that consumers gain from standardizing at all layers of the network.”\r\n\r\nThe ZigBee 3.0 standard, now endorsed by The Connected Lighting Alliance, will encourage the development of robust, interoperable wireless lighting systems. TCLA will continue with its work to further enhance and promote the interoperability of lighting solutions.\r\n\r\nThe Connected Lighting Alliance is the primary advocate of wireless connectivity in lighting applications. We are comprised of 37 members, which include the leading lighting companies worldwide. Our mission is to promote the global adoption and growth of wireless lighting solutions by supporting open standards.', 'http://www.zigbee.org/zigbee-for-developers/zigbee3-0/', 'ZigBee-3.png', '', 'top', 'he Connected Lighting Alliance Endorses ZigBee 3.0 for Residential Lighting', 'he Connected Lighting Alliance Endorses ZigBee 3.0 for Residential Lighting', 8, '2016-04-10 00:59:09'),
(17, '00011', 1, 'Guangzhou Hongli Opto', 'Electronic Co., Ltd', NULL, '50000 sq ft LED Museum Opens in October 2016', 'Electronic Co., Ltd', 'Responding to the call of national policy, Guangzhou Hongli Opto – Electronic Co., Ltd. has been committing to delivering innovation in LED (Light Emitting Diode) research and development in the past years, which has injected new blood and cultural element for the industry.\r\n\r\nIn order to visually present LED industry’s booming development and publicize the policy of energy saving, Nanchang Hongli Opto – Electronic Co., Ltd., one of the wholly – owned subsidiaries of Guangzhou Honglitronic, is now planning to build Nanchang LED Museum. The museum will present LED industry’s great contribution to the national industry and electronic industry through material objects, pictures, videos, and other forms.\r\n\r\nIn total, the building area covers about 5,000 ㎡. The construction started in August, 2014. It is estimated that the Museum will be completed in October, 2016. The Museum integrates technology, exhibition and experience function into one, which is beneficial to the business, publicity and education etc.\r\n\r\nThe Museum will become the show window to present the material civilization and spiritual civilization of LED industry which is also the historical sum and future expectations of it. Now we would like to collect all kinds of exhibits on display. It could be a lamp, a device, a photo, a magazine or a video etc. No matter what kind of the form it is, once accepted, we will make a Donation Roster to list donator’s names or the company’s names on it for displaying, thus we would have the honor to make you and the company to be the witnesses of our company’s history. For all sectors of society, you are welcome to donate or provide related clues for us. The details are as follows:', 'http://www.led-professional.com/business/company-information/5000m2-led-museum-opens-in-october-2016', 'LED_Museum.jpg', '', 'top', '50000 sq ft LED Museum Opens in October 2016', '50000 sq ft LED Museum Opens in October 2016', 13, '2016-04-10 01:03:18'),
(18, 'CHI', 0, 'CHINA', 'UBM TRUST', 'LEDCHI', 'LED CHINA 2016 Press Release - Strategic Alliance with Alibaba B2B Business Unit', 'SHANGHAI, May 18, 2016', 'The \"O2O2O Solution\", or \"Online to Offline to Online\" integrated trade services, jointly-developed by UBM and Alibaba B2B will catapult the trade sourcing experience for manufacturers and buyers before, during, and after a trade show into a new era. Visitors, professionals, and media will be able to experience firsthand the \"O2O2O Solution\" at its debut at the collocated SIGN CHINA and LED CHINA fairs to take place 19-22 September 2016 at the Shanghai New International Expo Centre (SNIEC) in Shanghai, China.\r\n\r\nThe \"O2O2O Solution\" was developed after months of studies on the dynamics and areas of potential in the online and offline trading worlds by UBM and Alibaba B2B teams, including extensive customer surveys, and will encapsulate an end-to-end solution for professional buyers including*:\r\n\r\n1. For sourcing professionals, personalized search capabilities over a larger pool of potential qualified suppliers and existing business partners, using integrated Alibaba.com and UBM knowhow;\r\n\r\n2. For exhibiting companies, search abilities from a larger pool of quality sourcing professionals amongst UBM databases and Alibaba.com members, and enhanced online showroom to display products and company information;\r\n\r\n3. Business match-making and communication functions allowing buyers and sellers to connect before, during, or after an event and to set meetings during the event;\r\n\r\n4. Full service onsite \"O2O2O Solution Pavilion\" with meeting space, lounge and concierge services at SIGN CHINA and LED CHINA.\r\n...', 'http://en.prnasia.com/story/149547-0.shtml', '', '', 'top', 'LED CHINA 2016 Press Release', 'LED CHINA 2016 Press Release - Strategic Alliance with Alibaba B2B Business Unit', 17, '2016-05-31 23:38:42'),
(19, 'ilu002', 0, 'italy', 'iluminatronica', 'ILUMT', 'ILLUMINOTRONICA 2016', 'Press releas Milan, March 5. LED lighting, smart technologies and customized solutions to achieve wellbeing, safety and energy savings', 'Milan, March 5 - Smart lighting, Li-Fi, OLED, Internet of Things, Solid State Lighting. All these words are related to innovation and new technologies which are changing - after the introduction of LEDs in lighting sector - our way of thinking light in different scenarios. Not to mention the high performance and lower costs that make LED a pervasive technology, with growth peaks in all applications.\r\n\r\nNew technologies and electronics for lighting applications (sensors, drivers, wireless devices, thermal management, etc.) represent the core of Illuminotronica 2016, a unique professional meeting in Italy dedicated to lighting in all its aspects. \r\n\r\nHeld from 6th to 8th October in Padua, Illuminotronica is a privileged point of view dedicated to all those who install, design or apply technologies, systems, products for smart lighting integrated with security and home automation systems. The event is promoted by Assodel (Italian Association of Electronics Clusters) and represents an important occasion of discussion between technicians and professionals, as well as an opportunity for updating on technological developments, market trends and new business opportunities.\r\n\r\nFirst of all, the smart home\r\nOur houses are subject to continuous changes, mostly related to the adoption of new technological devices and smart solutions that can cut energy consumption, optimize the control and management and improve the quality of our lives.\r\nThe smart home market is driven by different aspects, such as the European regulations on energy efficiency, the Italian tax recovery policies and the development of increasingly affordable and reliable technologies.\r\n\r\nIlluminotronica 2016 especially focuses on smart home as the result of home automation, smart lighting and security integration, to meet people well-being and security needs.\r\n\r\nIlluminotronica’s numbers\r\n	3,000 sqm of exhibition area\r\n	more than 6,300 visitors\r\n	more than 160 exhibitors and partners\r\n	+20% for International presences\r\n	+35% for events participants\r\n	more than 120 meetings (conferences, round tables, workshop, seminars)\r\n	2 installation labs and 4 demo areas\r\n	150 attendees at the Gala dinner in Venice\r\n\r\nEvent topics\r\nIlluminotronica offers a comprehensive view on lighting, home automation and related technologies. These increasingly interconnected and integrated areas allow Illuminotronica to propose to industry professionals a series of initiatives, demo areas and conferences.\r\n\r\nAmong the 2016 edition topics:\r\n\r\n•	LED/Lighting: \r\nTechnologies & design through the dialogue between who provides technologies and who manufactures lighting fixtures\r\n•	Smart Hut: \r\nSystems and hardware / software solutions to optimize applications, security, efficiency in smart homes and \"visible\" aspects (lighting, security, energy)\r\n•	Elettro & Micro: \r\nElectronics (components and systems) to power, assemble, drive products and solutions in the meeting point between who offers and who acquires know-how \r\nand solutions  \r\n\r\nA 360 degrees training session\r\nIn addition to the exhibition areas, Illuminotronica is a training point of reference thanks to its conferences, debates and training sessions organized in collaboration with experts.\r\nIn particular, the event proposes a series of free short technical and educational courses according to different difficulty levels, as well as seminars with credits, studied together with leading trade associations and accredited by professional orders.\r\n\r\nFurthermore, technical schools can have customized courses with the aim of giving students a new approach on energy saving and flexibility offered by new technologies in the home automation and lighting fields.\r\n\r\nRecognising efficiency, design and innovation\r\nIlluminotronica 2016 will host two award ceremonies, to emphasize innovation and made in Italy design:\r\n\r\nThe Codega Prize (www.premiocodega.it) is assigned to the best LED projects and solutions in Contract applications. The 4th edition of the International award that highlights innovative lighting projects and excellences in design will take place in Venice on 7th October.\r\n\r\n \r\nThe 18th edition of the Ecohitech Award, which is addressed to public municipalities which adopted LED technology in urban lighting, achieving important results in term of energy saving and citizens well-being.', 'http://illuminotronica.it/?utm_source=Ledelum&utm_medium=banner&utm_term=Illuminotronica&utm_campaign=Illuminotronica2016', 'Illuminotronica_2015_pressrelease.jpg', 'ILLUMI:NOTRONICA', 'top', 'ILLUMINOTRONICA 2016', 'LED lighting, smart technologies and customized solutions to achieve wellbeing, safety and energy savings', 16, '2016-06-09 00:25:29'),
(20, 'LPS02', 0, 'Austria, Europe', 'LPS', 'LPS', 'LpS 2016 -  The International Conference Dedicated  to Lighting Innovations, Trends and Technologies', 'Press Release.', 'The 6th International LED professional Symposium +Expo in Bregenz from September 20th to 22nd reinforces creativity, innovations and new lighting solutions. The outstanding conference program will focus on “Smart Technologies for Lighting Innovations.”\r\n\r\nThe Lighting Trends, Knowledge & Innovation Platform \r\nThe lighting sector is facing enormous challenges. The LEDification process is ongoing while Intelligent Lighting and Human Centric Lighting strongly affect future lighting developments. New stakeholders, market players and organizations play important roles in future businesses and technology opportunities. State-of-the art knowledge, trend views and collaborations are vital for success in the highly dynamic market. In this environment the annual 3-day LpS event builds a platform to follow the latest trends, predict next generation lighting solutions, enforce collaborations and trigger lighting innovations. \r\n\r\n4 Tracks with over 70 Top-Class Speakers\r\nThe conference program will concentrate on Future Trends, Intelligent Light, Internet of Things, Light Quality, Light Sources, Intelligent Lighting, Optics, Thermal Management, Reliability, Testing, and Applications, in four parallel tracks. More than 70 international speakers from key organizations such as IBM, Johnson Controls, Bartenbach, Lumileds, Tridonic, Philips, Holst Center, Infineon, NXP, and several renowned universities, will present their findings in the opera house and James Bond film location, the Festspielhaus Bregenz, on beautiful Lake Constance. \r\n\r\nHigh-Level Lighting Celebrities \r\nThe LpS 2016 will be opened by Nobel Prize Laureate Professor Shuji Nakamura from the University of California Santa Barbara (the inventor of the blue and white LEDs), who will present the latest developments in LED and Laser-Diode technologies. The opening will also give insights into the strategic goals of the European Commission and LightingEurope, the voice of the European lighting industry. Secretary General, Diederik de Stoppelaar will highlight their strategic lighting roadmap 2025 in the field of intelligent lighting.\r\n\r\n5 New Lighting Innovation Triggers \r\nA “Design meets Technology Forum” is planned where the needs and requirements of lighting designers will be discussed and interaction with lighting engineers and system designers will be sought. The creative lighting community will also be given the chance to present their solutions from the component up to the lighting systems in the new “Start-Up Innovators” area. Besides the technical innovations, a Light-Art Design area opens the door to lighting designers and lighting artists, presenting their objects in the foyer of the opera house. In addition, intelligent light engines will be presented in a workshop covering spectrally and tunable LED and OLED lighting. The European project HI-LED will be covering “Intelligent Solutions” for museum, horticulture and street lighting. Finally, on day 3, EPIC, the European Photonics Industry Consortia, will offer a workshop on Horticulture Lighting and present their latest findings in plant growth system lights.\r\n\r\nVisitors, Exhibitors and Partners \r\nThe organizers are expecting more than 1,500 visitors from over 50 countries. More than 100 exhibitors will present new products, latest innovations and the current status of LED and OLED lighting technologies in a 3,000 square meters exhibition area. Over 20 media partners, about 15 supporting organizations and several scientific partners are supporting the LpS 2016 event. \r\n\r\nEarly Bird Tickets Available \r\nOnline registration is open now with Early Bird tickets available until July 1st at the official event website: www.LpS2016.com. \r\n\r\nContact the Organizer:\r\nLuger Research e.U., Institute for Innovation & Technology \r\nMoosmahdstrasse 30, 6850 Dornbirn, Austria, Europe \r\nP +43 5572 39 44 89\r\nF +43 5572 39 44 89 90\r\ninfo@lps2016.com\r\nwww.LpS2016.com \r\nwww.led-professional.com\r\nwww.lugerresearch.com', 'http://www.LpS2016.com', 'LPS2016_Opening_Keynote.jpg', 'LPS2016 Opening Keynote', 'top', 'LpS 2016 -  The International Conference Dedicated  to Lighting Innovations, Trends and Technologies', 'The 6th International LED professional Symposium +Expo in Bregenz from September 20th to 22nd reinforces creativity, innovations and new lighting solutions.', 15, '2016-06-11 00:18:46'),
(21, 'ACM002', 0, 'Conference. 26-27 September 2016 in Cairo, Egypt.', 'acm', 'ACM', 'LightingTech Egypt', 'Lighting: a major element in reducing Egypt’s energy consumption.', 'Egypt is the fastest growing economy in the Middle East and Africa and is one of the most populous countries.  To reduce the energy demand, Egypt’s energy efficiency program requires the total energy consumption of government buildings and street lighting to be reduced by 50% by December 2016.\r\nIn April 2015, a project valued at US$268.2 million was announced by the Minster of Electricity to replace 3.89 million street lamp bulbs with energy-efficient ones and is slated to be completed in 28 months. The objective of the energy-efficient street lighting will save Egypt US$191.52 million annually.\r\nThe 2nd annual LightingTech Egypt will be held on 26-27 September 2016 in Cairo, Egypt. This conference is organized by Advanced Conferences and meetings and will discuss the challenges, latest technology advancements, partnership requirements and market entry strategies.\r\n\r\nImplementing LED in 22 new cities\r\nThe New Urban Communities Authority which falls under the Ministry of Housing, Utilities & Urban Development (MoH), has been tasked with implementing LED and solar retrofits across the 22 new cities. \r\nWhy take part in LightingTech Egypt conference?\r\nThis conference is being launched to help demonstrating best practice implementation to answer the specific requirements and challenges in Egypt.\r\nThis unique and timely event will bring together the relevant government bodies, lighting industry experts, developers, consultants and solution providers.\r\nFor further information about the conference, please visit www.lightingtechegypt.com.', 'http://www.lightingtechegypt.com/', '', '', 'top', 'LightingTech Egypt', 'Lighting: a major element in reducing Egypt’s energy consumption.', 18, '2016-07-03 13:05:41'),
(22, 'ILU003', 0, '6-8 October 2016 - Padova', 'iluminatronica', 'ILUMT', 'ILLUMINOTRONICA 2016', 'Press release. Milan, June 13, 2016. Meet and discover new technologies  at home, cities, design, and in practic.', 'Milan, June 13, 2016 - From 6 to 8 October in Padua, Illuminotronica will showcase new technologies and \"smart\" solutions embracing the fields of LED lighting, security and home automation integration. Promoted by Assodel (the Italian Association of Electronics Clusters), Illuminotronica represents an important opportunity for discussion among technicians, companies and professionals, as well as a moment of meeting and update on technology developments, market scenarios and new business opportunities.\r\n\r\nTechnologies on display\r\nThrough a single leading thread – new technologies – Illuminotronica presents four application scenarios. For each of them, there are exhibitions and demonstration areas, talk shows, courses, workshops, special initiatives.\r\n\r\nHOME - The Smart Home is the focal point of the smart lighting, security and home automation integration market. The demo area is 96 square meters, home automation (in pad.5 in partnership with CasaClima and the KNX technical director) applied where to find the latest news in terms of wireless controls, sensors, thermostats, intelligent lighting systems, devices for the control of consumption. With training skills for professionals and courses with credits.\r\n\r\nCITIES - From Smart Home to Smart City, the step is not too far... In the show, Illuminotronica offers products and solutions for public lighting, video surveillance, network and internet of things, focusing on citizens well-being and safety. While Ecohitech Award, in its 18th edition, rewards municipalities for the energy saving and sustainable results achieved through the embracing of LED lighting solutions and new technologies. There will also be one-to-one meetings between Esco and public administration.\r\n\r\nDESIGN - A path where new technologies meet with new design. With Light Experience, demo areas created from the collaboration between lighting industry and lighting designers, and a Gallery with the innovative design products, featuring the best of LED lighting for indoor and outdoor. Finally, Codega Prize, aimed at lighting professionals, solutions and achievements of excellence in the use of LED technology (premiocodega.it).\r\n\r\nIN PRACTICE - Learn about the new products and explore its complexity design through courses, round tables and \"practical\" sessions in which it is possible to experiment and test innovative products and systems for smart lighting. In particular, E-Lab is the area of the field trials, designed for electrical and electronic technicians. A laboratory and a T&M corner for those who want to put themselves in the use of new technologies.\r\n\r\nFor more information\r\nwww.illuminotronica.it', 'www.illuminotronica.it', '', '', 'top', 'ILLUMINOTRONICA 2016', 'Meet and discover new technologies  at home, cities, design, and in practic.', 19, '2016-07-04 14:56:01'),
(23, '00012', 1, 'Osram', 'LEDELUM', NULL, 'Dula OLED', 'Ceiling luminaire installation', 'OSRAM and the specialist for exclusive store design and interior design Dula jointly developed an OLED ceiling light for high quality shop design.\r\n\r\nIn order to present the effect of the new OLED luminaires to the customers, they are already being installed in the lobby of the store lighting designer Dula in Dortmund. The special properties characterize OLED as a representative design element, especially for high-end applications.\r\n\r\nThe luminaires were created following a design concept by the experts at Dula lighting design. Each luminaire consists of a glass panel, wherein nine acrylic blocks – also called OLED Sandwiches - were inlaid, each with two large squared (12 x 12 cm) ORBEOS SDW-058 OLED panels. The luminaires constructed like this are attached to the ceiling, individually adjustable in height, and they cause impressive 3D effects. In addition, the OLED panels can be individually controlled and dimmed wireless via DMX protocol. This creates dynamic visual effects that bathe the room in a warm, soft light.', 'http://www.osram-oled.com/oled/en/applications/reference-projects/dula-oled-ceiling-luminaire-installation/index.jsp', 'OSRAM_dula-deckeninstallation-oled.jpg', 'OSRAM Dula OLED', 'top', 'Dula OLED', 'Dula OLED', 20, '2016-07-23 20:53:30'),
(24, 'LPS03', 0, 'Bregenz, Austria', 'LPS', 'LPS', 'LpS 2016 - Technologies and Innovations  in 6 Key Lighting Applications', 'August 23, 2016', 'Ruairí O’Brien, Vice-President at the Federation of International Light Designers and presenter of the paper “High Quality Lighting Designs with SSL – Practical Examples and the New Role of Lighting Designers”, said, “Lightcentric” is my key word for the future and the future belongs to the lighting designer. In the future, entire buildings, objects and surfaces will give us the light and the darkness we require, historical buildings will light from within, ‘sources’ will all but disappear from view, stars will appear and the word ‘skyline’ will receive a new meaning and importance. This is the dawn of a new architecture, a LIGHT architecture not just human centric but LIGHTCENTRIC”. Ruairí will also take part in the Design meets Technology Forum, organized by the Italian Lighting Design organization APIL and will talk about “Who\'s afraid of Red, Yellow and Blue”: The importance of holistic thinking for designers and technologists. \r\n\r\nPhilipp Ansorg is Researcher at AUDI and talks about fascinating LED and laser technology trends. “The LED technology enables control of every individual light-emitting diode in a synchronized lighting system. New luminous surfaces and flowing activations transform light from static to dynamic. The development of efficient lighting systems is an important component of the overarching trend of electro mobility. Therefore LED and laser based systems are the foundation of efficiency enhancements. Laser based lighting technology such as Digital Micromirror Devices enable ideal high definition light patterns for virtually every situation on the road. It is realized by means of a chip with hundreds of thousands of micromirrors that divide the light into tiny separately controlled pixels. The mentioned technology will be an important part for the communication of piloted driving vehicles and pedestrians. For instance, it is possible to indicate to pedestrians on the roads that they have been recognized and can cross the road safely”. Mr. Ansorg will talk about “Safety Concept for Future Laser Based Headlamp Systems” at the Alternative Light Sources Forum organized by the Photonics Cluster.\r\n\r\nAnja Dieleman, Scientist at Wageningen UR Greenhouse Horticulture, summed up the major and highly effective impacts of LED technology on horticultural lighting. “LED lighting can contribute to the reduction of the carbon footprint of horticultural products, due to the high efficiency with which they convert electricity in light. However, the largest impact of LED lighting for greenhouse horticulture will be in the possibilities LEDs offer to provide the light colors the plant requires, depending on the developmental stage of the plant and the time of the day. In this way, we can steer pot plants to become more compact, flowers to form long shoots and tomatoes to produce tastier fruit. Our challenge is to find the proper dynamic lighting recipes for this”.\r\n\r\nFerenc Szabo, Professor at the University of Pannonia: “In 2016, the world still has many different opinions about LEDs applied in artwork lighting. Enhanced color has become evident but the possible effects of light on materials are still being argued about. Besides the basic facts that come from physics we still need more ‘close to reality’ investigations. Thanks to the ongoing multidisciplinary research works on LED museum lighting, more and more information is gained on the effects of LED light on historical materials. These results will help us to preserve our cultural heritage”.\r\n\r\nTechnologies are evolving fast from the light source to smart controls, networks and finally to intelligent lighting. It’s a huge potential of new forces driving the future. On the other hand, we can obtain the individual and specific directions within the key applications as the statements showed above. Carlos Lee, Secretary General at EPIC and organizer of a Horticulture Lighting workshop at the LpS 2016, summed it up with a general overview on Photonics technologies: “Photonics is a thrilling technology with applications found really everywhere. Products relying on photonics technology are found in photovoltaic, lighting, communication, defense, medical diagnostics and treatments, environmental monitoring, transport, and many more. Photonics is like electronics 40 years ago, it’s a key enabling pervasive technology, and we haven’t yet exploited the full potential”.\r\n\r\nThe LpS 2016 will be opened with fascinating keynotes featuring Nobel Prize Laureat Prof. Shuji Nakamura. Another highlight will be the Scientific Award Ceremony, where the best paper will be honored, after which will be the official opening of the high-class exhibition with internationally significant companies, media partners, scientific partners and Start-Up innovators. Among the myriad of products and services there will also be a humanoid robot and an Audi R8 with laser headlights to see. Selected product launches will be presented to journalists and lighting experts at the LpS 2016 press conference. The international lighting congregation has the possibility to strengthen business contacts at three networking events: the Exhibition Opening, a Meet and Greet evening organized by Munich Re and the Get-Together Evening aboard a cruise ship on Lake Constance. Finally, the organizers would like to thank the main sponsors of the LpS 2016: UL, auer Lighting, Dow Corning, Munich Re, Topsil Global, Tridonic, Osram and Wago. \r\n\r\nForums and Workshops \r\n- International Solid-State Lighting Alliance by ISA \r\n- Design meets Technology by APIL\r\n- Alternative Light Sources by Photonics Cluster\r\n- Risk Transfer & Investment for the LED Industry my Munich Re \r\n- Spectrally – Tunable LED and OLED Lighting by HI-LED\r\n- IoT & Artificial Intelligence by Jakajima \r\n- Horticultural Lighting by EPIC\r\n- SSL Lighting Measurement by Instrument Systems & TÜV SÜD \r\n\r\nConference Program: www.LpS2016.com/event_program \r\nTicket Registration: www.LpS2016.com/registration \r\nPictures: https://drive.google.com/drive/folders/0B-46hVO9vCt0anYwbE5kNmd3MjA?usp=sharing\r\n\r\nLuger Research e.U., Institute for Innovation & Technology \r\nMoosmahdstrasse 30, 6850 Dornbirn, Austria, Europe \r\nP +43 5572 39 44 89\r\ninfo@lps2016.com\r\nwww.LpS2016.com', 'http://www.led-professional-symposium.com/lps-2016-technologies-and-innovations-in-6-key-lighting-applications', '', '', 'top', 'LpS 2016 - Technologies and Innovations  in 6 Key Lighting Applications', 'More than 100 speakers, 100 exhibitors and 1,500 visitors from over 50 countries will be part of the LED professional Symposium +Expo', 21, '2016-08-27 12:42:43');
INSERT INTO `news` (`news_id`, `sku`, `active`, `location`, `advertiser`, `sku_media`, `title`, `subtitle`, `description`, `url`, `img`, `alt`, `img_pos`, `tag_title`, `tag_description`, `disp_order`, `dt`) VALUES
(25, 'ACM003', 0, 'Cairo, Egypt', 'ACM', 'ACM', 'LightingTech Egypt: A step forward towards a smart and sustainable city', 'Cairo (September 26, 2016)', 'Cairo (September 26, 2016) – In the presence of senior representatives from several government-backed entities in Egypt, Advanced Conferences & Meetings (ACM) proudly launched the 2nd annual LightingTech Egypt conference today at Dusit Thani Lakeview, Cairo, Egypt. \r\nLightingTech Egypt brought together senior representatives from government ministries, lighting designers, engineering contractors and developers to discuss the latest smart, sustainable and cost-effective solutions for Egypt\'s developing public realm.\r\n\r\nThe conference started with a welcoming note from the chairman Prof. Wael Abdelmoez from Minia University followed by a keynote speech by Dr. Hend Farouh detailing the updates on energy saving initiatives by the New Urban Communities Authority.\r\n\r\nThe Ministry of Tourism’s representative Dr. Elham Fouda detailed a presentation about the “Green Tourism” agenda whilst Tarek Sultan detailed the strategies for illuminating highways using high mast lighting solutions. Dr. Salwa Ali delivered a presentation on EEHC (Egyptian Electricity Holding Company) Pilot Project.\r\n\r\n“Very informative! This event created the perfect platform to share new ideas and provided the opportunity to network with the industry experts” – Assistant Landscape Design Director, Emaar\r\n\r\n“Highly recommended. This event provided the chance to network with professionals from the industry and to learn more about new technologies” – Senior Architect, CPAS\r\nDay one of the conference ended with a workshop hosted by RUUD Lighting/CREE. The workshop was divided into two parts, the first part discussed the illumination of multilevel parking structures with LED luminaires whilst the second part detailed the traffic tunnels daytime lighting with LED Luminaires.\r\nThe first day of LightingTech Egypt conference created the perfect platform for the attendees to build relations, exchange ideas and seize business opportunities throughout the ACMi+ interface that allowed for many networking breaks which created a dynamic, efficient and relevant learning environment.\r\n“Excellent! Great line up of speakers” – First Engineer, Petroleum Air Services\r\nMany key players participated in this event, to name a few: Ministry of Tourism, New Urban Communities Authority, Egyptian Electricity Holding Company, EE-Consulting, Turner Construction - International LLC, Emaar Misr for Development, UNDP-GEF Lighting & Appliance Efficiency Improvement Project, Sites International, Redcon Development and Minia University.\r\nSolution providers like Three Brothers, Ruud Lighting/CREE, Al Babtain Leblanc Egypt for Telecom Engineering and NIKKON showcased their newest technologies and solutions for lighting.\r\nDay two (September 26) of the conference will feature many more interesting presentations, to name a few: An update on the Lighting and Appliance Energy Efficiency Improvement Project, LED versus High Pressure Sodium Lamps (HPS), a panel discussion on how can the Egyptian lighting manufacturing industry meet the specifications for Egypt’s developing landscape.\r\nFor more information, please visit: www.lightingtechegypt.com or contact Jessica Bou Samra on Jessica.bousamra@acm-events.com \r\nOrganizers: Advanced Conferences & Meetings is a premium business-to-business conference company focused on the requirements of the MENA region. Its events are highly tailored networking and learning opportunities, bringing senior decision makers together and providing up-to-the-minute information on industry trends, government initiatives, technological advances and developments in regulation. As such, they act not only as extremely effective tools for gaining business advantage, but also as high level platforms for change in the industries they serve.', 'www.lightingtechegypt.com', '', '', 'top', 'LightingTech Egypt: A step forward towards a smart and sustainable city', 'Cairo (September 26, 2016) – In the presence of senior representatives from several government-backed entities in Egypt, Advanced Conferences', 22, '2016-09-29 21:35:13'),
(26, 'LPS04', 0, 'Bregenz, Austria', 'LPS', 'LPS', 'LpS 2016 - he Leading European Lighting Conference Forecasts Further Transformations', 'September 2016', 'The sixth LED professional Symposium +Expo opened its doors on September 20th, in Bregenz, Austria. About 1,500 lighting professionals and over 100 exhibitors took part in Europe’s foremost lighting conference and exhibition. Experts from academia and industry, including Prof. Shuji Nakamura, Nobel Laureate in Physics 2014, discussed cutting edge findings and explored new technologies and applied them to business models and use cases in applications. The conversion of lighting, which started with LED and OLED light sources, will continue with new technologies such as communication tools and IoT. The LpS 2016 also showed that lighting will be transformed into specific solutions for things such as Horticulture Lighting, Automotive Lighting and Indoor and Outdoor Lighting. Smart Technologies for Lighting Innovations, the motto of the LpS 2016, conveyed the key aspects for new lighting solutions – building synergies between devices, algorithms and usages.\r\n\r\nLectures & Scientific Award Winner \r\nThe comprehensive symposium program with about 100 first-class lectures attracted the global lighting community to take part in the conference and visit the exhibition. While the speeches in earlier years were focused on light sources, this year technologies like smart lighting, connectivity and Internet of Things were added to the extended conference program. This reflects a trend moving away from pure LED hardware and towards intelligent lighting. In the field of SSL applications, current developments in Human Centric Lighting were presented and discussed. \r\nFrom all of the submitted publications the Advisory Board selected what it felt were the six best scientific papers according to criteria such as novelty, scientific exposition of the investigations and applicability of the outcomes. The topics of the scientific papers ranged from new phosphor materials and driver technologies over lifetime investigations to optics optimization and measurement. The winner of the LED professional Scientific Award 2016 was Dr. Rubén D. Costa from the University of Erlangen-Nürnberg for his investigation of \"Bio-Inspired White Hybrid Light-Emitting Diodes\". This new color conversion technology might open the door for LEDs that are not dependent on rare earth based phosphors with limited availability. Munich Re, sponsor of the Scientific Award 2016, handed over the €3,000 check to the winner.\r\n\r\nWorkshops and Forums \r\nThe eight interactive workshops and forums covered the subjects of Internet of Things, Artificial Intelligence, Horticulture Lighting, Measurement Standards, Lighting Design Requirements, Color Tunable Lighting, Alternative Light Sources, Risk and Finance Management and Collaboration Strategies with Asia. In summary it can be said that future lighting systems will need a holistic design approach that is based on advanced technologies, covers global regulations and has adaptive and flexible applications for users. The transformation from hardware to software based lighting systems, using the latest digital technologies, can be seen as a primary direction for future designs.\r\n\r\nExhibition \r\nAlongside the LED professional Symposium was the world-class exhibition that visitors have become used to in Bregenz. Exhibitors from all over the world presented high tech products, equipment and services. The Expo showcased a complete range of state-of-the art products from components to systems including controls, subsystems and peripherals for luminaire producers and manufacturers in the main user market segments. The LpS 2016 exhibitor list read like the who’s who of the global LED industry: Nichia, Cree, Osram Opto Semiconductors, Samsung and Seoul Semiconductor, came with their teams from the US, Asia and Europe. Other global players like Arrow, Avnet Silica, BJB, EBV, Dow Corning, DEKRA, Infineon, Instrument Systems, Konica Minolta, Kyocera, Merck, ST Microsystems, Vossloh-Schwabe and Wacker Chemie to name just a few, showcased their latest products and services to an international audience. Among the myriad of products and services there was also a humanoid robot and an Audi R8 with laser headlights to see. Another highlight this year were the Start-Up companies that exhibited and brought totally new and innovative ideas to the show. \r\n\r\nProduct Launches \r\nExciting product launches were presented in the exhibition and at the international press conference. Auer Lighting introduced a new color-mixing glass optic named “Shopwhite” which was designed for multi-color LED arrays. Gigaherz-Optik launched the measuring system “TPI21-TH” for testing and binning of back-end LEDs. The IA-1200 hot melt room-temperature vulcanization adhesive by Dow Corning was formulated to achieve instant green strength. Ophir Photonics pioneered with the “FluxGage” LED luminaire measurement system, which is three times as small as an equivalent integrating sphere. An innovative approach to directional lighting application provides the new Plessey OrionTM PLWSC3000 series. Dow Corning’s MS-4002 moldable silicone retains high transparency even in harsh environments. UL introduced a verification service for lighting products with the opportunity to have an independent third-party laboratory verify the validity of claims about the level of optical flicker. “Synapse” developed by iLumTech is an innovative, intelligent and dynamic smart city control and monitoring system. Last but not least Flip Chip Opto released its first-in-class “Ares Series” UV-A spectrum flip chip COB. \r\n\r\nWorld Record & Tiered Painting \r\nIn the field of alternative light sources, the company InovisCoat GmbH presented the world’s largest electroluminescence film at the LpS 2016 in Bregenz. A juror from Guinness World Records was there to make sure the claims were valid and then entered InovisCoat and LED professional in the Guinness Book of World Records. The use of LED lighting in Art was presented by the American artist, Clint Eccher, who exhibited his tiered paintings in Bregenz. He showed how LED lighting is used to transform static paintings into some of the most advanced paintings in the world. The dynamic, “living” pieces transform their appearance with LED lighting. \r\n\r\nSponsors, Media Partners & Supporting Organizations \r\nThe LpS 2016 Event received great support from the following sponsors: UL, Auer Lighting, Dow Corning, Munich Re, Osram, Topsil Global, Tridonic and Wago. Further, media partners like LICHT, MondoArc, LEDinside and Photonik made it possible that the LpS 2016 received global attention. Important lighting organizations like the Global Lighting Association, LightingEurope, PIDA, EPIC, ISA and many more, helped to bring the top lighting experts together in Bregenz. \r\n\r\nOutlook 2017 \r\nThe 7th LED professional Symposium +Expo is scheduled for September 26th to 28th, 2017 in Bregenz, Austria. The motto “Smart Technologies for Lighting Innovations” will be looked into and current trends in technologies and applications will be presented at the LpS 2017. Key headlines like Re-thinking lighting in applications, lighting innovations that drive new business models and Design meets Technology - Synergies between applications & technologies, summarize the thematic focus of next year’s event very clearly. \r\nCall for Papers for the LpS 2017 will open by the end of October 2016. \r\n\r\nLuger Research e.U., Institute for Innovation & Technology \r\nMoosmahdstrasse 30, 6850 Dornbirn, Austria, Europe \r\nP +43 5572 39 44 89\r\ninfo@lps2016.com\r\nwww.LpS2016.com', 'http://www.led-professional-symposium.com/', '', '', 'top', 'LpS 2016 - he Leading European Lighting Conference Forecasts Further Transformations', 'The sixth LED professional Symposium +Expo opened its doors on September 20th, in Bregenz, Austria. About 1,500 lighting professionals and over 100 exhibitors took part in Europe’s foremost lighting conference and exhibi', 23, '2016-09-29 21:46:08'),
(27, 'FOP003', 0, 'Padua, Italy', 'ILLUMINOTRONICA 2016', 'ILUMT', 'ILLUMINOTRONICA 2016', 'Press Release N.6.', 'Over 7,000 participants and a 15% of growth confirm the event as the Italian reference point in LED lighting, smart solutions and new technologies\r\n\r\nMilan, October 18th, 2016 – Record numbers for the 6th edition of Illuminotronica, which has taken place in Padua from the 6th to the 8th October becoming the Italian most important Italian trade fair focused on LED lighting, \"smart\" solutions, home automation and security. A successful edition sanctioned by the presence of an highly specialized audience composed by 7,245 professionals: decision makers, purchasing managers, buyers, engineers, electricians, installers, system integrators, architects, lighting designers, Public Administration representatives.\r\nStarting with a complete “sold out”, made by a 3,500 square meters area and 190 companies distributed in two halls, the event registered a 15% of growth on the previous year collecting exhibitors’ satisfaction. Sponsors, visitors and conferences’ speakers recognized Illuminotronica great added value: the ability to offer, year after year, a unique marketing and communication tool, a state-of-the-art showcase of products, solutions and technologies, a laboratory of trends in lighting and home automation sectors and a significant business and networking opportunity for professionals of the same field.\r\nThanks to the rich conference program, to the training sessions and to some special initiatives - such as the Start-Up Area, with 10 innovative Italian companies selected by Assodel; the Smart Home demo (96 square meters and the 6 rooms) and the Leddove Gallery, with its LED design products and solutions - Illuminotronica represents a unique professional event in Italy where it is possible to update and consider the lighting, home automation and smart solution new challenges. In this way, the event demonstrates to be not only a trade fair, but also the mirror of a dynamic and evolving market.\r\n\"With great satisfaction we look at this constantly growing event as a reference point for all the professionals of the lighting and smart solutions sectors - said Silvio Baronchelli, President at Tecnoimprese, the Illuminotronica organizer -. This is a confirmation of an evolving industry and a growing number of operators who want to update their knowledge on technologies, market trends, new products and solutions. Also the success of the Codega Prize, awarded in the amazing setting of the Peggy Guggenheim Collection, in Venice, highlighted the event central role in recognizing the LED lighting excellences\".', 'http://illuminotronica.it/en/', 'ILL2016_expo.jpg', 'ILLUMINOTRONICA 2016', 'top', 'ILLUMINOTRONICA 2016', 'Over 7,000 participants and a 15% of growth confirm the event as the Italian reference point in LED lighting, smart solutions and new technologies', 24, '2016-11-01 20:33:08');

-- --------------------------------------------------------

--
-- Table structure for table `news_images`
--

CREATE TABLE `news_images` (
  `image_id` int(10) UNSIGNED NOT NULL,
  `news_id` int(10) UNSIGNED NOT NULL,
  `img_src` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_images`
--

INSERT INTO `news_images` (`image_id`, `news_id`, `img_src`, `alt_name`) VALUES
(26, 20, 'LPS_Exhibition.jpg', 'LPS_Exhibition'),
(27, 20, 'LPS_Event Location.jpg', 'LPS_Event Location'),
(28, 19, 'Illuminotronica_2015_2_pressrelease.jpg', 'ILLUMI:NOTRONICA'),
(29, 19, 'Illuminotronica_2015_3_pressrelease.jpg', 'ILLUMI:NOTRONICA'),
(30, 19, 'Illuminotronica_2015_4_pressrelease.jpg', '');

-- --------------------------------------------------------

--
-- Table structure for table `pages_html`
--

CREATE TABLE `pages_html` (
  `page_id` tinyint(3) UNSIGNED NOT NULL,
  `page_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_html` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `heading` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages_html`
--

INSERT INTO `pages_html` (`page_id`, `page_name`, `page_html`, `heading`) VALUES
(1, 'Terminology', '<div style=\"float: left; margin-left: 0rem;\">\r\n<div style=\"font-size: 2rem; color: #1d2623;\"><span style=\"font-size: 2rem;\">EDUCATION</span></div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">\r\n<div class=\"apps-title\">&nbsp;</div>\r\n<div class=\"apps-descr\">Stay tuned for educational videos, upcoming webinars.&nbsp;</div>\r\n<div class=\"apps-left\"><img src=\"../../images/education/ED_LIGHTING.jpg\" alt=\"Education Lighting\" />\r\n<div class=\"apps-subtitle\"><strong>Lighting Basic&nbsp;</strong></div>\r\n<div class=\"apps-descr\">What is&nbsp;Lighting Distribution, Lighting Power, Color temperature, Lighting measurements?.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"../../images/education/ED_LED.jpg\" alt=\"Education LED Lighting\" />\r\n<div class=\"apps-subtitle\"><strong>SSL Lighting</strong></div>\r\n<div class=\"apps-descr\">LED and OLED sources, How it works. What\'s good and what\'s bad.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"../../images/education/ED_CONTROLS.jpg\" alt=\"Education Lighting Controls\" />\r\n<div class=\"apps-subtitle\"><strong>Lighting Controls</strong></div>\r\n<div class=\"apps-descr\">Types of ballasts and dimming controls. Dimming Protocols, limitations and benefits.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"../../images/education/ED_ENERGY.jpg\" alt=\"Education Energy Codes\" />\r\n<div class=\"apps-subtitle\"><strong>Energy Codes</strong></div>\r\n<div class=\"apps-descr\">Energy references and what to consider when designing lighting for commercial and residential applications in modern environment.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<hr />\r\n<p>WEBINARS AND LEARNING VIDEOS</p>\r\n<div class=\"educ-video\">\r\n<div class=\"educ-video-left\"><iframe src=\"https://www.youtube.com/embed/Fq3K2wsItw0\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"educ-video-right\"><iframe src=\"https://www.youtube.com/embed/4CxE6uM0uOE\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n</div>\r\n<div class=\"educ-video\">\r\n<div class=\"educ-video-left\"><iframe src=\"https://www.youtube.com/embed/SXkjpGVL0Lg\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"educ-video-right\"><iframe src=\"https://www.youtube.com/embed/vLDDhsUmcww\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n</div>\r\n<div class=\"educ-video\">\r\n<div class=\"educ-video-left\"><iframe src=\"https://www.youtube.com/embed/G4iDKzqw-z0\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"educ-video-right\"><iframe src=\"https://www.youtube.com/embed/KSF1jhX12nM\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n</div>\r\n<div class=\"educ-video\">\r\n<div class=\"educ-video-left\"><iframe src=\"https://www.youtube.com/embed/yHUdMdfrV2M\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"educ-video-right\"><iframe src=\"https://www.youtube.com/embed/LnGzYtJ-QT4\" width=\"100%\" height=\"315px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>TERMINOLOGY</p>\r\n</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">Luminaire</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">A complete lighting unit consisted of a light source and driver together with parts to distribute light.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">SSL</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Solid State Lighting. Refers to a type of lighting that uses semiconductor light-emitting diodes (LEDs), organic light-emitting diodes(OLED), or polymer light-emitting diodes (PLED) as sources of illumination.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">LED</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Light Emitting Diode is a semiconductor light source.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">OLED</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Organic Light Emitting Diode is a light-emitting diode (LED) in which the emissive electroluminescent layer is a film of organic compounds which emits light in response to an electric current. This layer of organic semiconductor material is sandwiched between two electrodes. Generally, at least one of these electrodes is transparent.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">Lm</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Luminous flux (lumen). the basic unit used to measure the flow of light in the SI system, equal to the amount of light emitted through a solid angle of one steradian by a light source with the intensity of one candela (0.0015 watt)</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">Cd</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Is the SI base unit of luminous intensity; that is, power emitted by a light source in a particular direction. A common candle emits light with a luminous intensity of roughly one candela. If emission in some directions is blocked by an opaque barrier, the emission would still be approximately one candela in the directions that are not obscured.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">Watt</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Is a derived unit of power in the International System of Units (SI)</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">Efficacy - Lm/Watt</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Luminous efficacy is a figure of merit for light sources. It is the ratio of luminous flux (in lumens) to power (usually measured in watts).</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">CCT</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Color correlated temperature is the color temperature of a black body radiator which to human color perception most closely matches the light from the lamp. Color temperature is a characteristic of visible light that has important applications in lighting, photography, videography, publishing, manufacturing, astrophysics, and other fields.<br />The eight ANSI defined MacAdam ellipses (2700k, 3000k, 3500k, 4000k, 4500k, 5000k, 5700k, and 6500k)<br /><br />There are also:<br />Amber or \"Wide life\", Tunable white that has controllable range from warmer to cooler CCTs RGB - color changing or color tunable light based on tree colors Red, Green and Blue RGBW - that adds white component to RGB system RGBY - with Yellow component to accentuate orange and yellow colors, that otherwise are not easily achievable with standard RGB.<br /><br />Warm dimming LED - contrary to standard LED which keeps practically the same CCT when dimmed, the warm dimming simulates incandescent lamp when dimmed down, by warming light - changing CCT from usually 3000K or 3500K or 4000K to less than 2400K.</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">&nbsp;</div>\r\n<p>&nbsp;</p>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">CRI</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Color rendering index, or CRI, is a measure of the quality of color light, devised by the International Commission on Illumination (CIE). It generally ranges from zero for a source like a low-pressure sodium vapor lamp, which is monochromatic, to one hundred, for a source like an incandescent light bulb, which emits essentially blackbody radiation.</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">It is related to color temperature, in that the CRI measures for a pair of light sources can only be compared if they have the same color temperature. The highest attainable CRI is 100. Lamps with CRIs above 70 are typically used in office and living environments. LED source 80 CRI minimum (indoor).</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">STANDARDS</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">LM-79-08</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">IESNA Approved Method for the Electrical and Photometric Measurements of Solid-State Lighting Products,\" will specify procedures for measuring total luminous flux, electrical power, luminous efficacy, and chromaticity of SSL luminaires and replacement lamp products.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">TM-21-11</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Provides the method for determining when the &ldquo;useful lifetime&rdquo; of an LED is reached. The method restricts which values can be used in the calculation based on the sample size, number of hours and intervals tested, and test suite temperature. It also limits the extrapolation for max hours to 6X the hours tested.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">LM-80</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">IESNA Approved Method for Measuring Lumen Depreciation of LED Light Sources, specifies procedures for determining lumen depreciation of LEDs and LED modules (but not luminaires) related to effective useful life of the product. Defines Lumen Maintenance Life: L70 (hours): 70% lumen maintenance L50 (hours): 50% lumen maintenance 70% of initial lm to 35,000 hours (commercial) or 25,000 hours (residential)</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">NFPA 70-2005</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">National Electrical Code requires that most SSL products must be installed in accordance with the National Electrical Code.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">47 CFR Part 15</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Radio Frequency Devices, specifies FCC requirements for maximum allowable unintended radio-frequency emissions from electronic components, including SSL power supplies and electronic drivers. The Federal Communications Commission (FCC), Washington, D.C., www.fcc.gov, is an independent U.S. government agency, directly responsible to Congress.</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">The FCC was established by the Communications Act of 1934 and is charged with regulating interstate and international communications by radio, television, wire, satellite, and cable.</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">REFERENCES</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">CCT (IESNA LM-79, LM-58, LM-16, and CIE 15-2004)</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Color spatial uniformity (IESNA LM-79, LM-58, LM-16, and CIE 15-2004)</div>\r\n<div style=\"font-size: 1.3rem; color: #6c7c7b;\">Color maintenance (ANSI C78.377A, IESNA LM-79, LM-58, and CIE 13.3-1995) Referenced resources: IESNA, ANSI, National Electrical Code, NFPA, CIE, FCC</div>\r\n</div>', 'EDUCATION AND TERMINOLOGY'),
(2, 'About Us', '<div style=\"float: left; margin-left: 0rem;\">\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\"><span style=\"font-size: 24px;\">ABOUT LIGHT<span style=\"color: #e67e23;\">AZ</span>.COM</span></div>\r\n<div style=\"font-size: 2rem; color: #1d2623;\">&nbsp;</div>\r\n<div style=\"font-size: 1.3rem; color: #444444;\">\r\n<p><span style=\"font-size: 16px;\">Welcome to Light<span style=\"color: #e67e23;\">AZ</span>.com. The largest and most comprehensive search engine in the professional lighting industry. With more than 20+ years of experience in the industry, we have developed a search engine with fast, intuitive search capabilities, project management options, and efficient share and communication features, that easily and effortlessly connects specifiers to 10,000+ luminaires within seconds. Our unprecedented search engine and individual product configurator represent a new productivity tool for manufacturers, and a new user-friendly and time-saving tool for specifiers. With Light<span style=\"color: #e67e23;\">AZ</span>.com you will be able to search, specify and connect. All in one platform.&nbsp;</span></p>\r\n<p><span style=\"font-size: 16px;\">Our mission is to provide a 24/7 connection between specifiers, agents, and lighting manufacturers by delivering fast and accurate product information when needed &ndash; in the office or on the go.&nbsp;</span></p>\r\n<p><span style=\"font-size: 16px;\">Light<span style=\"color: #e67e23;\">AZ</span> Inc. is owned and operated by creative minds with experience in lighting, LED technology, and IT. We are the leading search engine for the LED lighting industry in North America and internationally. Our main office is located in Chicago, with additional offices being established in Europe.</span></p>\r\n</div>\r\n</div>\r\n<div class=\"apps-title\">&nbsp;</div>\r\n<div class=\"apps-title\"><hr /></div>', 'ABOUT LIGHTAZ.COM'),
(3, 'LightAZ Surveys', '<div id=\"qp_all207356\" style=\"width: 100%;\">\r\n<div id=\"qp_main207356\" style=\"border-radius: 0px; margin-top: 20px; padding: 0.8em; background-color: #fff; font-family: \'Open Sans\', sans-serif, Arial; color: #000; border: 1px solid #DBD9D9; max-width: 100%;\">\r\n<div style=\"font-size: 2.5em; background-color: #f0f0f0; color: #000; font-family: \'Open Sans\', sans-serif, Arial;\">\r\n<div style=\"padding: 0.8em; line-height: 1.3em;\">Different CRI for up and down lighting in the same space?</div>\r\n</div>\r\n<form id=\"qp_form207356\" style=\"display: inline; margin: 0px; padding: 0px;\" action=\"//www.poll-maker.com/results207356xeD6E492a-7\" method=\"post\" target=\"_blank\">\r\n<div style=\"padding: 0px;\"><input name=\"qp_d207356\" type=\"hidden\" value=\"42446.5442824025-42446.5442109284\" />\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v207356\" type=\"checkbox\" value=\"1\" /><span style=\"font-size: 14px;\">Yes, if CCT can be adjusted</span></span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit; font-size: 14px;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v207356\" type=\"checkbox\" value=\"2\" />Not a good idea</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit; font-size: 14px;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v207356\" type=\"checkbox\" value=\"3\" />Yes. Depending on application</span></div>\r\n</div>\r\n<div style=\"padding-left: 10px; padding-bottom: 10px; min-height: 40px; clear: both;\"><span style=\"color: #ffffff;\"><a class=\"qp_btna\" style=\"float: left; width: 50%; max-width: 140px; box-sizing: border-box; padding-right: 5px; text-decoration: none; color: #ffffff;\" href=\"#\"><input style=\"width: 100%; height: 40px; font-family: \'Open Sans\', sans-serif, Arial; font-size: 16px; color: #ffffff; cursor: pointer; border: 0px #ffffff; -webkit-appearance: none; border-radius: 0px; background: #684255;\" name=\"qp_b207356\" type=\"submit\" value=\"Vote\" /></a></span></div>\r\n<a id=\"qp_a207356\" style=\"float: right; font-family: Arial; font-size: 10px; color: #ffffff; text-decoration: none;\"></a></form>\r\n<div style=\"display: none;\">&nbsp;</div>\r\n<script src=\"//scripts.poll-maker.com/3012/scpolls.js\"></script>\r\n</div>\r\n</div>\r\n<div id=\"qp_all622271\" style=\"width: 100%;\">\r\n<div id=\"qp_main622271\" style=\"border-radius: 0px; margin-top: 20px; padding: 0.8em; background-color: #fff; font-family: \'Open Sans\', sans-serif, Arial; color: #000; border: 1px solid #DBD9D9; max-width: 100%;\">\r\n<div style=\"font-size: 2.5em; background-color: #f0f0f0; color: #000; font-family: \'Open Sans\', sans-serif, Arial;\">\r\n<div style=\"padding: 0.8em; line-height: 1.3em;\">Are we ready for circadian lighting in the office?</div>\r\n</div>\r\n<form id=\"qp_form622271\" style=\"display: inline; margin: 0px; padding: 0px;\" action=\"//www.poll-maker.com/results622271x4540b434-26\" method=\"post\" target=\"_blank\">\r\n<div style=\"padding: 0px;\"><input name=\"qp_d622271\" type=\"hidden\" value=\"42447.4905671226-42447.4905510485\" />\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622271\" type=\"radio\" value=\"1\" />Yes</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622271\" type=\"radio\" value=\"2\" />Office is not an appropriate application for circadian lighting at all.</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622271\" type=\"radio\" value=\"3\" />We need more case studies</span></div>\r\n</div>\r\n<div style=\"padding-left: 0px; min-height: 40px; clear: both;\"><a class=\"qp_btna\" style=\"float: left; width: 50%; max-width: 140px; box-sizing: border-box; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; -o-box-sizing: border-box; padding-right: 5px; text-decoration: none;\" href=\"#\"><input style=\"width: 100%; height: 40px; background-color: #684255; font-family: \'Open Sans\', sans-serif, Arial; font-size: 16px; color: #fff; cursor: hand; border: 0px; -webkit-appearance: none; border-radius: 0px;\" name=\"qp_b622271\" type=\"submit\" value=\"Vote\" /></a></div>\r\n<a id=\"qp_a622271\" style=\"float: right; font-family: Arial; font-size: 10px; color: #000000; text-decoration: none;\"></a></form>\r\n<div style=\"display: none;\">&nbsp;</div>\r\n</div>\r\n</div>\r\n<script src=\"//scripts.poll-maker.com/3012/scpolls.js\"></script>\r\n<div id=\"qp_all622282\" style=\"width: 100%;\">\r\n<div id=\"qp_main622282\" style=\"border-radius: 0px; margin-top: 20px; padding: 0.8em; background-color: #fff; font-family: \'Open Sans\', sans-serif, Arial; color: #000; border: 1px solid #DBD9D9; max-width: 100%;\">\r\n<div style=\"font-size: 2.5em; background-color: #f0f0f0; color: #000; font-family: \'Open Sans\', sans-serif, Arial;\">\r\n<div style=\"padding: 0.8em; line-height: 1.3em;\">What would be your optics choice for pedestrian scale post top luminaire?</div>\r\n</div>\r\n<form id=\"qp_form622282\" style=\"display: inline; margin: 0px; padding: 0px;\" action=\"//www.poll-maker.com/results622282xa9EFd67B-26\" method=\"post\" target=\"_blank\">\r\n<div style=\"padding: 0px;\"><input name=\"qp_d622282\" type=\"hidden\" value=\"42447.4962731416-42447.4962595875\" />\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622282\" type=\"radio\" value=\"1\" />Individual LED optics</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622282\" type=\"radio\" value=\"2\" />Diffuse lenses</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622282\" type=\"radio\" value=\"3\" />Segmented reflector</span></div>\r\n</div>\r\n<div style=\"padding-left: 0px; min-height: 40px; clear: both;\"><a class=\"qp_btna\" style=\"float: left; width: 50%; max-width: 140px; box-sizing: border-box; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; -o-box-sizing: border-box; padding-right: 5px; text-decoration: none;\" href=\"#\"><input style=\"width: 100%; height: 40px; background-color: #684255; font-family: \'Open Sans\', sans-serif, Arial; font-size: 16px; color: #fff; cursor: hand; border: 0px; -webkit-appearance: none; border-radius: 0px;\" name=\"qp_b622282\" type=\"submit\" value=\"Vote\" /></a></div>\r\n<a id=\"qp_a622282\" style=\"float: right; font-family: Arial; font-size: 10px; color: #000000; text-decoration: none;\"></a></form>\r\n<div style=\"display: none;\">&nbsp;</div>\r\n</div>\r\n</div>\r\n<script src=\"//scripts.poll-maker.com/3012/scpolls.js\"></script>\r\n<div id=\"qp_all622291\" style=\"width: 100%;\">\r\n<div id=\"qp_main622291\" style=\"border-radius: 0px; margin-top: 20px; padding: 0.8em; background-color: #fff; font-family: \'Open Sans\', sans-serif, Arial; color: #000; border: 1px solid #DBD9D9; max-width: 100%;\">\r\n<div style=\"font-size: 2.5em; background-color: #f0f0f0; color: #000; font-family: \'Open Sans\', sans-serif, Arial;\">\r\n<div style=\"padding: 0.8em; line-height: 1.3em;\">Will interior lighting with tunable CCT negatively affect building exterior?</div>\r\n</div>\r\n<form id=\"qp_form622291\" style=\"display: inline; margin: 0px; padding: 0px;\" action=\"//www.poll-maker.com/results622291xC66c66Bb-26\" method=\"post\" target=\"_blank\">\r\n<div style=\"padding: 0px;\"><input name=\"qp_d622291\" type=\"hidden\" value=\"42447.5123263848-42447.5123747707\" />\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622291\" type=\"radio\" value=\"1\" />Yes. It will create too much of light variations for the exterior.</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622291\" type=\"radio\" value=\"2\" />Depends on the building and tenant types.</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622291\" type=\"radio\" value=\"3\" />It will not affect anything</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622291\" type=\"radio\" value=\"4\" />It will make exterior more interesting</span></div>\r\n</div>\r\n<div style=\"padding-left: 0px; min-height: 40px; clear: both;\"><a class=\"qp_btna\" style=\"float: left; width: 50%; max-width: 140px; box-sizing: border-box; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; -o-box-sizing: border-box; padding-right: 5px; text-decoration: none;\" href=\"#\"><input style=\"width: 100%; height: 40px; background-color: #684255; font-family: \'Open Sans\', sans-serif, Arial; font-size: 16px; color: #fff; cursor: hand; border: 0px; -webkit-appearance: none; border-radius: 0px;\" name=\"qp_b622291\" type=\"submit\" value=\"Vote\" /></a></div>\r\n<a id=\"qp_a622291\" style=\"float: right; font-family: Arial; font-size: 10px; color: #000000; text-decoration: none;\"></a></form>\r\n<div style=\"display: none;\">&nbsp;</div>\r\n</div>\r\n</div>\r\n<script src=\"//scripts.poll-maker.com/3012/scpolls.js\"></script>\r\n<div id=\"qp_all622305\" style=\"width: 100%;\">\r\n<div id=\"qp_main622305\" style=\"border-radius: 0px; margin-top: 20px; padding: 0.8em; background-color: #fff; font-family: \'Open Sans\', sans-serif, Arial; color: #000; border: 1px solid #DBD9D9; max-width: 100%;\">\r\n<div style=\"font-size: 2.5em; background-color: #f0f0f0; color: #000; font-family: \'Open Sans\', sans-serif, Arial;\">\r\n<div style=\"padding: 0.8em; line-height: 1.3em;\">Do we have too many dimming protocols?</div>\r\n</div>\r\n<form id=\"qp_form622305\" style=\"display: inline; margin: 0px; padding: 0px;\" action=\"//www.poll-maker.com/results622305xF10Ff080-26\" method=\"post\" target=\"_blank\">\r\n<div style=\"padding: 0px; color: #fff;\"><input name=\"qp_d622305\" type=\"hidden\" value=\"42447.5298958357-42447.5298639616\" />\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622305\" type=\"radio\" value=\"1\" />Yes. Keeping 3-4 protocols would simplify design.</span></div>\r\n<div class=\"qp_a\" style=\"display: block; color: #6b6b6b; font-family: \'Open Sans\', sans-serif, Arial; font-size: 1.4em; line-height: 1.5; padding: 13px 8px 11px; margin: 10px 0px; clear: both;\"><span style=\"display: block; padding-left: 30px; cursor: inherit;\"><input style=\"float: left; width: 20px; margin-left: -25px; margin-top: 2px; padding: 0px; height: 20px;\" name=\"qp_v622305\" type=\"radio\" value=\"2\" />No. Having many different protocols serves industry well.</span></div>\r\n</div>\r\n<div style=\"padding-left: 0px; min-height: 40px; clear: both;\"><a class=\"qp_btna\" style=\"float: left; width: 50%; max-width: 140px; box-sizing: border-box; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; -o-box-sizing: border-box; padding-right: 5px; text-decoration: none;\" href=\"#\"><input style=\"width: 100%; height: 40px; background-color: #684255; font-family: \'Open Sans\', sans-serif, Arial; font-size: 16px; color: #fff; cursor: hand; border: 0px; -webkit-appearance: none; border-radius: 0px;\" name=\"qp_b622305\" type=\"submit\" value=\"Vote\" /></a></div>\r\n<a id=\"qp_a622305\" style=\"float: right; font-family: Arial; font-size: 10px; color: #000000; text-decoration: none;\"></a></form>\r\n<div style=\"display: none;\">&nbsp;</div>\r\n</div>\r\n</div>\r\n<script src=\"//scripts.poll-maker.com/3012/scpolls.js\"></script>', 'POLLS'),
(4, 'LightAZ Statistics', '<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">COLOR TEMPERATURE (CCT)</div>\r\n<p>&nbsp;</p>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_CCT_interior.png\" alt=\"Exterior LED Luminaire CCT Trends\" />\r\n<div class=\"stat-subtitle\">EXTERIOR LED LUMINAIRE CCT TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different CCT for&nbsp;Interior LED Luminaires over past years.</div>\r\n</div>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_CCT_exterior.png\" alt=\"Interior LED Luminaire CCT Trends\" />\r\n<div class=\"stat-subtitle\">INTERIOR LED LUMINAIRE CCT TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different CCT for&nbsp;Exterior LED Luminaires over past years.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">LED LUMINAIRES CRI</div>\r\n<p>&nbsp;</p>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_interior_cri.png\" alt=\"Exterior LED Luminaire CRI Trends\" />\r\n<div class=\"stat-subtitle\">EXTERIOR LED LUMINAIRE CRI TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different CRI for&nbsp;Interior LED Luminaires over past years.</div>\r\n</div>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_exterior_cri.png\" alt=\"Interior LED Luminaire CRI Trends\" />\r\n<div class=\"stat-subtitle\">INTERIOR LED LUMINAIRE CRI TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different CRI for&nbsp;Interior LED Luminaires over past years.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">HOURS MAINTENANCE. LM70.</div>\r\n<div class=\"apps-descr\">&nbsp;</div>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_lm70_interior.png\" alt=\"Interior LED Luminaire LM70 Trends\" />\r\n<div class=\"stat-subtitle\">INTERIOR LED LUMINAIRE LIFE HOURS LM70 TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp; of LM70 maintenance hours for interior LED luminaires over past years.</div>\r\n</div>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_lm70_exterior.png\" alt=\"Exterior LED Luminaire LM70 Trends\" />\r\n<div class=\"stat-subtitle\">EXTERIOR LED LUMINAIRE LIFE HOURS LM70 TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp; of LM70 maintenance hours for interior LED luminaires over past years.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">LED LUMINAIRES LUMEN PACKAGES.</div>\r\n<p>&nbsp;</p>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_lumen_interior.png\" alt=\"Interior LED Luminaire Lumen Packages Trends\" />\r\n<div class=\"stat-subtitle\">EXTERIOR LED LUMINAIRE LUMENS TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different Lumen packages for Interior LED Luminaires over past years.</div>\r\n</div>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_lumen_exterior.png\" alt=\"Exterior LED Luminaire Lumen Packages Trends\" />\r\n<div class=\"stat-subtitle\">INTERIOR LED LUMINAIRE LUMENS TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different Lumen packages for Exterior LED Luminaires over past years.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">LED LUMINAIRES EFFICACY.</div>\r\n<p>&nbsp;</p>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_efficacy_interior.png\" alt=\"Exterior LED Luminaire Efficacy Trends\" />\r\n<div class=\"stat-subtitle\">EXTERIOR LED LUMINAIRE EFFICACY TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different Efficacy for Interior LED Luminaires over past years.</div>\r\n</div>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_efficacy_exterior.png\" alt=\"Interior LED Luminaire Efficacy Trends\" />\r\n<div class=\"stat-subtitle\">INTERIOR LED LUMINAIRE EFFICACY TREND</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different Efficacy for Interior LED Luminaires over past years.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">CONTROLS AND DIMMING RANGES.</div>\r\n<p>&nbsp;</p>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_dimming_range.png\" alt=\"Exterior LED Luminaire CRI Trends\" />\r\n<div class=\"stat-subtitle\">DIMMING RANGE FOR LED LUMINAIRES</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different CRI for&nbsp;Interior LED Luminaires over past years.</div>\r\n</div>\r\n<div class=\"stat-left\"><img src=\"/images/stats/graph_dimming_type.png\" alt=\"Interior LED Luminaire CRI Trends\" />\r\n<div class=\"stat-subtitle\">TYPES OF DIMMING CONTROLS</div>\r\n&nbsp;\r\n<div class=\"stat-descr\">Graph represents weighted %&nbsp;of different CRI for&nbsp;Interior LED Luminaires over past years.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;Based on 4,500+ LED Luminaires families and more than 100,000 product variations.</p>', 'SSL LUMINAIRES STATISTICAL DATA 2011-2015'),
(5, 'Advertisement Opportunities', '<h2><span style=\"font-size: 16px;\"><span style=\"font-size: 24px;\">ADVERTISEMENT GUIDE</span></span></h2>\r\n<p>Welcome to Light<span style=\"color: #e67e23;\">AZ</span>.com, The largest and most comprehensive search engine in the professional lighting industry. Our platform is an indispensable resource for influential brand and product marketing, with daily exposure to lighting professionals who specify LED lighting across all project types and sizes.<br /><br /><strong>We offer four different banner programs.</strong> Our programs differ in the placement of the ad on our website and price.<br />For more information on our banner programs please send an email.</p>\r\n<p><img src=\"../../images/info/advertisement_image.jpg\" alt=\"\" /></p>\r\n<p>We provide excellent and refined exposure for advertisers. This is accomplished by delivering: <br />- Trusted and relevant content focused on specific markets<br />- High impact exposure &ndash; uncluttered advertisement<br />- Extensive reach among lighting designers, architects, engineers, specifiers and decision-makers who are actively seeking design solutions in a fast-moving industry</p>\r\n<p>Light<span style=\"color: #e67e23;\">AZ</span>.com delivers visibility and a constant presence of your brand and products, in a currently competitive and noisy business environment. It&rsquo;s vital for manufacturers to continue keeping their brand on top of designers, owners, and contractors\' minds, who are everyday purchase influencers. In addition, Light<span style=\"color: #e67e23;\">AZ</span>.com functions as a powerful statistical tool, that analyzes data, searches and clicks to provide valuable feedback to advertisers with extensive statistical information.&nbsp;</p>', 'ADVERTISE WITH LIGHTAZ'),
(6, 'Membership Opportunities', '<div class=\"apps-title\">&nbsp;</div>\r\n<div class=\"apps-title\"><span style=\"font-size: 24px;\">MANUFACTURER MEMBERSHIP GUIDE</span></div>\r\n<div class=\"apps-title\">&nbsp;</div>\r\n<div class=\"apps-title\">&nbsp;</div>\r\n<p>Welcome to Light<span style=\"color: #e67e23;\">AZ</span>.com. The largest and most comprehensive search engine in the professional lighting industry. In an ever-accelerating industry of more luminaires, more changes, and limited time in front of specifiers, specifiers will now quickly find and specify your luminaires with our comprehensive search engine within seconds.</p>\r\n<div class=\"membership-mid\">\r\n<div class=\"lft\">\r\n<p><span style=\"color: #e67e23;\">It is indisputable that being easy to find and easy to specify is essential to be competitive in the future.</span></p>\r\n<p><strong><span style=\"color: #e67e23;\">Your lighting products will be:</span></strong></p>\r\n<ul>\r\n<li>Accessible on the most comprehensive search engine in the lighting industry</li>\r\n<li>Easy to specify with our live product configurator with built-in logic</li>\r\n</ul>\r\n<p><strong><span style=\"color: #e67e23;\">You will be able to:</span></strong></p>\r\n<ul>\r\n<li>Increase traffic to your website. All luminaires will be linked to your product and spec pages on your website</li>\r\n<li>Showcase and promote your luminaires with project installation photos</li>\r\n<li>Access valuable industry data &amp; analytics, trends, and market potential through our personalized statistical tools</li>\r\n<li>Advertise on the most relevant platform in the lighting industry</li>\r\n<li>Communicate and monitor your product data directly through a personal dashboard</li>\r\n</ul>\r\n</div>\r\n<div class=\"rgt\">\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/DJnEg5z8dvI\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n</div>\r\n</div>\r\n<p><span style=\"text-decoration: underline;\">Note, that all implementation work of product data is taken care of by Light<span style=\"color: #e67e23; text-decoration: underline;\">AZ</span>.com. A preliminary secure webpage will be sent to verify product data before any data will be applied to the platform.<br /></span></p>\r\n<h2><strong><img src=\"../../images/info/membership_types.jpg\" alt=\"\" width=\"1271\" height=\"324\" /></strong></h2>\r\n<h2><strong>FAQ</strong></h2>\r\n<p><strong>What types of memberships do you offer?<br /></strong>We offer four different types of memberships; Entry, Pro, Pro+, and Enterprise. The difference lies in the price, different levels of analytics, media packages, advertisement discount, and customized features.</p>\r\n<p><strong><span style=\"font-family: Muli, sans-serif; font-size: 13px; font-style: normal;\">Who can become a member?<br /></span></strong>Manufacturers should have a product line of LED Luminaires suitable for North America Projects, with products certified or listed with reputable testing organizations such as UL, ETL, CSA.</p>\r\n<p>&nbsp;</p>', 'MANUFACTURER PARTICIPATION AND MEMBERSHIP OPTIONS');
INSERT INTO `pages_html` (`page_id`, `page_name`, `page_html`, `heading`) VALUES
(7, 'Privacy Policy', '<h2><br />PRIVACY POLICY</h2>\r\n<p><span>Effective Date: September 1st, 2019</span></p>\r\n<p><strong>SCOPE</strong><br />This Privacy Policy (&ldquo;Policy&rdquo;) describes how LightAZ, Inc. (&ldquo;LightAZ&rdquo;) treats personal information on our websites where the Policy is located (the &ldquo;Platform&rdquo;).&nbsp;<br />This Platform is operated in the United States and Canada and intended for use by individuals who are located in those countries.</p>\r\n<p><strong>TYPES OF INFORMATION WE COLLECT</strong><br />We collect information to provide better services for our users. Here are some examples of the information we may collect:</p>\r\n<ul>\r\n<li><strong>Contact Information.</strong> For example, we may collect your name, mailing address, telephone number, and email address.</li>\r\n<li><strong>Professional Information.</strong> We may collect information about your company. This may include the name of your company. It may also include your job title and the type of company you work for.</li>\r\n<li><strong>Information You Submit or Post.</strong> We may collect information when you send us a message through the &ldquo;Contact Us&rdquo; page or similar features on our Platform. This may also include any information or content that you post in a public space on our Platform, to your project, or to the projects of others. This may also include information when you enter a promotion.</li>\r\n<li><strong>Demographic/Geographic Information.</strong> For example, we may collect information like your age or zip code. We might collect this when you create an account or enter a promotion.</li>\r\n<li><strong>Device Information.</strong> For example, we may collect the type of device you use to access our Platform. We may also collect your device identifier, IP address or mobile operating system.</li>\r\n<li><strong>Ac<span style=\"font-family: Muli, sans-serif; font-size: 13px; font-style: normal;\">count Information</span>.</strong> Certain portions of the Platform allow you to create a user account. In connection with that account, we may collect your username and password.</li>\r\n<li><strong>Other Information.</strong> If you use our website, we may collect information about the browser you are using. We might look at what site you came from, or what site you visit when you leave us. We may also collect what products or pages you have viewed on the Platform.</li>\r\n</ul>\r\n<p><strong>HOW WE COLLECT YOUR INFORMATION</strong><br />We collect your information in different ways. Below are some examples of how we may collect your information.</p>\r\n<ul>\r\n<li><strong>Directly from You.</strong> For example, when you register for an account, enter a promotion, or submit information to the Platform. We also collect information from you when you interact with the Platform, such as creating a project, liking certain products, or submitting requests to manufacturer representatives. This also includes when you interact with our social media platforms.</li>\r\n<li><strong>Passively.</strong> For example, when you visit and navigate our Platform on any device. We may also collect information about users over time and across different websites and devices when you use the Platform.</li>\r\n<li><strong>From Third Parties</strong>. We may receive information about you from other sources. For example, this may include receiving information from our business partners, including analytics vendors. This may also include when another user shares their project with you or adds you to a project.</li>\r\n<li><strong>By Combining Information.</strong> For example, we may combine information that we collect offline with information we collect through our Platform. We may also combine information we collect about you from the different devices you use to access our Platform.</li>\r\n</ul>\r\n<p><strong>HOW WE USE YOUR INFORMATION</strong><br />Examples of how we may use your information include:</p>\r\n<ul>\r\n<li><strong>To Run and Improve Our Platform and Business.</strong> We may use your information to make our Platform and business better. We may also use your information to provide you with information about our business.</li>\r\n<li><strong>To Respond to Your Requests or Questions.</strong> This may include responding to your feedback. This may also include notifying you if you win a promotion.</li>\r\n<li><strong>To Determine Your Eligibility</strong>. We may use your information to verify your identity or determine your eligibility for promotions. For example, this may include verifying your age and jurisdiction of residence.</li>\r\n<li><strong>To Understand Your Interests.</strong> For example, we may use your information to better understand what products or projects you have viewed, shared, or saved.</li>\r\n<li><strong>To Communicate with You</strong>. We may communicate with you about your account or our relationship. We may also contact you about this Policy or our Platform terms and conditions.</li>\r\n<li><strong>For Marketing Purposes</strong>. We may provide you with information about our company and our business initiatives. We and our partners may engage in interest-based advertising using information gathered across multiple platforms.</li>\r\n<li><strong>For Security Purposes</strong>. This could include protecting our company and consumers who use our products and services. It may also include protecting our Platform.</li>\r\n<li><strong>As Otherwise Permitted by Law or As We May Notify You.</strong></li>\r\n</ul>\r\n<p><strong>HOW WE SHARE YOUR INFORMATION</strong><br />We may share your information in the following ways:</p>\r\n<ul>\r\n<li><strong>Internally.</strong> We may share your information with our parent, subsidiary, and affiliated entities.</li>\r\n<li><strong>With Our Service Providers.</strong> We may share your information with third parties who perform services on our behalf. For example, this may include companies that send emails on our behalf, help us implement promotions, or help us run our Platform.</li>\r\n<li><strong>With Other Platform Users.</strong> For example, we may share your information if you choose to make your project visible to other users. We may also share your information when you invite other users to view or modify your project.</li>\r\n<li><strong>With Our Business Partners.</strong> We may share your information with our business partners. For example, this may include our advertising partners.</li>\r\n<li><strong>With Any Successors to All or Part of Our Business.</strong> For example, if we merge with, acquires or is acquired, or sells part of its business to another entity. This may include an asset sale, corporate reorganization or other change of control.</li>\r\n<li><strong>To Comply with the Law or To Protect Ourselves.</strong> For example, this could include responding to a court order or subpoena. It could also include sharing information if a government agency or investigatory body requests. We might share information when we are investigating potential fraud. This may include fraud during a promotion or sweepstakes. We may also share information if you are the winner of sweepstakes or other contest with anyone who requests a winner&rsquo;s list.</li>\r\n<li><strong>For Other Reasons We May Describe to You.&nbsp;</strong></li>\r\n</ul>\r\n<p><strong>CHILDREN UNDER 13</strong><br />The Platform where this Policy is located is meant for adults. We do not knowingly collect personally identifiable data from persons under the age of 13 and strive to comply with the provisions of COPPA (The Children&rsquo;s Online Privacy Protection Act). If you are a parent or legal guardian and think your child under 13 has provided us with information, please contact us at <span style=\"color: #e67e23;\">contact.lightaz@lightaz.com</span>. You can also write to us at the address listed at the end of this website Policy. Please mark your inquiries &ldquo;COPPA Information Request.&rdquo; Parents, you can learn more about how to protect children\'s privacy online <a href=\"https://www.consumer.ftc.gov/articles/0031-protecting-your-childs-privacy-online\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #5896f4;\"><span style=\"color: #e67e23;\">here</span></span></a>.</p>\r\n<p><strong>CHOICES REGARDING YOUR INFORMATION</strong><br />You have certain choices about how we use your information. Certain choices you make are browser and device-specific.</p>\r\n<p><span style=\"text-decoration: underline;\">Marketing Communications:</span><strong><br /></strong>You can opt-out of receiving our marketing communications. Note that you will still receive transactional messages from us, including information about your account and responses to your inquiries.&nbsp;<br /><br /><span style=\"text-decoration: underline;\">Cookies &amp; Other Tracking Technologies:<br /></span>Your browser may give you the ability to control cookies or other tracking tools. How you do so depend on the type of tool. Certain browsers can be set to reject browser cookies. To control flash cookies, which we may use on certain websites from time to time, you can go <span style=\"color: #e67e23;\"><a style=\"color: #e67e23;\" href=\"http://www.macromedia.com/support/documentation/en/flashplayer/help/settings_manager07.html\" target=\"_blank\" rel=\"noopener\">here</a></span>. Why? Because flash cookies cannot be controlled through your browser settings.&nbsp;</p>\r\n<p><span style=\"text-decoration: underline;\">Our Do Not Track Policy:<br /></span>- Some browsers have &ldquo;do not track&rdquo; features that allow you to tell a website not to track you. These features are not all uniform. We do not currently respond to those signals.<span style=\"font-size: 13px;\"> If you block cookies, certain features on our sites may not work. If you block or reject cookies, not all of the tracking described here will stop.<br /></span><span style=\"font-size: 13px;\">- Options you select are browser and device-specific.</span></p>\r\n<p><strong>SECURITY</strong><br />The Internet is not 100% secure. We cannot promise that your use of our Platform will be completely safe. We encourage you to use caution when using the Internet. We use reasonable means to safeguard personal information under our control. A user id and a password are needed to access certain areas of our Platform. It is your responsibility to protect your username and password.</p>\r\n<p><strong>STORAGE OF INFORMATION</strong><br />Information we maintain may be stored in or outside of the United States. If you live outside of the United States, you understand and agree that we may transfer your personal information to the United States. This Platform is intended for use in the United States and is subject to the laws of the United States, which may not provide the same level of protection as those in your own country.</p>\r\n<p><strong>LINKS</strong><br />Our Platform may contain links to other third-party sites that are not governed by this Policy. If you click on a link to a third-party site, you will be taken to a site we do not control. We are not responsible for the privacy practices used by third-party sites. We suggest that you read the privacy policies of those sites carefully. We are not responsible for these third-party sites.</p>\r\n<p><strong>HOW TO CONTACT US</strong><br />If you have any questions, comments or concerns with respect to our privacy practices or this Policy, or wish to update your information, please feel free to contact us at <span style=\"color: #e67e23;\">contact.lightaz@lightaz.com</span> or by telephone at <span style=\"color: #e67e23;\">(312)-380-0585</span>. You may also write to us at the following address:<br /><span style=\"font-size: 13px;\"><br /><span style=\"color: #000000;\">20 W Kinzie St, 17th floor</span><br /></span><span style=\"color: #000000;\"><span style=\"font-size: 13px;\">Chicago, IL, 60654<br /></span><span style=\"font-size: 13px;\">Re: LightAZ Privacy Policy</span></span></p>\r\n<p><strong>CHANGES IN POLICY</strong><br />From time to time, we may change our Policy. We will notify you of any material changes to our Policy as required by law. We will also post an updated copy on our Platform. Please check our Platform periodically for updates.</p>\r\n<p>&nbsp;</p>', 'PRIVACY POLICY. USER AGREEMENT'),
(8, 'Industry', '', 'Change in Backend (defaults to page name)'),
(9, 'FAQ', '<h2>USER GUIDE</h2>\r\n<p>Welcome to Light<span style=\"color: #e67e23;\">AZ</span>.com &ndash; the largest and most comprehensive search engine in the professional lighting industry.&nbsp;With Light<span style=\"color: #e67e23;\">AZ</span>.com, users can quickly find, select and specify architectural lighting products, build lighting schedules, create specification packages, and communicate with agents. Be able to search, specify, and connect. All in one platform.</p>\r\n<ul class=\"user-guide-videos\">\r\n<li>\r\n<div class=\"video-title\">Introduction to LightAZ.com</div>\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/4FWd1p7Nwi4\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"video-descr\">Get familiar with all the possibilities LightAZ.com offer, learn how to optimize the search functions, compare products from different manufacturers or print out spec. sheets in seconds.</div>\r\n</li>\r\n<li>\r\n<div class=\"video-title\">How to build a product SKU</div>\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/0avVupTlCsg\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"video-descr\">This video focus on how the innovative SKU configurator saves users valuable time creating SKU numbers. In addition, the video touches the built-in communication tool between users and reps/colleagues/clients etc.</div>\r\n</li>\r\n<li>\r\n<div class=\"video-title\">Create a project in LightAZ.com</div>\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/FLRNo7-rs44\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"video-descr\">Learn the framework of how to build a project on LightAZ.com, its easy and fast and with one click you can have a lighting schedule on excel, or a spec. package with all the PDF&rsquo;s ready to print, save or send.</div>\r\n</li>\r\n</ul>\r\n<div class=\"user-guide-mid\">\r\n<div class=\"lft\">\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/RuhbXAqI0vE\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n</div>\r\n<div class=\"rgt\">\r\n<div><span style=\"color: #000000;\"><strong>With Light<span style=\"color: #e67e23;\">AZ</span>.com you will experience:</strong></span><br /><br /></div>\r\n<ul>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Advanced search engine:</span></strong> Try our 20+ search parameters</span></li>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Intelligent configurator:</span></strong> Build your preferred product SKU with ease</span></li>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">3-name spec:</span></strong> Create a 3-name spec in seconds</span></li>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Manage projects:</span> </strong>Build and create a spec package, export to Excel and more</span></li>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Share:</span> </strong>Share information with clients, colleagues and agents instantly</span></li>\r\n<li style=\"font-size: 13px; outline-style: none; outline-width: initial;\"><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Easy comparison:</span></strong>&nbsp;Select and compare luminaries instantly</span></li>\r\n<li style=\"font-size: 13px; outline-style: none; outline-width: initial;\"><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Save:</span></strong>&nbsp;Save favorite products for easy re-use</span></li>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Project Gallery:</span> </strong>Find inspiration from all over the world</span></li>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">New products:</span></strong> Explore new products from leading manufacturers</span></li>\r\n<li><span style=\"color: #000000;\"><strong><span style=\"color: #e67e23;\">Events and trends:</span></strong> Stay updated on professional events and rising trends</span></li>\r\n</ul>\r\n<p><em>Built for desktop and mobile devices.</em><br /><span style=\"font-size: 13px;\">Feel free to contact us for further information or questions.<br /><br /></span><span style=\"color: #e67e23;\"><strong style=\"font-size: 13px;\"><span style=\"font-size: 20px;\">ENJOY!</span></strong></span></p>\r\n</div>\r\n</div>\r\n<p><strong style=\"font-size: 20px;\">FAQ</strong></p>\r\n<p><strong>Do you sell any product?</strong> <br /><small></small>We do not sell any products. LightAZ.com is a search portal that allows you to quickly find LED luminaire and connect with manufacturers or sales representative agencies.</p>\r\n<p><strong>Can you help me with product technicalities or design questions?<br /></strong>We do not provide any consulting or product support services. Please contact the manufacturer or representative agency for information.</p>\r\n<p><strong>I\'m finding information that is not correct.<br /></strong>We are striving to provide the most current and correct information available. If you find incorrect information, please send your comments at <span style=\"color: #e67e23;\">contact.lightaz@lightaz.com</span>.</p>\r\n<p><strong>I found a photo that was published without my permission.<br /></strong><small></small>Most of the Project photos are provided to us by manufacturers or designers. If you would like us to remove a picture, product or project, please contact us via <span style=\"color: #e67e23;\">contact.lightaz@lightaz.com</span>. Please provide proof of your rights as well as your contact information and full name. If we find your claim to be valid, we will contact you before taking any action.</p>\r\n<p><strong>I was searching for 2,000 Lm fixture that can be dimmed with 0-10v dimmer to 0.1%, but the description for the filtered fixture has 500 - 4,000 Lm. and also other dimming options. Is it a mistake?<br /></strong>This is the correct result. The description of the fixture will always show a full range of luminaire options, but the search result will only be based on available combinations of parameters.</p>\r\n<p><strong>I have a suggestion or comment on how to improve your search and website.<br /></strong>We appreciate any meaningful suggestions or comments. Please send your comments to <span style=\"color: #e67e23;\">contact.lightaz@lightaz.com</span>.&nbsp;</p>\r\n<p><strong>I would like to place an advertisement on your website.<br /></strong>We would be glad to have you on board. Please visit <a href=\"../../advertisement-opportunities\" target=\"_blank\" rel=\"noopener\">Advertisement Opportunities</a> for details. Please submit your advertisement proposal to <span style=\"color: #e67e23;\">contact.lightaz@lightaz.com</span>.</p>\r\n<p><strong>We are an architectural firm and we would like to publish some finished projects on LightAZ.com. Is it possible to publish our projects with links to our company website?<br /></strong>Yes, we would be glad to add your projects to our Projects Library.&nbsp;<span style=\"font-family: Muli, sans-serif; font-size: 13px; font-style: normal; font-weight: 300;\">All projects are subject to our review, which could take up to 2 weeks to process. </span>We reserve the right to reject any project that we will find not suitable for Light<span style=\"color: #e67e23;\">AZ</span>.com. Please submit your subject to <span style=\"color: #e67e23;\">contact.lightaz@lightaz.com</span>.</p>\r\n<p>&nbsp;</p>', 'USER GUIDE'),
(10, 'TOS', '<h2><br />Terms of services</h2>\r\n<p>Your use of the web sites on which these terms reside (collectively, the &ldquo;Site&rdquo;), and the features at this Site are subject to these Terms of Use (the &ldquo;Terms&rdquo;), which we may update from time to time. <br /><br /><span style=\"text-decoration: underline;\"><br /><span style=\"color: #e67e23; text-decoration: underline;\">Please read these Terms carefully before using this Site.<br /><br /></span></span><br />The Site is owned or controlled by LightAZ, Inc. (&ldquo;Company&rdquo;). This Site is intended for and applicable only for residents of the United States and Canada and at least the age of majority in their jurisdiction, or older. If you are from another jurisdiction or under the age of majority in your jurisdiction, you may not use this Site. By accessing this Site in any way, including, without limitation, browsing this Site, using any information, and/or submitting information to Company, you agree to and are bound by the terms, conditions, policies, and notices contained on this page (the &ldquo;Terms&rdquo;), including, but not limited to, conducting this transaction electronically, disclaimers of warranties, damage and remedy exclusions and limitations, binding arbitration, and a choice of Illinois law.</p>\r\n<p>From time to time we may update this Site and these Terms. Your use of this Site after we post any changes to these Terms constitutes your agreement to those changes. You agree to review these Terms periodically to ensure that you are familiar with the most recent version. Company may, in its sole discretion, and at any time, discontinue this Site or any part thereof, with or without notice, or may prevent your use of this Site with or without notice to you. You agree that you do not have any rights in this Site and that Company will have no liability to you if this Site is discontinued or your ability to access the Site or any content you may have posted on the Site is terminated.</p>\r\n<p><strong>Binding Arbitration<br /></strong>You and Company agree that any controversy or claim arising out of or relating to the Site, use of the Site, this Agreement and/or the <span style=\"color: #e67e23;\"><a style=\"color: #e67e23;\" href=\"../../privacy-policy\" target=\"_blank\" rel=\"noopener\">Privacy Policy</a> </span>shall be settled by binding arbitration in a location determined by the arbitrator as set forth herein (provided that such location is reasonably convenient for you in your hometown area), or at such other location as may be mutually agreed upon by the parties, in accordance with the applicable procedural rules set forth in the then prevailing Comprehensive Arbitration Rules and Procedures of JAMS (&ldquo;JAMS Rules and Procedures&rdquo;), and judgment upon the award rendered by the arbitrator(s) may be entered in any court having jurisdiction thereof. The JAMS Rules and Procedures are available at <span style=\"color: #e67e23;\"><a style=\"color: #e67e23;\" href=\"https://www.jamsadr.com/\" target=\"_blank\" rel=\"noopener\">www.jamsadr.com</a></span> or by calling <span style=\"color: #e67e23;\">(800)-352-5267</span>. The arbitrator shall be selected pursuant to the JAMS Rules and Procedures. Alternatively, you may assert your claims in small claims court in accordance with the terms of this Agreement if your claims qualify and so long as the matter remains in such court and advances only on an individual (non-class, non-representative) basis. The arbitrator shall apply Illinois law consistent with the Federal Arbitration Act and applicable statutes of limitations and shall honor claims of privilege recognized at law. If you initiate arbitration against Company, you will not be responsible for professional fees for the arbitrator&rsquo;s services or any other JAMS fees. If Company initiates arbitration against you, Company will pay for the arbitrator&rsquo;s services and any other JAMS fees associated with the arbitration. If any part of this arbitration provision is deemed to be invalid, unenforceable or illegal (other than that claims will not be arbitrated on a class or representative basis), or otherwise conflicts with the rules and procedures established by JAMS, then the balance of this arbitration provision shall remain in effect and shall be construed in accordance with its terms as if the invalid, unenforceable, illegal or conflicting provision were not contained herein. If, however, the portion that is deemed invalid, unenforceable or illegal is that claims will not be arbitrated on a class or representative basis, then the entirety of this arbitration provision shall be null and void, and neither claimant nor Company shall be entitled to arbitrate their dispute.<br /><span style=\"text-decoration: underline;\"><br />THE ARBITRATION OF DISPUTES PURSUANT TO THIS PARAGRAPH SHALL BE IN YOUR INDIVIDUAL CAPACITY, AND NOT AS A PLAINTIFF OR CLASS MEMBER IN ANY PURPORTED CLASS OR REPRESENTATIVE PROCEEDING. THE ARBITRATOR MAY NOT CONSOLIDATE OR JOIN THE CLAIMS OF OTHER PERSONS OR PARTIES WHO MAY BE SIMILARLY SITUATED.<br /><br />BY AGREEING TO THE ARBITRATION OF DISPUTES AS SET FORTH HEREIN, YOU AGREE THAT YOU ARE WAIVING YOUR RIGHT TO A JURY TRIAL AND LIMITING YOUR RIGHT TO APPEAL AND YOU UNDERSTAND THAT YOU ARE WAIVING YOUR RIGHTS TO OTHER AVAILABLE RESOLUTION PROCESSES, SUCH AS A COURT ACTION. &nbsp;DO NOT USE THIS SITE IF YOU DO NOT AGREE TO THE FOREGOING BINDING ARBITRATION PROVISIONS.</span></p>\r\n<p><strong>Personal Information</strong><br />On certain areas of our Site, you may be given the ability to provide us with personally identifiable information. Please read our <span style=\"color: #e67e23;\"><a style=\"color: #e67e23;\" href=\"../../privacy-policy\" target=\"_blank\" rel=\"noopener\">Privacy Policy</a></span>&nbsp;for more information about our information collection, use and sharing practices.&nbsp;</p>\r\n<p><strong>Display of Products<br /></strong>Through the Site, you may be able to view products, ordering codes (SKUs) and spec sheets (&ldquo;Products&rdquo;) that are available via third-party websites or platforms. The Company provides this information solely for informational purposes and the reproduction of any images, descriptions, specifications, prices, or information relating to any Product shall not constitute an offer for sale of such Product. All descriptions, images, features, specifications, products, and prices of Products are subject to change at any time without notice. Company strives to display as accurately as possible the descriptions, specifications, and features of the products shown on the Site, including, for example, product colors and dimensions; however, Company cannot and does not guarantee that such descriptions, specifications or features, or your screen&rsquo;s display of any color, will be accurate. The inclusion of any Products on the Site does not imply or warrant that these Products will be available. You are responsible for verifying all Product information with manufacturers, and the Company shall have no liability with respect to any Product information posted or submitted to the Site.</p>\r\n<p><strong>Company Content</strong><br />Content on this Site that is provided by Company or its licensors, including certain graphics, photographs, images, screenshots, text, digitally downloadable files, trademarks, logos, product and program names, slogans, and the compilation of the foregoing (&ldquo;Company Content&rdquo;) is the property of Company and its licensors, and is protected in the U.S. and internationally under trademark, copyright, and other intellectual property laws.&nbsp;</p>\r\n<p>You agree not to download, display or use any Company Content located on the Site for use in any publications, in public performances, on websites other than this Site for any other commercial purpose, in connection with products or services that are not those of Company, in any other manner that is likely to cause confusion among consumers, that disparages or discredits Company and/or its licensors, that dilutes the strength of Company&rsquo;s or its licensor&rsquo;s property, or that otherwise infringes Company&rsquo;s or its licensors&rsquo; intellectual property rights. You further agree to in no other way misuse any Company Content or third-party content that appears on this Site.&nbsp;</p>\r\n<p><strong>Trademarks</strong><br />The trademarks, service marks, trade dress, and logos (collectively the &ldquo;Trademarks&rdquo;) used and displayed on this Site are registered and unregistered Trademarks of Company, its licensors, and others. Nothing on this Site should be construed as granting, by implication, estoppel or otherwise, any license or right to use any Site displayed on the Platform, without the prior written permission of the Site owner. All Sites not owned by Company that appear on the Site are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored by the Company.</p>\r\n<p><strong>Third-party brands and products<br /></strong>This Site may contain images and references to third-party brands, products, and services that are uploaded by Company or users of the Site. This may include images and references that are not owned or controlled by Company. Such content may contain Trademarks of their respective owners. The Site&rsquo;s display of third-party brands, products, and services does not imply any endorsement, any sponsorship, affiliation or association with the third party or its brands, products, or services, nor does it imply that you or the Company are authorized to use any trade name, trademark, logo, legal or official seal or copyrighted symbol that may be reflected in the uploaded content on the Platform.</p>\r\n<p><strong>Use of the Site and Posting Policy<br /></strong>The following requirements apply to your use the Site:<br />(a) you will not use any electronic communication feature of the Site for any purpose that is unlawful, tortious, abusive, intrusive on another&rsquo;s privacy, harassing, libelous, defamatory, embarrassing, obscene, threatening, or hateful; (b) you will not upload, post, reproduce, or distribute any information, software, or other material protected by copyright or any other intellectual property right (as well as rights of publicity and privacy) without first obtaining the permission of the owner of such rights; (c) you will not collect or store personal data about other users; (d) you will not use the Site for any commercial purpose not expressly approved by Company in writing; (e) you will not upload, post, email, or otherwise transmit any advertising or promotional materials or any other form of solicitation or unauthorized communication; (f) you will not upload, post, email, or otherwise transmit any material that contains viruses or any other computer code, files, or programs which might interrupt, limit, or interfere with the functionality of any computer software or hardware or telecommunications equipment.&nbsp;</p>\r\n<p>From time to time on certain areas of our Site, you may be able to submit photos, written posts and certain other materials (&ldquo;Your Data&rdquo;). By using these features, you agree that you will not post any content that is unlawful, harmful, tortious, defamatory, libelous, obscene, invasive of the privacy of another person, threatening, harassing, abusive, hateful, racist, infringing, pornographic, violent or otherwise objectionable or inappropriate as determined by Company; that you will not post any content that contains personal information about any individual, violates the privacy/publicity of any other individual or entity, or anything that you are under a contractual obligation to keep private or confidential; that you will not impersonate any person or organization, including without limitation, the personnel of Company, or misrepresent an affiliation with another person or organization; you will not post any content that contains viruses, corrupted files, or any other similar software or programs that may adversely affect the operation of the Site, or feature of the Site. You further understand and agree that you have no ownership rights in materials you submit to us, to any account you may have with us, or other access to the Site or features therein. Company may cancel your account and delete all Your Data associated with your account at any time, and without notice, if Company deems that you have violated these Terms, the law, or for any other reason. Company assumes no liability for any information removed from our Site and reserves the right to permanently restrict access to the Site or a user account.</p>\r\n<p>By displaying, publishing, or otherwise posting any Your Data on or through the Site, you hereby grant to Company a non-exclusive, sub-licensable, worldwide, fully-paid, royalty-free license to use, modify, publicly perform, publicly display, reproduce, and distribute such Your Data in any and all media now known or hereinafter developed without the requirement to make payment to you or to any third party or the need to seek any third party permission. This license includes the right to host, index, cache, distribute, and tag any Your Data, as well as the right to sublicense Your Data to third parties, including other users, for use on other media or platforms known or hereinafter developed, such as for use on mobile phones, in video or music software computer programs. You continue to retain all ownership rights in your Your Data, and you continue to have the right to use your Your Data in any way you choose, subject to these Terms and the license described herein. You represent and warrant that you own the content submitted, displayed, published or posted by you on the Site and otherwise have the right to grant the license set forth herein, and the displaying, publishing or posting of any content you submit, and our use thereof does not and will not violate the privacy rights, publicity rights, copyrights, trademark rights, patents, contract rights or any other intellectual property rights or other rights of any person or entity.</p>\r\n<p>You agree to indemnify and hold Company, its parents, subsidiaries, officers, employees, and website contractors and each of their officers, employees and agents harmless from any claims, damages and expenses, including reasonable attorneys&rsquo; fees and costs, related to your violation of these Terms, including the Posting Policy, or any violations thereof by your dependents or which arises from the use of Your Data you submitted, posted, or otherwise provided to Company or this Site.&nbsp;</p>\r\n<p><strong>Your Account<br /></strong>Certain areas of the Site may require registration or may otherwise ask you to provide information to participate in certain features or access certain content. If you elect not to provide such information, you may not be able to access certain content or participate in certain features of the Site or any features at all. If the Site requires you to create an account or otherwise submit information, you agree that you will provide accurate and complete information for your user account; that you will not impersonate a third party in your communications with Company; that you will only submit information about yourself; and that you will otherwise comply with these Terms, including the Posting Policy section of this Agreement. It is your responsibility to maintain the currency, completeness, and accuracy of your registration data, and any loss caused by your failure to do so is your responsibility. You may not authorize any other person or entity to use your account or to access restricted or protected content or features available at the Company Site. Creating an account or opting in to receive notifications or offers does not guarantee the receipt of any such messages or the availability to you of any promotional offer.</p>\r\n<p>You are solely responsible for the activity that occurs on your account, including all transactions and other activities undertaken with your device and any stored payment card, whether authorized or unauthorized. You must keep your user account, username, and password secure. You must notify Company immediately of any breach of security or unauthorized use of your account. You further agree not to email, post, or otherwise disseminate any user ID, password, or other information which provides you access to the Site. Company is not liable for any loss that you may incur as a result of someone else using your password or account, either with or without your knowledge. Company shall not be responsible for any losses arising out of the loss or theft of user information transmitted from or stored on a computer or device or from unauthorized or fraudulent transactions associated with the Site.</p>\r\n<p>You understand that you have no ownership rights in your account or other access to the Site or features therein. Company may terminate your access to the Site, cancel your account and/or delete all information associated with your account, including any materials you may have submitted to Company, at any time, and without notice, for any reason, including if Company deems that you have violated these Terms, the law, or for any other reason. Company assumes no liability for any information removed from our Site and reserves the right to permanently restrict access to the Site or a user account.</p>\r\n<p><strong>Additional Terms<br /></strong>You understand that certain offers, services, and features that may be available on the Platform may be subject to additional specific terms and conditions. This may include, but is not limited to, contests and sweepstakes, or other promotions. In the event of any conflict between these Terms and any such specific terms and conditions, the specific terms and conditions will control.</p>\r\n<p><strong>Representations, and Limitations of Liability<br /></strong>Company makes no representations about the reliability of the features of this Site, the Content, Your Data, or any other Site feature, and disclaims all liability in the event of any service failure. You acknowledge that any reliance on such material or systems will be at your own risk. Company makes no representations regarding the amount of time that any Content or Your Data will be preserved.&nbsp;</p>\r\n<p>Company does not endorse, verify, evaluate or guarantee any information provided by users and nothing shall be considered as an endorsement, verification or guarantee of any Your Data. You shall not create or distribute information, including but not limited to advertisements, press releases or other marketing materials, or include links to any sites which contain or suggest an endorsement by Company without the prior review and written approval of Company.&nbsp;</p>\r\n<p><span style=\"text-decoration: underline;\">THIS SITE AND ALL INFORMATION PROVIDED ON THE SITE IS PROVIDED ON AN &ldquo;AS IS, AS AVAILABLE&rdquo; BASIS. NO WARRANTIES, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THOSE OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE, ARE MADE WITH RESPECT TO THIS SITE OR ANY INFORMATION OR SOFTWARE THEREIN OR ANY THIRD PARTY PRODUCT. UNDER NO CIRCUMSTANCES, INCLUDING NEGLIGENCE, SHALL COMPANY BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, PUNITIVE, OR CONSEQUENTIAL DAMAGES (COLLECTIVELY, &ldquo;DAMAGES&rdquo;) THAT RESULT FROM THE USE OF OR INABILITY TO USE THIS SITE OR ANY THIRD PARTY PRODUCT, NOR SHALL COMPANY BE RESPONSIBLE FOR ANY DAMAGES WHATSOEVER THAT RESULT FROM MISTAKES, OMISSIONS, INTERRUPTIONS, DELETION OF FILES, ERRORS, DEFECTS, DELAYS IN OPERATION OR TRANSMISSION, OR ANY FAILURE OF PERFORMANCE WHETHER OR NOT CAUSED BY EVENTS BEYOND COMPANY&rsquo;S REASONABLE CONTROL, INCLUDING BUT NOT LIMITED TO ACTS OF GOD, COMMUNICATIONS LINE FAILURE, THEFT, DESTRUCTION, OR UNAUTHORIZED ACCESS TO THIS SITE&rsquo;S RECORDS, PROGRAMS, OR SERVICES. UNDER NO CIRCUMSTANCES, INCLUDING BUT NOT LIMITED TO A NEGLIGENT ACT, WILL COMPANY OR ITS AFFILIATES OR AGENTS BE LIABLE FOR ANY DAMAGE OF ANY KIND THAT RESULTS FROM THE USE OF, OR THE INABILITY TO USE, THE SITE, ANY INFORMATION PROVIDED THROUGH THE SITE OR ANY THIRD PARTY PRODUCT, EVEN IF COMPANY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. &nbsp;SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY FOR INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES; AS A RESULT, THE ABOVE LIMITATION OR EXCLUSION MAY NOT APPLY TO YOU AND THE FOREGOING PARAGRAPH SHALL NOT APPLY TO A RESIDENT OF NEW JERSEY TO THE EXTENT DAMAGES TO SUCH NEW JERSEY RESIDENT ARE THE RESULT OF COMPANY&rsquo;S NEGLIGENT, FRAUDULENT OR RECKLESS ACT(S) OR INTENTIONAL MISCONDUCT.&nbsp;</span></p>\r\n<p><strong>Third-Party Websites<br /></strong>This Site may hyperlink to sites not maintained by or related to Company. Hyperlinks are provided as a service to users and are not sponsored by or affiliated with this Site or Company, and Company makes no representations or warranties about the content, completeness, or accuracy of those third-party sites. Information you submit at a third-party site accessible from this Site is subject to the terms of that site&rsquo;s privacy policy, and Company has no control over how your information is collected, used, or otherwise handled.&nbsp;</p>\r\n<p><strong>Miscellaneous<br /></strong>Both you and Company acknowledge and agree that no partnership is formed and neither of you nor Company has the power or the authority to obligate or bind the other.&nbsp;</p>\r\n<p>These Terms will be governed by and construed in accordance with the internal laws of Illinois without regard to conflicts of laws principles. By using this site, you hereby agree that any action to enforce any arbitration award and any other disputes (if any) regarding these Terms that are not subject to arbitration will be subject to the courts located in Cook County, Illinois.&nbsp;</p>\r\n<p><span style=\"text-decoration: underline;\">YOU AGREE THAT, TO THE EXTENT PERMITTED BY APPLICABLE LAW, ANY AND ALL DISPUTES, CLAIMS, AND CAUSES OF ACTION ARISING OUT OF OR CONNECTED WITH THIS SITE AND/OR THESE TERMS, WILL BE RESOLVED INDIVIDUALLY, WITHOUT RESORT TO ANY FORM OF CLASS ACTION.</span></p>\r\n<p>These Terms operate to the fullest extent permissible by law.&nbsp;</p>\r\n<p>The failure of Company to comply with these Terms because of an act of God, war, fire, riot, terrorism, earthquake, actions of federal, state or local governmental authorities or for any other reason beyond the reasonable control of Company, shall not be deemed a breach of these Terms.&nbsp;</p>\r\n<p>If Company fails to act with respect to your breach or anyone else&rsquo;s breach on any occasion, Company is not waiving its right to act with respect to future or similar breaches.&nbsp;</p>\r\n<p>If any provision of these Terms shall be unlawful, void or for any reason unenforceable, then that provision shall be deemed severable from these terms of use and shall not affect the validity and enforceability of any remaining provisions.&nbsp;</p>\r\n<p>These Terms constitute a binding agreement between you and Company and is accepted by you upon your use of the Site or your account. These Terms constitute the entire agreement between you and Company regarding the use of the Site and your account. By using the Site, you represent that you are capable of entering into a binding agreement and that you agree to be bound by these Terms.</p>\r\n<p>&nbsp;</p>', 'TERMS OF USE'),
(11, 'Post Your Project', '<p>\n<script type=\"text/javascript\" src=\"http://form.jotform.us/jsform/21564522254146\"></script>\n</p>', 'SUBMIT YOUR PROJECT TO LIGHTAZ LIBRARY'),
(12, 'Applications', '<p>&nbsp;</p>\r\n<div class=\"apps-title\">DOWNLIGHT</div>\r\n<div class=\"apps-descr\">Accent lighting focuses light on a particular area or object. It is often used to highlight art or other artifacts. Common types of accent lights include recessed lights, ingrade fixtures, track lighting.</div>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-left\"><img src=\"/images/applications/downlight_recessed.jpg\" alt=\"Recessed mounted downlight\" />\r\n<div class=\"apps-subtitle\">Recessed Mounted.</div>\r\n<div class=\"apps-descr\">Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/downlight_pendant.jpg\" alt=\"Pendant mounted downlight\" />\r\n<div class=\"apps-subtitle\">Pendant Mounted.</div>\r\n<div class=\"apps-descr\">With higher or unfinished ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/downlight_surface.jpg\" alt=\"Surface mounted downlight\" />\r\n<div class=\"apps-subtitle\">Surface Mounted.</div>\r\n<div class=\"apps-descr\">With unfinished or restricted plenum spaces ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/downlight_wall.jpg\" alt=\"Wall Mounted downlight\" />\r\n<div class=\"apps-subtitle\">Wall Mounted.</div>\r\n<div class=\"apps-descr\">With unfinished or restricted plenum spaces ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">ACCENT LIGHTING</div>\r\n<div class=\"apps-descr\">Accent lighting focuses light on a particular area or object. It is often used to highlight art or other artifacts. Common types of accent lights include recessed lights, ingrade fixtures, track lighting.</div>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-left\"><img src=\"/images/applications/accent_recessed.jpg\" alt=\"Recessed mounted downlight\" />\r\n<div class=\"apps-subtitle\">Recessed Mounted.</div>\r\n<div class=\"apps-descr\">Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/accent_track.jpg\" alt=\"Track mounted accent\" />\r\n<div class=\"apps-subtitle\">Track Mounted</div>\r\n<div class=\"apps-descr\">With higher or unfinished ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/accent_multiples.jpg\" alt=\"Multiple accent\" />\r\n<div class=\"apps-subtitle\">Multiples.</div>\r\n<div class=\"apps-descr\">With unfinished or restricted plenum spaces ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/accent_ingrade.jpg\" alt=\"accent ingrade\" />\r\n<div class=\"apps-subtitle\">In Grade</div>\r\n<div class=\"apps-descr\">With unfinished or restricted plenum spaces ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-title\">WALL WASH</div>\r\n<div class=\"apps-descr\">Accent lighting focuses light on a particular area or object. It is often used to highlight art or other artifacts. Common types of accent lights include recessed lights, ingrade fixtures, track lighting.</div>\r\n<p>&nbsp;</p>\r\n<div class=\"apps-left\"><img src=\"/images/applications/wallwash_recessed.jpg\" alt=\"Recessed mounted downlight\" />\r\n<div class=\"apps-subtitle\">Recessed Mounted.</div>\r\n<div class=\"apps-descr\">Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/wallwash_track.jpg\" alt=\"Track mounted wall wash\" />\r\n<div class=\"apps-subtitle\">Track Mounted</div>\r\n<div class=\"apps-descr\">With higher or unfinished ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/wallwash_pendant.jpg\" alt=\"Wall wash pendant\" />\r\n<div class=\"apps-subtitle\">Pendant</div>\r\n<div class=\"apps-descr\">With unfinished or restricted plenum spaces ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<div class=\"apps-left\"><img src=\"/images/applications/wallwas_ingrade.jpg\" alt=\"wallwash ingrade\" />\r\n<div class=\"apps-subtitle\">In Grade</div>\r\n<div class=\"apps-descr\">With unfinished or restricted plenum spaces ceilings. Available with different aperture sizes and finishes. Narrow, medium and wide distribution.</div>\r\n</div>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>', 'LIGHTING APPLICATIONS AND LUMINAIRE TYPES');
INSERT INTO `pages_html` (`page_id`, `page_name`, `page_html`, `heading`) VALUES
(13, 'Agency', '<h2>AGENCY GUIDE</h2>\r\n<p>Welcome to Light<span style=\"color: #e67e23;\">AZ</span>.com. The largest and most comprehensive search engine in the professional lighting industry. Our search engine makes it easy for users to access and select luminaires. We do not provide pricing or sell lighting fixtures. The platform makes it easier for agents to navigate through thousands of products. With our built-in configurator, you will experience a new and improved way of efficiently work on specifiers projects, as well as create and manage your own projects.</p>\r\n<ul class=\"user-guide-videos\">\r\n<li>\r\n<div class=\"video-title\">Introduction to LightAZ.com</div>\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/4FWd1p7Nwi4\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"video-descr\">Get familiar with all the possibilities LightAZ.com offer, learn how to optimize the search functions, compare products from different manufacturers or print out spec. sheets in seconds.</div>\r\n</li>\r\n<li>\r\n<div class=\"video-title\">How to build a product SKU</div>\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/0avVupTlCsg\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"video-descr\">This video focus on how the innovative SKU configurator saves users valuable time creating SKU numbers. In addition, the video touches the built-in communication tool between users and reps/colleagues/clients etc.</div>\r\n</li>\r\n<li>\r\n<div class=\"video-title\">Create a project in LightAZ.com</div>\r\n<div class=\"video-container\"><iframe src=\"https://www.youtube.com/embed/FLRNo7-rs44\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"></iframe></div>\r\n<div class=\"video-descr\">Learn the framework of how to build a project on LightAZ.com, its easy and fast and with one click you can have a lighting schedule on excel, or a spec. package with all the PDF&rsquo;s ready to print, save or send.</div>\r\n</li>\r\n</ul>\r\n<p><strong>With Light<span style=\"color: #e67e23;\">AZ</span>.com you will:</strong></p>\r\n<ul>\r\n<li>- Have access to, and search-ability of thousands of architectural lighting products</li>\r\n<li>- Effortless narrow your search with 20+ search parameters</li>\r\n<li>- Use our product configurator to accelerate the scheduling process</li>\r\n<li>- Assist specifiers with alternate product selection directly on their lighting schedule</li>\r\n<li>- Create and manage your specification package with ease</li>\r\n<li>- Share products or projects instantly with customers</li>\r\n<li>- Save your favorite products for easy re-use</li>\r\n<li>- Find inspiration from interesting products and projects from all over the world.</li>\r\n</ul>\r\n<p><em>Built for desktop and mobile devices.</em><br />Feel free to contact us for further information and questions.</p>\r\n<p>&nbsp;</p>', 'LIGHTING REP/AGENT');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL,
  `sku` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `manf_id` int(10) UNSIGNED NOT NULL,
  `manf_spec_id` smallint(10) UNSIGNED NOT NULL,
  `brand_id` tinyint(3) UNSIGNED NOT NULL,
  `brand_spec_id` smallint(10) UNSIGNED NOT NULL,
  `family_id` int(10) UNSIGNED NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL,
  `available` tinyint(3) UNSIGNED NOT NULL,
  `source` smallint(5) UNSIGNED NOT NULL,
  `fixture_1` smallint(5) UNSIGNED NOT NULL,
  `fixture_2` smallint(5) UNSIGNED NOT NULL,
  `fixture_3` smallint(5) UNSIGNED NOT NULL,
  `fixture_4` smallint(5) UNSIGNED NOT NULL,
  `fixture_finish_1` smallint(5) UNSIGNED NOT NULL,
  `fixture_finish_2` smallint(5) UNSIGNED NOT NULL,
  `fixture_finish_3` smallint(5) UNSIGNED NOT NULL,
  `fixture_finish_4` smallint(5) UNSIGNED NOT NULL,
  `fixture_finish_5` smallint(5) UNSIGNED NOT NULL,
  `mounting_1` smallint(5) UNSIGNED NOT NULL,
  `mounting_2` smallint(5) UNSIGNED NOT NULL,
  `mounting_3` smallint(5) UNSIGNED NOT NULL,
  `mounting_4` smallint(5) UNSIGNED NOT NULL,
  `environment_1` smallint(5) UNSIGNED NOT NULL,
  `environment_2` smallint(5) UNSIGNED NOT NULL,
  `environment_3` smallint(5) UNSIGNED NOT NULL,
  `environment_4` smallint(5) UNSIGNED NOT NULL,
  `environment_5` tinyint(3) UNSIGNED NOT NULL,
  `shape` smallint(5) UNSIGNED NOT NULL,
  `size_1` smallint(5) UNSIGNED NOT NULL,
  `size_2` smallint(5) UNSIGNED NOT NULL,
  `linear_1_1` smallint(5) UNSIGNED NOT NULL,
  `linear_1_2` smallint(5) UNSIGNED NOT NULL,
  `linear_2_min` decimal(4,1) UNSIGNED NOT NULL,
  `linear_2_max` decimal(4,1) UNSIGNED NOT NULL,
  `aperture_1` smallint(5) UNSIGNED NOT NULL,
  `aperture_2` smallint(5) UNSIGNED NOT NULL,
  `aperture_3` smallint(5) UNSIGNED NOT NULL,
  `aperture_4` smallint(5) UNSIGNED NOT NULL,
  `multiples_min` smallint(5) UNSIGNED NOT NULL,
  `multiples_max` smallint(5) UNSIGNED NOT NULL,
  `cct_1` smallint(5) UNSIGNED NOT NULL,
  `cct_2` smallint(5) UNSIGNED NOT NULL,
  `cct_3` smallint(5) UNSIGNED NOT NULL,
  `cct_4` smallint(5) UNSIGNED NOT NULL,
  `cct_5` smallint(5) UNSIGNED NOT NULL,
  `cri` smallint(5) UNSIGNED NOT NULL,
  `distribution_1` smallint(5) UNSIGNED NOT NULL,
  `distribution_2_1` smallint(5) UNSIGNED NOT NULL,
  `distribution_2_2` smallint(5) UNSIGNED NOT NULL,
  `distribution_2_3` smallint(5) UNSIGNED NOT NULL,
  `distribution_2_4` smallint(5) UNSIGNED NOT NULL,
  `distribution_2_5` smallint(5) UNSIGNED NOT NULL,
  `distribution_2_6` smallint(5) UNSIGNED NOT NULL,
  `night_sky` smallint(5) UNSIGNED NOT NULL,
  `hours_lm` mediumint(8) UNSIGNED NOT NULL,
  `hours_tm` mediumint(8) UNSIGNED NOT NULL,
  `watt_min` decimal(4,1) UNSIGNED NOT NULL,
  `watt_max` decimal(4,1) UNSIGNED NOT NULL,
  `watt_linear_min` decimal(4,1) UNSIGNED NOT NULL,
  `watt_linear_max` decimal(4,1) UNSIGNED NOT NULL,
  `lumens_min` mediumint(8) UNSIGNED NOT NULL,
  `lumens_max` mediumint(8) UNSIGNED NOT NULL,
  `lumens_linear_min` smallint(5) UNSIGNED NOT NULL,
  `lumens_linear_max` smallint(5) UNSIGNED NOT NULL,
  `efficacy` smallint(5) UNSIGNED NOT NULL,
  `controls_1_1` smallint(5) UNSIGNED NOT NULL,
  `controls_1_2` smallint(5) UNSIGNED NOT NULL,
  `controls_2_1` smallint(5) UNSIGNED NOT NULL,
  `controls_2_2` smallint(5) UNSIGNED NOT NULL,
  `controls_2_3` smallint(5) UNSIGNED NOT NULL,
  `controls_2_4` smallint(5) UNSIGNED NOT NULL,
  `controls_3_1` smallint(5) UNSIGNED NOT NULL,
  `controls_3_2` smallint(5) UNSIGNED NOT NULL,
  `power_1` smallint(5) UNSIGNED NOT NULL,
  `power_2_1` smallint(5) UNSIGNED NOT NULL,
  `power_2_2` smallint(5) UNSIGNED NOT NULL,
  `power_2_3` smallint(5) UNSIGNED NOT NULL,
  `power_2_4` smallint(5) UNSIGNED NOT NULL,
  `power_2_5` smallint(5) UNSIGNED NOT NULL,
  `power_3` smallint(5) UNSIGNED NOT NULL,
  `power_4_1` smallint(5) UNSIGNED NOT NULL,
  `power_4_2` smallint(5) UNSIGNED NOT NULL,
  `power_4_3` smallint(5) UNSIGNED NOT NULL,
  `recessed_1_1` smallint(5) UNSIGNED NOT NULL,
  `recessed_1_2` smallint(5) UNSIGNED NOT NULL,
  `recessed_1_3` smallint(5) UNSIGNED NOT NULL,
  `recessed_1_4` smallint(5) UNSIGNED NOT NULL,
  `recessed_2_1` smallint(5) UNSIGNED NOT NULL,
  `recessed_2_2` smallint(5) UNSIGNED NOT NULL,
  `recessed_2_3` smallint(5) UNSIGNED NOT NULL,
  `recessed_2_4` smallint(5) UNSIGNED NOT NULL,
  `depth` decimal(4,1) UNSIGNED NOT NULL,
  `aiming_1` smallint(5) UNSIGNED NOT NULL,
  `aiming_2` smallint(5) UNSIGNED NOT NULL,
  `ada` smallint(5) UNSIGNED NOT NULL,
  `ul` smallint(5) UNSIGNED NOT NULL,
  `etl` smallint(5) UNSIGNED NOT NULL,
  `csa` smallint(5) UNSIGNED NOT NULL,
  `arra` smallint(5) UNSIGNED NOT NULL,
  `ibew` smallint(5) UNSIGNED NOT NULL,
  `title_24` smallint(5) UNSIGNED NOT NULL,
  `energy_star` smallint(5) UNSIGNED NOT NULL,
  `dlc` smallint(5) UNSIGNED NOT NULL,
  `stock` smallint(5) UNSIGNED NOT NULL,
  `warranty` smallint(5) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
