About us
Products
New Products
Lighting Tool
Catalogues
Design Lighting
Lighting News
Press Releases
Projects
Bright Plus
Bright Lab
Contact Us

Ceiling

products / indoor /

SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=297 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=297 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0

Clear Filters

Mounting Type

,,712,,0,712,0,0,710,0,0,710,0,

Ceiling Mounted(2)

,,712,,0,712,0,0,710,0,0,710,0,

Suspended(2)

Lamps Categories

,,696,698,,0,696,698,0,0,696,698,0,0,696,698,0,

LED LAMPS(4)

,,696,698,,0,696,698,0,0,696,698,0,0,696,698,0,

HALOGEN LAMPS(4)

Control gear

Housing

,,178,,0,178,0,0,178,0,0,178,0,

Pressed formed steel(4)

Diffuser

,,174,,,0,174,0,0,174,0,

Opal glass(3)

Reflector

Colors

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

Gold
-40(4)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

-75
Titanium(4)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

Nickel mat
-55(3)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

-10
White(1)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

-20
Black(1)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

-30
Grey(1)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

Copper
-26(4)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

Textured
Black
-08(3)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

Textured
White
-09(3)

,0,1673,1674,1675,95,96,101,968,0,0,92,93,94,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,

Textured
Grey
-35(3)

,,126,,0,124,0,0,126,0,0,126,0,

20(1)

,,126,,0,124,0,0,126,0,0,126,0,

40(3)

,,228,,0,228,0,0,228,0,0,228,0,

02(4)

SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 297 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 297 AND Related_Rec_ID=Rec_ID AND Related_Page_ID=Page_ID order by Rec_Order

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102496 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102496 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102465 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102465 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101296 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101296 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102467 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102467 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101876 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101876 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102598 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102598 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101293 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101293 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2486 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2486 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101066 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101066 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101295 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101295 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101290 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101290 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

MINI AVOLO

MINI AVOLO A 6F

MINI AVOLO A DZ SP 2

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101058 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101058 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101289 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101289 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

AVOLO

AVOLO M A 4F

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101054 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101054 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101292 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101292 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101063 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101063 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101062 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101062 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101078 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101078 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101081 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101081 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101461 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101461 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101065 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101065 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101083 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101083 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101060 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101060 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101291 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101291 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101069 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101069 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101294 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101294 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SFERA

SFERA 3

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101061 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101061 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101080 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101080 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101072 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101072 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101076 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101076 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101052 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101052 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101073 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101073 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101067 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101067 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101074 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101074 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101070 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101070 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101055 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101055 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101057 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101057 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101051 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101051 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101068 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101068 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101084 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101084 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101082 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101082 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101064 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101064 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101056 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101056 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101079 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101079 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101077 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101077 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101075 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101075 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101059 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101059 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101053 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101053 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101071 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101071 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102559 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102559 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("228",Rat_MultipleSel7) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON