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 (722) AND l.product_id=1 AND status="active"array(1) { ["browse_count"]=> string(1) "0" }
L1:0 PC:0
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 (722) AND `l`.`product_id`!=1 ORDER BY `claimed` DESC, `zapscore` DESC) `s`) `p` WHERE `position` >=0 LIMIT 10
array(10) { [0]=> array(77) { ["position"]=> string(1) "0" ["uni"]=> string(7) "8090736" ["id"]=> string(7) "8090736" ["zapkey"]=> string(7) "823ed13" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "51.83" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(30) "Surfari Stand Up Paddle & Surf" ["friendly_url"]=> string(60) "823ed13-surfari-stand-up-paddle-and-surf-manchester-ma-01944" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "9787049051" ["fax"]=> NULL ["location_id"]=> string(5) "24061" ["listing_address1"]=> string(14) "26 Central St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "01944-1363" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(34) "Manchester,MA,26 Central St ,01944" ["hours"]=> NULL ["latitude"]=> string(13) "42.5751200000" ["longitude"]=> string(14) "-70.7731590000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2012-09-28 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:42:17" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "1" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "708889038" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "25009" ["census_tract"]=> string(6) "218100" ["census_block_group"]=> string(1) "3" ["census_block_id"]=> string(3) "010" ["msa"]=> string(4) "1120" ["cbsa"]=> string(5) "14460" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "96" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [1]=> array(77) { ["position"]=> string(1) "1" ["uni"]=> string(7) "9536841" ["id"]=> string(7) "9536841" ["zapkey"]=> string(7) "04d8a14" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "47.89" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(22) "Barewires Surf & Skate" ["friendly_url"]=> string(53) "04d8a14-barewires-surf-and-skate-spring-lake-nj-07762" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "7323597780" ["fax"]=> NULL ["location_id"]=> string(5) "32663" ["listing_address1"]=> string(13) "1307 3rd Ave " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "07762-1440" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(34) "Spring Lake,NJ,1307 3rd Ave ,07762" ["hours"]=> NULL ["latitude"]=> string(13) "40.1539880000" ["longitude"]=> string(14) "-74.0281910000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2015-05-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:46:43" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "1" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "715457750" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "34025" ["census_tract"]=> string(0) "" ["census_block_group"]=> string(0) "" ["census_block_id"]=> string(0) "" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "35620" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "99" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [2]=> array(77) { ["position"]=> string(1) "2" ["uni"]=> string(7) "8735229" ["id"]=> string(7) "8735229" ["zapkey"]=> string(7) "206e311" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "47.67" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(15) "Stand On Liquid" ["friendly_url"]=> string(37) "206e311-stand-on-liquid-bend-or-97702" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "5416394597" ["fax"]=> NULL ["location_id"]=> string(4) "6631" ["listing_address1"]=> string(23) "1320 SE Reed Market Rd " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "97702-2309" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(37) "Bend,OR,1320 SE Reed Market Rd ,97702" ["hours"]=> NULL ["latitude"]=> string(13) "44.0371010000" ["longitude"]=> string(15) "-121.2867930000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2013-06-13 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:44:13" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "1" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "712787302" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "41017" ["census_tract"]=> string(6) "001800" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(3) "009" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "13460" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "51" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [3]=> array(77) { ["position"]=> string(1) "3" ["uni"]=> string(6) "933776" ["id"]=> string(6) "933776" ["zapkey"]=> string(6) "5db6e3" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "45.75" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(35) "Fells Point Surf Company Kenilworth" ["friendly_url"]=> string(58) "5db6e3-fells-point-surf-company-kenilworth-towson-md-21204" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "4108217873" ["fax"]=> NULL ["location_id"]=> string(5) "34045" ["listing_address1"]=> string(18) "800 Kenilworth Dr " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "21204-2201" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(34) "Towson,MD,800 Kenilworth Dr ,21204" ["hours"]=> NULL ["latitude"]=> string(13) "39.4116860000" ["longitude"]=> string(14) "-76.6188890000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2015-03-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:23:29" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "1" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(7) "7485795" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "24005" ["census_tract"]=> string(6) "490301" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "003" ["msa"]=> string(4) "0720" ["cbsa"]=> string(5) "12580" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "99" ["firstyear"]=> string(0) "" ["stdhours"]=> string(22) "MS10002100HNN12001700H" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(6) "Towson" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [4]=> array(77) { ["position"]=> string(1) "4" ["uni"]=> string(7) "7166660" ["id"]=> string(7) "7166660" ["zapkey"]=> string(7) "7fbf414" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "43.53" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(29) "Vintage House of Myrtle Beach" ["friendly_url"]=> string(59) "7fbf414-vintage-house-of-myrtle-beach-myrtle-beach-sc-29577" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "8439467300" ["fax"]=> NULL ["location_id"]=> string(4) "6047" ["listing_address1"]=> string(19) "1303 Celebrity Cir " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "29577-7498" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(41) "Myrtle Beach,SC,1303 Celebrity Cir ,29577" ["hours"]=> NULL ["latitude"]=> string(13) "33.7190000000" ["longitude"]=> string(14) "-78.8788000000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2015-04-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:39:34" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "0" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "698493467" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "45051" ["census_tract"]=> string(6) "050500" ["census_block_group"]=> string(1) "3" ["census_block_id"]=> string(3) "035" ["msa"]=> string(4) "5330" ["cbsa"]=> string(5) "34820" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "97" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "4" ["altplace"]=> string(12) "Myrtle Beach" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [5]=> array(77) { ["position"]=> string(1) "5" ["uni"]=> string(7) "7442954" ["id"]=> string(7) "7442954" ["zapkey"]=> string(6) "5cd548" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "43.47" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(21) "Covewater Paddle Surf" ["friendly_url"]=> string(48) "5cd548-covewater-paddle-surf-santa-cruz-ca-95060" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "8316007230" ["fax"]=> NULL ["location_id"]=> string(4) "6605" ["listing_address1"]=> string(13) "726 Water St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "95060-4117" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(33) "Santa Cruz,CA,726 Water St ,95060" ["hours"]=> NULL ["latitude"]=> string(13) "36.9810120000" ["longitude"]=> string(15) "-122.0154990000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2015-05-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:40:22" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "1" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "702844145" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "06087" ["census_tract"]=> string(6) "100800" ["census_block_group"]=> string(1) "3" ["census_block_id"]=> string(3) "000" ["msa"]=> string(4) "7485" ["cbsa"]=> string(5) "42100" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "99" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(10) "Santa Cruz" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [6]=> array(77) { ["position"]=> string(1) "6" ["uni"]=> string(7) "7691396" ["id"]=> string(7) "7691396" ["zapkey"]=> string(7) "044c511" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "41.48" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(19) "Deja Vu Surf Outlet" ["friendly_url"]=> string(42) "044c511-deja-vu-surf-outlet-kapaa-hi-96746" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "8088224401" ["fax"]=> NULL ["location_id"]=> string(5) "21682" ["listing_address1"]=> string(17) "4-1419 Kuhio Hwy " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "96746-1714" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(32) "Kapaa,HI,4-1419 Kuhio Hwy ,96746" ["hours"]=> NULL ["latitude"]=> string(13) "22.0824000000" ["longitude"]=> string(15) "-159.3124000000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2015-05-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:41:06" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "0" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "705567350" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "15007" ["census_tract"]=> string(6) "040300" ["census_block_group"]=> string(1) "5" ["census_block_id"]=> string(3) "006" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "28180" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "92" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "56510000" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "4" ["altplace"]=> string(5) "Kapaa" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [7]=> array(77) { ["position"]=> string(1) "7" ["uni"]=> string(7) "9249896" ["id"]=> string(7) "9249896" ["zapkey"]=> string(7) "092a715" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "41.33" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(27) "Almond Surfboards & Designs" ["friendly_url"]=> string(60) "092a715-almond-surfboards-and-designs-newport-beach-ca-92663" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "9495152102" ["fax"]=> NULL ["location_id"]=> string(4) "7079" ["listing_address1"]=> string(17) "2429 W Coast Hwy " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "92663-4749" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(40) "Newport Beach,CA,2429 W Coast Hwy ,92663" ["hours"]=> NULL ["latitude"]=> string(13) "33.6190000000" ["longitude"]=> string(15) "-117.9218000000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2015-03-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:45:48" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "0" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "714421960" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "06059" ["census_tract"]=> string(6) "063400" ["census_block_group"]=> string(1) "5" ["census_block_id"]=> string(3) "008" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "31080" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "97" ["firstyear"]=> string(0) "" ["stdhours"]=> string(33) "MF10301730HSS10301700HNN12001700H" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "4" ["altplace"]=> string(13) "Newport Beach" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [8]=> array(77) { ["position"]=> string(1) "8" ["uni"]=> string(7) "5740938" ["id"]=> string(7) "5740938" ["zapkey"]=> string(7) "2552d10" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "41.11" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(21) "Cheka-Looka Surf Shop" ["friendly_url"]=> string(45) "2552d10-chekalooka-surf-shop-seattle-wa-98107" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "2067267878" ["fax"]=> NULL ["location_id"]=> string(4) "6638" ["listing_address1"]=> string(19) "6300 Seaview Ave NW" ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "98107-2663" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(36) "Seattle,WA,6300 Seaview Ave NW,98107" ["hours"]=> NULL ["latitude"]=> string(13) "47.6747400000" ["longitude"]=> string(15) "-122.4060670000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2014-06-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:35:34" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "1" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(9) "158805912" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "53033" ["census_tract"]=> string(6) "003200" ["census_block_group"]=> string(1) "6" ["census_block_id"]=> string(3) "036" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "42660" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "98" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "59410502" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [9]=> array(77) { ["position"]=> string(1) "9" ["uni"]=> string(6) "878894" ["id"]=> string(6) "878894" ["zapkey"]=> string(6) "65cbf2" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "40.18" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(3) "722" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(19) "Island Water Sports" ["friendly_url"]=> string(46) "65cbf2-island-water-sports-lake-worth-fl-33460" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "5615881728" ["fax"]=> NULL ["location_id"]=> string(4) "8554" ["listing_address1"]=> string(13) "728 Lake Ave " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "33460-3813" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(33) "Lake Worth,FL,728 Lake Ave ,33460" ["hours"]=> NULL ["latitude"]=> string(13) "26.6161000000" ["longitude"]=> string(14) "-80.0561290000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> NULL ["date"]=> string(19) "2014-09-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:23:22" ["ip_update"]=> NULL ["impressions"]=> string(1) "0" ["impressions_weekly"]=> string(1) "0" ["search_impressions"]=> string(1) "0" ["emails"]=> string(1) "0" ["rating"]=> string(1) "0" ["banner_impressions"]=> string(1) "0" ["banner_clicks"]=> string(1) "0" ["counterip"]=> NULL ["claimed"]=> string(1) "0" ["comment"]=> NULL ["votes"]=> string(1) "0" ["featured"]=> string(1) "0" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(7) "6959536" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "12099" ["census_tract"]=> string(6) "005203" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "029" ["msa"]=> string(4) "8960" ["cbsa"]=> string(5) "33100" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "98" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(8) "41026000" ["cat_relevance"]=> string(1) "3" ["sic"]=> string(8) "56610000" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(17) "SURFBOARDS RETAIL" ["condensed_id"]=> string(8) "41026000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(10) "Lake Worth" ["cl2"]=> string(8) "41000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } }