INBOUND L1:0 L2:10 Primary Category:(1459)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 (1459) 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) Shipping Services

Shipping Services



Rethink Group

425 Tolbert St, Cumming GA 30040

(678) 455-0697

43

West Coast Shipping

3002 Giant Rd, San Pablo CA 94806

(510) 236-3008

42

Logistic Dynamics Inc

1140 Wehrle Dr, Buffalo NY 14221

(716) 565-2163

42

Nascar

1 Daytona Blvd, Daytona Beach FL 32114

(386) 310-5000

38

Nalpak Inc

1267 Vernon Way, El Cajon CA 92020

(619) 258-1200

37

Logisics Management

4696 Millennium Dr, Ste 200, Belcamp MD 21017

(301) 322-6150

36

Portvision

723 Main St, Ste 1004, Houston TX 77002

(713) 337-3737

36

Tempnology LLC

1 Autumn Pond Park, Greenland NH 03840

(603) 294-0065

36

Cma-Cgm America Inc

5701 Lake Wright Dr, Norfolk VA 23502

(757) 455-0950

36

Box Fli

1904 Harbor Blvd, Costa Mesa CA 92627

(949) 642-4269

36