INBOUND L1:0 L2:10 Primary Category:(1059)Premium Listing Activation Pending: (0) (10)
L1:0 PC:1
SELECT * FROM (SELECT @myRow := ifnull(@myRow,-2) + 1 as position, s.* FROM (SELECT DISTINCT l.* FROM pmd_listings l INNER JOIN pmd_listings_categories c ON l.id=c.list_id AND c.cat_id IN (1059) WHERE (l.product_id=1) ORDER BY 'claimed' DESC, zapscore DESC) s)p WHERE position >=0 LIMIT 10
No Results from PQ
Remainder:9
bool(true) Designers Industrial

Designers Industrial



Walters-Storyk Design Group

262 Martin Ave, Highland NY 12528

(845) 691-9300

49

Catalina Design Group

2261 Cosmos Ct, Carlsbad CA 92011

(760) 476-3600

48

Simple Human

19801 S Vermont Ave, Torrance CA 90502

(310) 436-2250

47

Brynn Olson Design Group

1229 N North Branch St, Chicago IL 60642

(312) 915-0925

47

Jimmyjane

702 15th St, San Francisco CA 94103

(415) 864-3474

47

Promotional Design Group

9872 Rush St, South El Monte CA 91733

(626) 579-1772

45

Ziba Design

1044 NW 9th Ave, Portland OR 97209

(503) 223-9606

44

Barbour Spangle Design Group

305 W High Ave, High Point NC 27260

(336) 889-3996

44

Dirtt Enviroment Solutions

155 Knowlton Way, Port Wentworth GA 31407

(912) 966-9119

44

Worrell Design Inc

1414 Marshall St NE, Minneapolis MN 55413

(612) 638-6000

43