INBOUND L1:0 L2:10 Primary Category:(1802)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 (1802) 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) Party Centers

Party Centers



Darlings & Divas of Amityville, Inc.

65 Merrick Rd, Amityville NY 11701

(631) 608-4710

44

Spring Hollow Golf Course

3350 Schuylkill Rd, Spring City PA 19475

(610) 948-5566

41

Party City

910 Wolcott St, Ste 16, Waterbury CT 06705

(203) 596-1853

40

Hot Skates Roller Skating Center

1716 Whitehead Rd, Gwynn Oak MD 21207

(410) 265-7525

39

Unique Venues

1001 Menoher Blvd, Johnstown PA 15905

(814) 254-1310

38

Unique Venues

100 Susan Dr, Johnstown PA 15905

(814) 255-8950

38

Braylee's Zoo

228 S 1st St, Union City TN 38261

(731) 335-6650

36

Big Bounce Inflatables

1701 S Main St, New Castle IN 47362

(765) 529-5800

34

Bouncetown Inc

550 Foundry Rd, Norristown PA 19403

(610) 539-7529

33

Skate Zone

1082 State Route 3 S, Gambrills MD 21054

(410) 721-7155

32