Home
|
Business Guide
|
News
|
e-Newsletters
Monday, February 06, 2012
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
Subscribe to e-Newsletters
* Category:
Industry
Services
Retail
Supplier
* Your name:
* E-mail:
Country:
Brasil
United States
England
China
City:
State:
AC
AL
AP
AM
BA
CE
DF
ES
FN
GO
MA
MT
MS
MG
PA
PB
PR
PE
PI
RJ
RN
RS
RO
RR
SC
SE
SP
TO
Only for Brazil
Yes, I want to receive others informations from this site.
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.©
