INBOUND L1:0 L2:10 Primary Category:(473)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 (473) 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) Automobile Salvage

Automobile Salvage



45

Prattville Auto & RV Repair Center LLC

1259 S Memorial Dr, Prattville AL 36067

(334) 365-5085

25

Cornett Automotive Inc

1225 N 4th St, Saint Joseph MO 64501

(816) 233-4094

19

Cecils Tire & Automotive

612 E Main St, Jenks OK 74037

(918) 299-0521

19

Chris' Towing LLC

Stevens Point WI 54482

(715) 295-0004

19

Desert View Auto Auctions

15206 Kuykendahl Rd, Houston TX 77090

(281) 919-2233

19

Copart

6044 Troy Hwy, Montgomery AL 36116

(334) 281-7264

19

Copart

286 E Twinsburg Rd, Northfield OH 44067

(330) 468-1500

19

Randleman Service Station

224 S Main St, Randleman NC 27317

(336) 498-7679

19

We Buy Junk

2983 Us Highway 41 S, Valdosta GA 31606

(229) 247-7199

18