ERROR : [1267]Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Query : Select p.* from produit p inner join entry e on p.nom=e.idTranslation where lower(e.text)=lower('Urba��') LIMIT 1

Contraste - Products

Products

Filtered by :

Diameter

  • 2-1/2 in (14)
  • 3 in (9)
  • 3-1/2 in (135)
  • 4 in (120)
  • 4-1/4 in (4)
  • 4-3/8 in (13)
  • 6 in (18)
  • 8 in (1)

Trim Models

  • Adjustable (94)
  • Decorative Glass (17)
  • Double Gimbal (7)
  • Downlight (114)
  • Elbow (4)
  • Indirect (4)
  • Modular (13)
  • Shower (51)
  • Stepped Baffle (1)
  • Wall Wash (25)

Lumens

  • 1000 Lumens and Less (59)
  • 1001 to 2000 Lumens (70)
  • 2001 to 3000 Lumens (20)
  • 3001 Lumens and More (1)
  • 670 to 1205 Lumens (4)
  • 795 To 1153 Lumens (2)
  • 875 to 1225 Lumens (2)

Source

  • Bi-Pin / Mr16 (26)
  • CFL (24)
  • Fluorescent (18)
  • G40 (1)
  • G9 (23)
  • GU10 (48)
  • GU10 LED (51)
  • GU24 (14)
  • GX10 (CMH) (12)
  • LED (153)
  • MED/E26 (17)
  • MH (CMH) (1)
  • MR11 (4)
  • MR16 (83)
  • MR16 LED (52)
  • PAR16 LED (54)
  • PAR20 (23)
  • PAR20 (CMH) (3)
  • PAR20 LED (12)
  • PAR30 (10)
  • Plumen (3)

Shape

  • Round (190)
  • Square (94)

Installation Type

  • Insulated Ceiling (188)
  • New Construction (284)
  • Remodel (270)

Installation

  • Pendants (39)
  • Recessed (4)
  • Wall Sconces (19)

Product Line

  • Ardito (46)
  • Classic (113)
  • Concerto (17)
  • Ecoreno (2)
  • ECO²LED (8)
  • Evolution (61)
  • Hexaled (1)
  • Intermezzo (4)
  • Minilux (4)
  • Modul Aim (13)
  • Multi-Aim (12)
  • Prilux (6)
  • Priori (18)
  • Profilux (10)
  • Urbaï (17)

Models

  • Flangeless (21)
  • With flange (26)

400 Products

    Products per page :

      An error happened during the search.