INBOUND L1:0 L2:10 Primary Category:(145)Premium Listing Activation Pending: (0) (10)
L1:0 PC:8
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 (145,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555) WHERE (l.product_id=1) ORDER BY 'claimed' DESC, zapscore DESC) s)p WHERE position >=0 LIMIT 10
No Results from PQ
Remainder:2
bool(true) Excavation and Wrecking Contractors

Excavation and Wrecking Contractors




Sonoma County Excavating

Sebastopol CA 95473

(707) 823-5117

45

Fecon Inc

3460 Grant Ave, Lebanon OH 45036

(513) 696-4430

44
39

North Carolina One-Call Center

Jonesville NC 28642

(800) 635-4949

39

Eagan Excavating Co

10670 Lehigh Rd S, Hastings MN 55033

(651) 459-6494

37

The Packard Foundation

175 S San Antonio Rd, Los Altos CA 94022

(650) 948-7658

37

Aircraft Demolition

1800 Cliff Rd E, Burnsville MN 55337

(952) 224-2424

37

Creative Interiors

5280 Scottsville Rd, Bowling Green KY 42104

(270) 781-7379

36

Lindex

Santa Cruz CA 95064

(831) 462-5519

36

Fuhr Excavation Co

13318 78th Ave W, Taylor Ridge IL 61284

(309) 798-5546

34