INBOUND L1:0 L2:10 Primary Category:(403)Premium Listing Activation Pending: (0) (10)
L1:0 PC:2
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 (403,1743,1744,1745,1746,1747,1748) WHERE (l.product_id=1) ORDER BY 'claimed' DESC, zapscore DESC) s)p WHERE position >=0 LIMIT 10
No Results from PQ
Remainder:8
bool(true) Hunting & Fishing Sites

Hunting & Fishing Sites




Buckmasters

10350 Highway 80 E, Montgomery AL 36117

(334) 215-3337

54

Strike King Lure Co

466 Washington St, Collierville TN 38017

(901) 853-1455

52

Angling Unlimited

Sitka AK 99835

(907) 747-3736

49

Global Anglers

1945 NW 18th St, Pompano Beach FL 33069

(954) 532-5613

47

Caddis Fly Angling Shop

168 W 6th Ave, Eugene OR 97401

(541) 342-7005

47

Channel Islands Sport Fishing

4151 Victoria Ave, Oxnard CA 93035

(805) 382-1612

46

Yellow Dog Flyfishing Adventures

213 S Willson Ave, Bozeman MT 59715

(406) 585-8667

45

Spirit Of The North Sled Dog

Ennis MT 59729

(406) 682-7994

45

Seasquared Charter

1263 Marlin Dr, Marathon FL 33050

(305) 743-5305

43

The Colorado Angler

Silverthorne CO 80498

(970) 513-8055

43