INBOUND L1:0 L2:10 Primary Category:(2002)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 (2002) 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) Landscape Lighting

Landscape Lighting



Dallas Landscape Lighting

17800 Dickerson St, Ste 215, Dallas TX 75252

(214) 202-7474

51

Landscape Lighting World

15486 N Nebraska Ave, Lutz FL 33549

(813) 978-3700

39

Midwest Lightscaping

7914 W Dodge Rd, # 441, Omaha NE 68114

(402) 516-4498

36

McKay Landscape Lighting

11440 S 146th St, Ste 104, Omaha NE 68138

(402) 289-3424

36

The Woodlands Nightscaping

6700 Woodlands Pkwy, Ste 230, Spring TX 77382

(936) 271-7652

33

1b Specialty LLC

1629 N Highlands Blvd, Fort Wayne IN 46808

(260) 426-5832

31

Residential Landscape Lighting and Design

4912 Blossom St, Houston TX 77007

(713) 863-7699

30

Outdoor Architecture

216 Po Box, Beaufort SC 29901

(843) 247-3550

29

Roanoke Landscapes

183 Shane Ln, Fincastle VA 24090

(540) 772-0079

28

Creative Nightscapes

5755 Carlisle Ct, Ste 300, North Richland Hills TX 76180

(817) 281-4545

27