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 (2828) 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 (2828) 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) "1888487" ["id"]=> string(7) "1888487" ["zapkey"]=> string(5) "308bf" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "42.06" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(11) "Trex Co Inc" ["friendly_url"]=> string(37) "308bf-trex-co-inc-winchester-va-22603" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "5405426300" ["fax"]=> NULL ["location_id"]=> string(4) "5973" ["listing_address1"]=> string(14) "160 Exeter Dr " ["listing_address2"]=> string(8) "Ste 200 " ["listing_zip"]=> string(10) "22603-8614" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(34) "Winchester,VA,160 Exeter Dr ,22603" ["hours"]=> NULL ["latitude"]=> string(13) "39.2103000000" ["longitude"]=> string(14) "-78.1767000000" ["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:25:42" ["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) "23393093" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "51069" ["census_tract"]=> string(6) "051102" ["census_block_group"]=> string(1) "3" ["census_block_id"]=> string(3) "003" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "49020" ["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) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "4" ["altplace"]=> string(10) "Winchester" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [1]=> array(77) { ["position"]=> string(1) "1" ["uni"]=> string(6) "231302" ["id"]=> string(6) "231302" ["zapkey"]=> string(5) "4e02d" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "35.76" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(13) "Amsum and Ash" ["friendly_url"]=> string(40) "4e02d-amsum-and-ash-minneapolis-mn-55421" ["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) "7635718400" ["fax"]=> string(0) "" ["location_id"]=> string(4) "6326" ["listing_address1"]=> string(14) "30 52nd Way NE" ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "55421-1014" ["location_text_1"]=> string(0) "" ["location_text_2"]=> string(0) "" ["location_text_3"]=> string(0) "" ["location_search_text"]=> string(21) "Minneapolis,MN,,55421" ["hours"]=> string(2) "N;" ["latitude"]=> string(13) "45.0627440000" ["longitude"]=> string(14) "-93.2739940000" ["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) "2015-05-01 12:00:00" ["date_update"]=> string(19) "2016-02-13 03:42:47" ["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(6) "866534" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "27003" ["census_tract"]=> string(6) "051206" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "040" ["msa"]=> string(4) "5120" ["cbsa"]=> string(5) "33460" ["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) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "52119904" ["sic_relevance"]=> string(1) "1" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(11) "Minneapolis" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [2]=> array(77) { ["position"]=> string(1) "2" ["uni"]=> string(7) "3613509" ["id"]=> string(7) "3613509" ["zapkey"]=> string(5) "3c7b2" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "35.57" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(17) "Inpro Corporation" ["friendly_url"]=> string(40) "3c7b2-inpro-corporation-muskego-wi-53150" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "2626799010" ["fax"]=> NULL ["location_id"]=> string(5) "26203" ["listing_address1"]=> string(20) "S80W18766 Apollo Dr " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "53150-9219" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(37) "Muskego,WI,S80W18766 Apollo Dr ,53150" ["hours"]=> NULL ["latitude"]=> string(13) "42.8987940000" ["longitude"]=> string(14) "-88.1483060000" ["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:29:55" ["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) "65205863" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "55133" ["census_tract"]=> string(6) "201704" ["census_block_group"]=> string(1) "3" ["census_block_id"]=> string(3) "000" ["msa"]=> string(4) "5080" ["cbsa"]=> string(5) "33340" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "97" ["firstyear"]=> string(0) "" ["stdhours"]=> string(11) "MF09001700H" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(9) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(7) "Muskego" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [3]=> array(77) { ["position"]=> string(1) "3" ["uni"]=> string(7) "1433294" ["id"]=> string(7) "1433294" ["zapkey"]=> string(6) "574553" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "33.51" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(22) "Simpson Strong-Tie Inc" ["friendly_url"]=> string(45) "574553-simpson-strongtie-inc-enfield-ct-06082" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "8607418923" ["fax"]=> NULL ["location_id"]=> string(5) "16823" ["listing_address1"]=> string(14) "7 Pearson Way " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "06082-2655" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(31) "Enfield,CT,7 Pearson Way ,06082" ["hours"]=> NULL ["latitude"]=> string(13) "42.0027200000" ["longitude"]=> string(14) "-72.5555880000" ["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:24:37" ["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) "12213745" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "09003" ["census_tract"]=> string(6) "524300" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "011" ["msa"]=> string(4) "3280" ["cbsa"]=> string(5) "25540" ["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) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(7) "Enfield" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [4]=> array(77) { ["position"]=> string(1) "4" ["uni"]=> string(7) "2620419" ["id"]=> string(7) "2620419" ["zapkey"]=> string(6) "4c3703" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "33.09" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(10) "Therma Tru" ["friendly_url"]=> string(33) "4c3703-therma-tru-butler-in-46721" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "2608685811" ["fax"]=> NULL ["location_id"]=> string(5) "12348" ["listing_address1"]=> string(16) "601 Re Jones Rd " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "46721-9571" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(32) "Butler,IN,601 Re Jones Rd ,46721" ["hours"]=> NULL ["latitude"]=> string(13) "41.3884000000" ["longitude"]=> string(14) "-84.8697000000" ["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-10-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:27:29" ["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) "48147034" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "18033" ["census_tract"]=> string(6) "020300" ["census_block_group"]=> string(1) "4" ["census_block_id"]=> string(0) "" ["msa"]=> string(4) "2760" ["cbsa"]=> string(5) "12140" ["mcd"]=> string(0) "" ["source_code"]=> string(1) "5" ["confidence_score"]=> string(2) "96" ["firstyear"]=> string(0) "" ["stdhours"]=> string(11) "MF09001700H" ["hoursopen"]=> string(0) "" ["slogan"]=> string(0) "" ["nnid"]=> string(9) "363003000" ["cat_relevance"]=> string(1) "2" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "3" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "2" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [5]=> array(77) { ["position"]=> string(1) "5" ["uni"]=> string(7) "1683444" ["id"]=> string(7) "1683444" ["zapkey"]=> string(5) "6bb8d" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "32.86" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(13) "Wausau Supply" ["friendly_url"]=> string(37) "6bb8d-wausau-supply-rochelle-il-61068" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "8155622100" ["fax"]=> NULL ["location_id"]=> string(5) "30357" ["listing_address1"]=> string(13) "527 N 6th St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "61068-1541" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(31) "Rochelle,IL,527 N 6th St ,61068" ["hours"]=> NULL ["latitude"]=> string(13) "41.9246520000" ["longitude"]=> string(14) "-89.0672610000" ["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:25: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(8) "14641296" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "17141" ["census_tract"]=> string(6) "961100" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(3) "183" ["msa"]=> string(4) "6880" ["cbsa"]=> string(5) "40300" ["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) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [6]=> array(77) { ["position"]=> string(1) "6" ["uni"]=> string(7) "1434350" ["id"]=> string(7) "1434350" ["zapkey"]=> string(5) "3d0ea" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "32.61" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(11) "Siplast Inc" ["friendly_url"]=> string(33) "3d0ea-siplast-inc-irving-tx-75062" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "4699952200" ["fax"]=> NULL ["location_id"]=> string(4) "6456" ["listing_address1"]=> string(19) "1000 Rochelle Blvd " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "75062-3940" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(35) "Irving,TX,1000 Rochelle Blvd ,75062" ["hours"]=> NULL ["latitude"]=> string(13) "32.8503000000" ["longitude"]=> string(14) "-96.9344000000" ["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-10-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:24:37" ["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) "12224343" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "48113" ["census_tract"]=> string(6) "014205" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(0) "" ["msa"]=> string(0) "" ["cbsa"]=> string(5) "19100" ["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(9) "363003000" ["cat_relevance"]=> string(1) "2" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "3" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "4" ["altplace"]=> string(6) "Irving" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [7]=> array(77) { ["position"]=> string(1) "7" ["uni"]=> string(7) "3683926" ["id"]=> string(7) "3683926" ["zapkey"]=> string(6) "61eae7" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "30.89" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(19) "Endura Products Inc" ["friendly_url"]=> string(42) "61eae7-endura-products-inc-colfax-nc-27235" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "3366646327" ["fax"]=> NULL ["location_id"]=> string(5) "14090" ["listing_address1"]=> string(17) "8817 W Market St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "27235-9419" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(33) "Colfax,NC,8817 W Market St ,27235" ["hours"]=> NULL ["latitude"]=> string(13) "36.1033590000" ["longitude"]=> string(14) "-79.9861300000" ["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:30:05" ["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) "66568526" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "37081" ["census_tract"]=> string(6) "016201" ["census_block_group"]=> string(1) "2" ["census_block_id"]=> string(3) "049" ["msa"]=> string(4) "3120" ["cbsa"]=> string(5) "24660" ["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) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(10) "Greensboro" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [8]=> array(77) { ["position"]=> string(1) "8" ["uni"]=> string(7) "8624692" ["id"]=> string(7) "8624692" ["zapkey"]=> string(6) "94cd67" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "29.72" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(13) "Inc Trade PRO" ["friendly_url"]=> string(35) "94cd67-inc-trade-pro-miami-fl-33181" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "3059479705" ["fax"]=> NULL ["location_id"]=> string(4) "6109" ["listing_address1"]=> string(17) "1842 NE 144th St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "33181-1420" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(32) "Miami,FL,1842 NE 144th St ,33181" ["hours"]=> NULL ["latitude"]=> string(13) "25.9082830000" ["longitude"]=> string(14) "-80.1627390000" ["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-11-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:43:53" ["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) "712292389" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "12086" ["census_tract"]=> string(6) "000209" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(3) "020" ["msa"]=> string(4) "5000" ["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(9) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "R" ["altplace"]=> string(5) "Miami" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } [9]=> array(77) { ["position"]=> string(1) "9" ["uni"]=> string(7) "4808579" ["id"]=> string(7) "4808579" ["zapkey"]=> string(6) "1b12c9" ["product_id"]=> string(1) "0" ["zapscore"]=> string(5) "27.66" ["user_id"]=> string(3) "104" ["primary_category_id"]=> string(4) "2828" ["status"]=> string(6) "active" ["priority"]=> string(1) "0" ["title"]=> string(21) "Progressive Solutions" ["friendly_url"]=> string(49) "1b12c9-progressive-solutions-san-antonio-tx-78217" ["description_short"]=> NULL ["description"]=> NULL ["meta_title"]=> NULL ["meta_description"]=> NULL ["meta_keywords"]=> NULL ["keywords"]=> string(0) "" ["logo_extension"]=> NULL ["phone"]=> string(10) "2108228238" ["fax"]=> NULL ["location_id"]=> string(4) "6484" ["listing_address1"]=> string(17) "8902 Broadway St " ["listing_address2"]=> string(0) "" ["listing_zip"]=> string(10) "78217-6116" ["location_text_1"]=> NULL ["location_text_2"]=> NULL ["location_text_3"]=> NULL ["location_search_text"]=> string(38) "San Antonio,TX,8902 Broadway St ,78217" ["hours"]=> NULL ["latitude"]=> string(13) "29.5212000000" ["longitude"]=> string(14) "-98.4598000000" ["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-11-01 12:00:00" ["date_update"]=> string(19) "2016-02-24 09:33:02" ["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) "141923761" ["chain_id"]=> string(1) "0" ["fips"]=> string(5) "48029" ["census_tract"]=> string(6) "121000" ["census_block_group"]=> string(1) "1" ["census_block_id"]=> string(0) "" ["msa"]=> string(4) "7240" ["cbsa"]=> string(5) "41700" ["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(9) "363003000" ["cat_relevance"]=> string(1) "1" ["sic"]=> string(8) "24210100" ["sic_relevance"]=> string(1) "2" ["nnid_text"]=> string(44) "BUILDING MATERIALS WHOLESALE & MANUFACTURERS" ["condensed_id"]=> string(9) "363003000" ["llmatchlevel"]=> string(1) "4" ["altplace"]=> string(0) "" ["cl2"]=> string(9) "363000000" ["priority_weight"]=> string(1) "0" ["priority_calculated"]=> string(1) "0" } }