select DISTINCT SQL_CALC_FOUND_ROWS `ID` as clientID, trim(concat(`NAME`,' ',`NAME2`)) as NAME, replace(trim(concat(`NAME`,' ',`NAME2`)),'/','') as NAMElink , trim(concat(`STRASSE`,' ',`STRASSE1`)) as street, `PLZ`, `ORT`, `FAX`, `TELEFON`, `TLX` as mobile, `produkte_e`, `E_MAIL`, `URL`, 1 as client, `LINKID` from `ibc_kunden` where `aktivkunde` = 1 and `subprojekt` in (5,17,18) and `portalID` = '91' and ( `NAME` like '%Bowling supplies%' or `NAME2` like '%Bowling supplies%' or `produkte_e` like '%Bowling supplies%' ) and `LAND` = 'US' UNION select `LINKID` as clientID, `NAME` as NAME, replace(trim(`NAME`),'/','') as NAMElink, trim(concat(`STRASSE`,' ',`STRASSE1`)) as street, `PLZ`, `ORT`, '', `TELEFON`, '', '', '', '', 0 as client, `LINKID` from `worldwide-US` where `LINKID` != '' and ( MATCH (`NAME`, `produkte_e`) AGAINST ('Bowling supplies' IN BOOLEAN MODE ) ) order by client desc, `NAME`limit 0, 5 ;
We found 16678 matches for your search

'a la carte Fine Home Accessories

238 East Betteravia Road Suite B | Santa Maria, CA, US 93454

(C.T.G.) Ceramic Tile Group Inc

8440 North West 66 Street | Miami, FL, US 33166

1 Studio Yoga - Tools For Yoga

2 Green Village Road | Madison, NJ, US 07940

1-King Brake & Auto Repair

6723 Reseda Boulevard | Reseda, CA, US 91335
Jump to page « Previous 1 2 3 4 5 6 7 ... 334 Next » All
Register Now!