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 (2038) 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 (2038) 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(6) "489854" ["id"]=> string(6) "489854" ["zapkey"]=> string(5) "344e9" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "53.91" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(19) "Communications Arts" ["friendly_url"]=> string(45) "344e9-communications-arts-menlo-park-ca-94025" ["description_short"]=> string(0) "" ["description"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keywords"]=> string(0) "" ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "6503266040" ["fax"]=> string(0) "" ["location_id"]=> string(4) "7618" ["listing_address1"]=> string(20) "110 Constitution Dr " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "94025-1107" ["location_text_1"]=> string(0) "" ["location_text_2"]=> string(0) "" ["location_text_3"]=> string(0) "" ["location_search_text"]=> string(20) "Menlo Park,CA,,94025" ["hours"]=> string(2) "N;" ["latitude"]=> string(13) "37.4847150000" ["longitude"]=> string(15) "-122.1779940000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> string(14) "173.167.254.41" ["date"]=> string(19) "2014-11-01 12:00:00" ["date_update"]=> string(19) "2016-02-15 04:41:40" ["ip_update"]=> string(0) "" ["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"]=> string(0) "" ["claimed"]=> string(1) "0" ["comment"]=> string(0) "" ["votes"]=> string(1) "0" ["featured"]=> string(1) "1" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(7) "3302953" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "06081" ["census_tract"]=> string(6) "611700" ["census_block_group"]=> string(1) "4" ["census_block_id"]=> string(3) "016" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "41860" ["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(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(0) "" ["sic_relevance"]=> string(1) "0" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(10) "Menlo Park" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [1]=> array(77) { ["position"]=> string(1) "1" ["uni"]=> string(7) "6346369" ["id"]=> string(7) "6346369" ["zapkey"]=> string(7) "71eda11" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "53.62" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(23) "Stampington and Company" ["friendly_url"]=> string(53) "71eda11-stampington-and-company-laguna-hills-ca-92653" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "9492735990" ["fax"]=> NULL ["location_id"]=> string(5) "22369" ["listing_address1"]=> string(20) "22936 Mill Creek Dr " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "92653-1214" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(42) "Laguna Hills,CA,22936 Mill Creek Dr ,92653" ["hours"]=> NULL ["latitude"]=> string(13) "33.6290590000" ["longitude"]=> string(15) "-117.7343520000" ["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:37:15" ["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) "689906617" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "06059" ["census_tract"]=> string(6) "062621" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(3) "001" ["msa"]=> string(4) "5945" ["cbsa"]=> string(5) "31100" ["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(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(12) "Laguna Hills" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [2]=> array(77) { ["position"]=> string(1) "2" ["uni"]=> string(6) "248773" ["id"]=> string(6) "248773" ["zapkey"]=> string(6) "008082" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "52.07" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(20) "Architectural Digest" ["friendly_url"]=> string(45) "008082-architectural-digest-new-york-ny-10036" ["description_short"]=> string(0) "" ["description"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keywords"]=> string(0) "" ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "2122862860" ["fax"]=> string(0) "" ["location_id"]=> string(4) "5857" ["listing_address1"]=> string(11) "4 Times Sq " ["listing_address2"]=> string(8) "Fl 18TH " ["listing_zip"]=> string(10) "10036-6563" ["location_text_1"]=> string(0) "" ["location_text_2"]=> string(0) "" ["location_text_3"]=> string(0) "" ["location_search_text"]=> string(18) "New York,NY,,10036" ["hours"]=> string(2) "N;" ["latitude"]=> string(13) "40.7563000000" ["longitude"]=> string(14) "-73.9864000000" ["coordinates_date_checked"]=> string(19) "0000-00-00 00:00:00" ["www_screenshot_last_updated"]=> string(19) "0000-00-00 00:00:00" ["ip"]=> string(14) "173.167.254.41" ["date"]=> string(19) "2013-05-22 12:00:00" ["date_update"]=> string(19) "2016-02-13 05:51:23" ["ip_update"]=> string(0) "" ["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"]=> string(0) "" ["claimed"]=> string(1) "0" ["comment"]=> string(0) "" ["votes"]=> string(1) "0" ["featured"]=> string(1) "1" ["featured_date"]=> string(19) "0000-00-00 00:00:00" ["nid"]=> string(7) "1027330" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "36061" ["census_tract"]=> string(6) "011900" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(0) "" ["msa"]=> string(4) "5600" ["cbsa"]=> string(5) "35620" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "93" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "2" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [3]=> array(77) { ["position"]=> string(1) "3" ["uni"]=> string(7) "1680530" ["id"]=> string(7) "1680530" ["zapkey"]=> string(6) "1b26d4" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "43.62" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(17) "Washington Parent" ["friendly_url"]=> string(42) "1b26d4-washington-parent-bethesda-md-20816" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "3013202321" ["fax"]=> NULL ["location_id"]=> string(4) "5948" ["listing_address1"]=> string(18) "4701 Sangamore Rd " ["listing_address2"]=> string(9) "Ste N270 " ["listing_zip"]=> string(10) "20816-2528" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(36) "Bethesda,MD,4701 Sangamore Rd ,20816" ["hours"]=> NULL ["latitude"]=> string(13) "38.9487520000" ["longitude"]=> string(14) "-77.1199990000" ["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-01-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:25:12" ["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(8) "14610891" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "24031" ["census_tract"]=> string(6) "705702" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "008" ["msa"]=> string(4) "8840" ["cbsa"]=> string(5) "47900" ["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(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(8) "Bethesda" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [4]=> array(77) { ["position"]=> string(1) "4" ["uni"]=> string(7) "3945082" ["id"]=> string(7) "3945082" ["zapkey"]=> string(6) "6f02f3" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "43.22" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(19) "Texas Fish and Game" ["friendly_url"]=> string(43) "6f02f3-texas-fish-and-game-houston-tx-77032" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "2817842962" ["fax"]=> NULL ["location_id"]=> string(4) "6473" ["listing_address1"]=> string(15) "1745 Greens Rd " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "77032-1119" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(32) "Houston,TX,1745 Greens Rd ,77032" ["hours"]=> NULL ["latitude"]=> string(13) "29.9530180000" ["longitude"]=> string(14) "-95.3682400000" ["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-06-11 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:30:46" ["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(8) "88837776" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "48201" ["census_tract"]=> string(0) "" ["census_block_group"]=> string(0) "" ["census_block_id"]=> string(0) "" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "26420" ["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(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [5]=> array(77) { ["position"]=> string(1) "5" ["uni"]=> string(7) "8908420" ["id"]=> string(7) "8908420" ["zapkey"]=> string(7) "43f8d12" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "43.17" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(16) "The Local Palate" ["friendly_url"]=> string(44) "43f8d12-the-local-palate-charleston-sc-29403" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "8437934876" ["fax"]=> NULL ["location_id"]=> string(4) "6041" ["listing_address1"]=> string(12) "494 King St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "29403-5527" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(32) "Charleston,SC,494 King St ,29403" ["hours"]=> NULL ["latitude"]=> string(13) "32.7907070000" ["longitude"]=> string(14) "-79.9392780000" ["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-08-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:44:43" ["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) "713364934" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "45019" ["census_tract"]=> string(6) "000700" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "001" ["msa"]=> string(4) "1440" ["cbsa"]=> string(5) "16700" ["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(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(10) "Charleston" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [6]=> array(77) { ["position"]=> string(1) "6" ["uni"]=> string(7) "8770768" ["id"]=> string(7) "8770768" ["zapkey"]=> string(7) "0b5c620" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "43.03" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(19) "Playboy Enterprises" ["friendly_url"]=> string(48) "0b5c620-playboy-enterprises-los-angeles-ca-90024" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "3102736774" ["fax"]=> NULL ["location_id"]=> string(4) "6566" ["listing_address1"]=> string(23) "10236 Charing Cross Rd " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "90024-1815" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(44) "Los Angeles,CA,10236 Charing Cross Rd ,90024" ["hours"]=> NULL ["latitude"]=> string(13) "34.0765990000" ["longitude"]=> string(15) "-118.4297180000" ["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:44:19" ["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) "712971750" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "06037" ["census_tract"]=> string(0) "" ["census_block_group"]=> string(0) "" ["census_block_id"]=> string(0) "" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "31100" ["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(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [7]=> array(77) { ["position"]=> string(1) "7" ["uni"]=> string(7) "2186125" ["id"]=> string(7) "2186125" ["zapkey"]=> string(6) "192bb5" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "42.88" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(19) "At Home In Arkansas" ["friendly_url"]=> string(47) "192bb5-at-home-in-arkansas-little-rock-ar-72202" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "5016665510" ["fax"]=> NULL ["location_id"]=> string(4) "6435" ["listing_address1"]=> string(19) "2207 Cottondale Ln " ["listing_address2"]=> string(6) "Ste 3 " ["listing_zip"]=> string(10) "72202-2042" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(40) "Little Rock,AR,2207 Cottondale Ln ,72202" ["hours"]=> NULL ["latitude"]=> string(13) "34.7612010000" ["longitude"]=> string(14) "-92.3034660000" ["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-02-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:26:26" ["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(8) "39295241" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "05119" ["census_tract"]=> string(6) "001502" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "027" ["msa"]=> string(4) "4400" ["cbsa"]=> string(5) "30780" ["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(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [8]=> array(77) { ["position"]=> string(1) "8" ["uni"]=> string(7) "7924472" ["id"]=> string(7) "7924472" ["zapkey"]=> string(7) "7074815" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "42.52" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(15) "This Land Press" ["friendly_url"]=> string(38) "7074815-this-land-press-tulsa-ok-74120" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "9187943328" ["fax"]=> NULL ["location_id"]=> string(4) "6449" ["listing_address1"]=> string(18) "1208 S Peoria Ave " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "74120-5020" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(33) "Tulsa,OK,1208 S Peoria Ave ,74120" ["hours"]=> NULL ["latitude"]=> string(13) "36.1457100000" ["longitude"]=> string(14) "-95.9759670000" ["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-12-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:41:47" ["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) "707688487" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "40143" ["census_tract"]=> string(6) "003200" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(3) "008" ["msa"]=> string(4) "8560" ["cbsa"]=> string(5) "46140" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "58" ["firstyear"]=> string(0) "" ["stdhours"]=> string(0) "" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(5) "Tulsa" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [9]=> array(77) { ["position"]=> string(1) "9" ["uni"]=> string(8) "12200157" ["id"]=> string(8) "12200157" ["zapkey"]=> string(7) "95d3821" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "41.60" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2038" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(13) "Parenting LLC" ["friendly_url"]=> string(39) "95d3821-parenting-llc-campbell-ca-95008" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "4089636124" ["fax"]=> NULL ["location_id"]=> string(4) "7717" ["listing_address1"]=> string(12) "55 N 3rd St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "95008-2070" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(30) "Campbell,CA,55 N 3rd St ,95008" ["hours"]=> NULL ["latitude"]=> string(13) "37.2876360000" ["longitude"]=> string(15) "-121.9475710000" ["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-06-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:55:18" ["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) "897648639" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "06085" ["census_tract"]=> string(0) "" ["census_block_group"]=> string(0) "" ["census_block_id"]=> string(0) "" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "41940" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "98" ["firstyear"]=> string(0) "" ["stdhours"]=> string(11) "MNNONENONEA" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(9) "239010000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "27210202" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(19) "PUBLISHERS MAGAZINE" ["condensed_id"]=> string(9) "239010000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "239000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } }