Home
|
Business Guide
|
News
|
e-Newsletters
Friday, July 30, 2010
Search:
Racks and shelves
Home Office
Offices
Upholstery
Bedrooms
Kids
Dining Rooms
Kitchens
External Area
Complements
Services
Trade Shows in Brazil
Brazil Industry
SELECT ANT.ANT_LABEL_MENU, (SELECT TOP 1 CASE WHEN PAP1.PAP_ORDEM IS NULL THEN CONVERT(nvarchar, PAP2.PAP_ORDEM)+'_2' ELSE CONVERT(nvarchar, PAP1.PAP_ORDEM)+'_1' END AS ORDEM1 FROM TB_ANUNCIANTES_SEGMENTOS ASE LEFT JOIN TB_PAGINADOR_PAGINAS PAP1 ON PAP1.FK_ASE_COD1=ASE.ASE_COD LEFT JOIN TB_PAGINADOR_PAGINAS PAP2 ON PAP2.FK_ASE_COD2=ASE.ASE_COD WHERE ASE.FK_USU_COD=ANT.FK_USU_COD ORDER BY ORDEM1) AS ASE_NUM_PAGINA FROM TB_ANUNCIANTES_ASSINANTES ANT JOIN TB_USUARIOS USU ON ANT.FK_USU_COD=USU.USU_COD WHERE USU.USU_TIPO='ANUNC' AND USU.USU_ATIVO='S' AND ANT.FK_USU_COD<>35 ORDER BY ANT.ANT_LABEL_MENU
Americanflex
Arvy
Atraente Móveis
Barella
Bertolini
Brink
BRV Moveis
Colibri
Divicar Móveis
DJ Móveis
Finestra
Formanova
Grossl
HB Móveis
Henn
Herval Móveis
Kits Paraná
Linhares Export Group
Lintz Móveis
Madebal
Madellegno Móveis
Manbel Móveis
Meu Móvel de Madeira
Moval
Móveis Carraro
Móveis Dalla Costa
Móveis Irimar
Móveis Itatiaia
Móveis Jaci
Móveis James
Móveis Província
Nicioli
Niroflex / Corfam
Parma Móveis
Politorno Móveis
Robel
RR Mobili
Sier Móveis
Sirbel
Universum Móveis
Published ads
Discover everything that the biggest Brazilian manufacturers are offering for your business!
Category:
Industry
Services
Retail
Supplier
Segment:
All
Racks and shelves
Home Office
Offices
Upholstery
Bedrooms
Kids
Dining Rooms
Kitchens
External Area
Complements
Services
Online sales
Sub-Segment:
All
MDF panels
MDP panels
Plywood
Steel
Tubular furniture
Solid Wood
Fairs
Services
Raw material
Machinery and Equipament
Others
Keyword:
JÁ É MEMBRO?
E-mail:
Password:
ok
Advertising
Alternativa Editorial |
EMobile
|
Magazines
|
Top Móbile Award
|
Contact us
|
Terms of Use
© Copyright 2007 – Furnitureinbrazil.com is a registered trademark of Alternativa Editorial Ltda. All rights reserved.©
