SELECT count(DISTINCT l.id) as browse_count FROM pmd_listings l INNER JOIN `pmd_listings_categories` `c` ON `l`.`id`=`c`.`list_id` WHERE c.cat_id IN (626) AND l.product_id=1 AND status="active"array(1) { ["browse_count"]=> string(1) "3" }
L1:0 PC:3
Remainder:10

SELECT `p`.* FROM (SELECT @myRow := @myRow + 1 as `position`, `s`.* FROM (SELECT DISTINCT (`l`.`id`) as uni,`l`.* FROM `pmd_listings` `l` INNER JOIN `pmd_listings_categories` `c` ON `l`.`id`=`c`.`list_id` WHERE c.cat_id IN (626) AND `l`.`product_id`!=1 ORDER BY `claimed` DESC, `zapscore` DESC) `s`) `p` WHERE `position` >=0 LIMIT 10
Restaurants Delivery Service & Take Out

Restaurants Delivery Service & Take Out



Friendship Trays

2401 Distribution St, Ste A, Charlotte NC 28203

(704) 333-9229

45

Pizza Mart Inc

5900 York Rd, Ste 400, Baltimore MD 21212

(410) 433-8600

38

Happy Speedy

30 Penniman Rd, Allston MA 02134

(617) 202-5480

38

Bruce Lee Inc

1407 Sulphur Spring Rd, Ste F, Halethorpe MD 21227

(410) 247-6868

38

Direct From Philly

1201 S Military Trl, Deerfield Beach FL 33442

(954) 428-7035

38

Townies

819 T J Courson Rd, Fernandina Beach FL 32034

(904) 277-4755

37

Slice

725 29th St S, Birmingham AL 35233

(205) 715-9300

36

SpoonRocket

3550 Lebon Dr, Unit 6317, San Diego CA 92122

(310) 994-6977

35

The Wrap

359 Huntington Ave, Boston MA 02115

(617) 536-6813

35

Online Restaurants

6455 Raven Springs St, Las Vegas NV 89148

(855) 888-8646

35