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
Contact us
Category
Doubt
Sugestion
Information
Others
* Subject
* Your name:
* E-mail
Phone:
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
* Message:
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.©
