Warning: mysql_query() [http://www.mysql.com/doc]: The used SELECT statements have a different number of columns in /home/majoncom/public_html/local/includes/platform/query.php on line 153
QUERY ERROR:The used SELECT statements have a different number of columnsSQL:SELECT * FROM (             SELECT
content_17.id,
content_17.profileid,
content_17.URLid,
content_17.address_URLid,
content_17.userid,
content_17.parentcategory_id,
content_17.category_id,
content_17.company,
content_17.address,
content_17.city,
content_17.zip,
content_17.state,
content_17.county,
content_17.phone,
content_17.rating,
content_17.owner_name,
content_17.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_17.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_17,users_editedprofiles WHERE content_17.state_id='8' AND users_editedprofiles.parentcategory_id='17' AND users_editedprofiles.content_id = content_17.id AND users_editedprofiles.plan_id != 0
             AND (content_17.category_id='53167' OR content_17.category_id='53300' OR content_17.category_id='57445' OR content_17.category_id='53097' OR content_17.category_id='529' OR content_17.category_id='49211' OR content_17.category_id='51361' OR content_17.category_id='53023' OR content_17.category_id='51614' OR content_17.category_id='53681' OR content_17.category_id='51345' OR content_17.category_id='53873' OR content_17.category_id='49206' OR content_17.category_id='49193' OR content_17.category_id='53853' OR content_17.category_id='410' OR content_17.category_id='18' OR content_17.category_id='51216' OR content_17.category_id='49204' OR content_17.category_id='53176' OR content_17.category_id='53032' OR content_17.category_id='51600' OR content_17.category_id='49197' OR content_17.category_id='60139' OR content_17.category_id='51602' OR content_17.category_id='50994' OR content_17.category_id='52266' OR content_17.category_id='57022' OR content_17.category_id='51743' OR content_17.category_id='49194' OR content_17.category_id='51585' OR content_17.category_id='51851' OR content_17.category_id='51744' OR content_17.category_id='52736' OR content_17.category_id='49198' OR content_17.category_id='205' OR content_17.category_id='46172' OR content_17.category_id='358' OR content_17.category_id='52947' OR content_17.category_id='46145')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_70.id,
content_70.profileid,
content_70.URLid,
content_70.address_URLid,
content_70.userid,
content_70.parentcategory_id,
content_70.category_id,
content_70.company,
content_70.address,
content_70.city,
content_70.zip,
content_70.state,
content_70.county,
content_70.phone,
content_70.rating,
content_70.owner_name,
content_70.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_70.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_70,users_editedprofiles WHERE content_70.state_id='8' AND users_editedprofiles.parentcategory_id='70' AND users_editedprofiles.content_id = content_70.id AND users_editedprofiles.plan_id != 0
             AND (content_70.category_id='51510' OR content_70.category_id='53874')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_9.id,
content_9.profileid,
content_9.URLid,
content_9.address_URLid,
content_9.userid,
content_9.parentcategory_id,
content_9.category_id,
content_9.company,
content_9.address,
content_9.city,
content_9.zip,
content_9.state,
content_9.county,
content_9.phone,
content_9.rating,
content_9.owner_name,
content_9.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_9.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_9,users_editedprofiles WHERE content_9.state_id='8' AND users_editedprofiles.parentcategory_id='9' AND users_editedprofiles.content_id = content_9.id AND users_editedprofiles.plan_id != 0
             AND (content_9.category_id='228' OR content_9.category_id='693')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_30.id,
content_30.profileid,
content_30.URLid,
content_30.address_URLid,
content_30.userid,
content_30.parentcategory_id,
content_30.category_id,
content_30.company,
content_30.address,
content_30.city,
content_30.zip,
content_30.state,
content_30.county,
content_30.phone,
content_30.rating,
content_30.owner_name,
content_30.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_30.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_30,users_editedprofiles WHERE content_30.state_id='8' AND users_editedprofiles.parentcategory_id='30' AND users_editedprofiles.content_id = content_30.id AND users_editedprofiles.plan_id != 0
             AND (content_30.category_id='51820' OR content_30.category_id='87')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50 UNION 
 SELECT 
content_41.*,
users_editedprofiles.*,
content_41.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance
FROM content_41,users_editedprofiles,assigned_categories WHERE content_41.id = '251214' AND
users_editedprofiles.parentcategory_id='41' AND users_editedprofiles.content_id = content_41.id
AND users_editedprofiles.plan_id != 0
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_80.id,
content_80.profileid,
content_80.URLid,
content_80.address_URLid,
content_80.userid,
content_80.parentcategory_id,
content_80.category_id,
content_80.company,
content_80.address,
content_80.city,
content_80.zip,
content_80.state,
content_80.county,
content_80.phone,
content_80.rating,
content_80.owner_name,
content_80.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_80.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_80,users_editedprofiles WHERE content_80.state_id='8' AND users_editedprofiles.parentcategory_id='80' AND users_editedprofiles.content_id = content_80.id AND users_editedprofiles.plan_id != 0
             AND (content_80.category_id='44296' OR content_80.category_id='54278' OR content_80.category_id='180')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_97.id,
content_97.profileid,
content_97.URLid,
content_97.address_URLid,
content_97.userid,
content_97.parentcategory_id,
content_97.category_id,
content_97.company,
content_97.address,
content_97.city,
content_97.zip,
content_97.state,
content_97.county,
content_97.phone,
content_97.rating,
content_97.owner_name,
content_97.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_97.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_97,users_editedprofiles WHERE content_97.state_id='8' AND users_editedprofiles.parentcategory_id='97' AND users_editedprofiles.content_id = content_97.id AND users_editedprofiles.plan_id != 0
             AND (content_97.category_id='53293')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_47.id,
content_47.profileid,
content_47.URLid,
content_47.address_URLid,
content_47.userid,
content_47.parentcategory_id,
content_47.category_id,
content_47.company,
content_47.address,
content_47.city,
content_47.zip,
content_47.state,
content_47.county,
content_47.phone,
content_47.rating,
content_47.owner_name,
content_47.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_47.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_47,users_editedprofiles WHERE content_47.state_id='8' AND users_editedprofiles.parentcategory_id='47' AND users_editedprofiles.content_id = content_47.id AND users_editedprofiles.plan_id != 0
             AND (content_47.category_id='49007' OR content_47.category_id='48990')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_5.id,
content_5.profileid,
content_5.URLid,
content_5.address_URLid,
content_5.userid,
content_5.parentcategory_id,
content_5.category_id,
content_5.company,
content_5.address,
content_5.city,
content_5.zip,
content_5.state,
content_5.county,
content_5.phone,
content_5.rating,
content_5.owner_name,
content_5.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_5.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_5,users_editedprofiles WHERE content_5.state_id='8' AND users_editedprofiles.parentcategory_id='5' AND users_editedprofiles.content_id = content_5.id AND users_editedprofiles.plan_id != 0
             AND (content_5.category_id='56547')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_41.id,
content_41.profileid,
content_41.URLid,
content_41.address_URLid,
content_41.userid,
content_41.parentcategory_id,
content_41.category_id,
content_41.company,
content_41.address,
content_41.city,
content_41.zip,
content_41.state,
content_41.county,
content_41.phone,
content_41.rating,
content_41.owner_name,
content_41.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_41.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_41,users_editedprofiles WHERE content_41.state_id='8' AND users_editedprofiles.parentcategory_id='41' AND users_editedprofiles.content_id = content_41.id AND users_editedprofiles.plan_id != 0
             AND (content_41.category_id='56891' OR content_41.category_id='48919')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_25.id,
content_25.profileid,
content_25.URLid,
content_25.address_URLid,
content_25.userid,
content_25.parentcategory_id,
content_25.category_id,
content_25.company,
content_25.address,
content_25.city,
content_25.zip,
content_25.state,
content_25.county,
content_25.phone,
content_25.rating,
content_25.owner_name,
content_25.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_25.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_25,users_editedprofiles WHERE content_25.state_id='8' AND users_editedprofiles.parentcategory_id='25' AND users_editedprofiles.content_id = content_25.id AND users_editedprofiles.plan_id != 0
             AND (content_25.category_id='52706' OR content_25.category_id='51590')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50 ORDER BY distance asc, theplan_id DESC, rating DESC) as t1 UNION SELECT * FROM (             SELECT
content_17.id,
content_17.profileid,
content_17.URLid,
content_17.address_URLid,
content_17.userid,
content_17.parentcategory_id,
content_17.category_id,
content_17.company,
content_17.address,
content_17.city,
content_17.zip,
content_17.state,
content_17.county,
content_17.phone,
content_17.rating,
content_17.owner_name,
content_17.plan_id,

            0 as nf_plan_id,content_17.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_17 WHERE 
            state_id='8' 
            
             AND (content_17.category_id='53167' OR content_17.category_id='53300' OR content_17.category_id='57445' OR content_17.category_id='53097' OR content_17.category_id='529' OR content_17.category_id='49211' OR content_17.category_id='51361' OR content_17.category_id='53023' OR content_17.category_id='51614' OR content_17.category_id='53681' OR content_17.category_id='51345' OR content_17.category_id='53873' OR content_17.category_id='49206' OR content_17.category_id='49193' OR content_17.category_id='53853' OR content_17.category_id='410' OR content_17.category_id='18' OR content_17.category_id='51216' OR content_17.category_id='49204' OR content_17.category_id='53176' OR content_17.category_id='53032' OR content_17.category_id='51600' OR content_17.category_id='49197' OR content_17.category_id='60139' OR content_17.category_id='51602' OR content_17.category_id='50994' OR content_17.category_id='52266' OR content_17.category_id='57022' OR content_17.category_id='51743' OR content_17.category_id='49194' OR content_17.category_id='51585' OR content_17.category_id='51851' OR content_17.category_id='51744' OR content_17.category_id='52736' OR content_17.category_id='49198' OR content_17.category_id='205' OR content_17.category_id='46172' OR content_17.category_id='358' OR content_17.category_id='52947' OR content_17.category_id='46145')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_70.id,
content_70.profileid,
content_70.URLid,
content_70.address_URLid,
content_70.userid,
content_70.parentcategory_id,
content_70.category_id,
content_70.company,
content_70.address,
content_70.city,
content_70.zip,
content_70.state,
content_70.county,
content_70.phone,
content_70.rating,
content_70.owner_name,
content_70.plan_id,

            0 as nf_plan_id,content_70.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_70 WHERE 
            state_id='8' 
            
             AND (content_70.category_id='51510' OR content_70.category_id='53874')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_9.id,
content_9.profileid,
content_9.URLid,
content_9.address_URLid,
content_9.userid,
content_9.parentcategory_id,
content_9.category_id,
content_9.company,
content_9.address,
content_9.city,
content_9.zip,
content_9.state,
content_9.county,
content_9.phone,
content_9.rating,
content_9.owner_name,
content_9.plan_id,

            0 as nf_plan_id,content_9.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_9 WHERE 
            state_id='8' 
            
             AND (content_9.category_id='228' OR content_9.category_id='693')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_30.id,
content_30.profileid,
content_30.URLid,
content_30.address_URLid,
content_30.userid,
content_30.parentcategory_id,
content_30.category_id,
content_30.company,
content_30.address,
content_30.city,
content_30.zip,
content_30.state,
content_30.county,
content_30.phone,
content_30.rating,
content_30.owner_name,
content_30.plan_id,

            0 as nf_plan_id,content_30.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_30 WHERE 
            state_id='8' 
            
             AND (content_30.category_id='51820' OR content_30.category_id='87')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_80.id,
content_80.profileid,
content_80.URLid,
content_80.address_URLid,
content_80.userid,
content_80.parentcategory_id,
content_80.category_id,
content_80.company,
content_80.address,
content_80.city,
content_80.zip,
content_80.state,
content_80.county,
content_80.phone,
content_80.rating,
content_80.owner_name,
content_80.plan_id,

            0 as nf_plan_id,content_80.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_80 WHERE 
            state_id='8' 
            
             AND (content_80.category_id='44296' OR content_80.category_id='54278' OR content_80.category_id='180')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_97.id,
content_97.profileid,
content_97.URLid,
content_97.address_URLid,
content_97.userid,
content_97.parentcategory_id,
content_97.category_id,
content_97.company,
content_97.address,
content_97.city,
content_97.zip,
content_97.state,
content_97.county,
content_97.phone,
content_97.rating,
content_97.owner_name,
content_97.plan_id,

            0 as nf_plan_id,content_97.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_97 WHERE 
            state_id='8' 
            
             AND (content_97.category_id='53293')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_47.id,
content_47.profileid,
content_47.URLid,
content_47.address_URLid,
content_47.userid,
content_47.parentcategory_id,
content_47.category_id,
content_47.company,
content_47.address,
content_47.city,
content_47.zip,
content_47.state,
content_47.county,
content_47.phone,
content_47.rating,
content_47.owner_name,
content_47.plan_id,

            0 as nf_plan_id,content_47.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_47 WHERE 
            state_id='8' 
            
             AND (content_47.category_id='49007' OR content_47.category_id='48990')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_5.id,
content_5.profileid,
content_5.URLid,
content_5.address_URLid,
content_5.userid,
content_5.parentcategory_id,
content_5.category_id,
content_5.company,
content_5.address,
content_5.city,
content_5.zip,
content_5.state,
content_5.county,
content_5.phone,
content_5.rating,
content_5.owner_name,
content_5.plan_id,

            0 as nf_plan_id,content_5.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_5 WHERE 
            state_id='8' 
            
             AND (content_5.category_id='56547')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_41.id,
content_41.profileid,
content_41.URLid,
content_41.address_URLid,
content_41.userid,
content_41.parentcategory_id,
content_41.category_id,
content_41.company,
content_41.address,
content_41.city,
content_41.zip,
content_41.state,
content_41.county,
content_41.phone,
content_41.rating,
content_41.owner_name,
content_41.plan_id,

            0 as nf_plan_id,content_41.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_41 WHERE 
            state_id='8' 
            
             AND (content_41.category_id='56891' OR content_41.category_id='48919')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_25.id,
content_25.profileid,
content_25.URLid,
content_25.address_URLid,
content_25.userid,
content_25.parentcategory_id,
content_25.category_id,
content_25.company,
content_25.address,
content_25.city,
content_25.zip,
content_25.state,
content_25.county,
content_25.phone,
content_25.rating,
content_25.owner_name,
content_25.plan_id,

            0 as nf_plan_id,content_25.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_25 WHERE 
            state_id='8' 
            
             AND (content_25.category_id='52706' OR content_25.category_id='51590')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
             ORDER BY distance asc, rating DESC) as t2  LIMIT 0,10 DB:businessdir_dec22 / businessdir
Warning: mysql_query() [http://www.mysql.com/doc]: The used SELECT statements have a different number of columns in /home/majoncom/public_html/local/includes/platform/query.php on line 193
QUERY ERROR:The used SELECT statements have a different number of columnsSQL:SELECT * FROM (             SELECT
content_17.id,
content_17.profileid,
content_17.URLid,
content_17.address_URLid,
content_17.userid,
content_17.parentcategory_id,
content_17.category_id,
content_17.company,
content_17.address,
content_17.city,
content_17.zip,
content_17.state,
content_17.county,
content_17.phone,
content_17.rating,
content_17.owner_name,
content_17.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_17.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_17,users_editedprofiles WHERE content_17.state_id='8' AND users_editedprofiles.parentcategory_id='17' AND users_editedprofiles.content_id = content_17.id AND users_editedprofiles.plan_id != 0
             AND (content_17.category_id='53167' OR content_17.category_id='53300' OR content_17.category_id='57445' OR content_17.category_id='53097' OR content_17.category_id='529' OR content_17.category_id='49211' OR content_17.category_id='51361' OR content_17.category_id='53023' OR content_17.category_id='51614' OR content_17.category_id='53681' OR content_17.category_id='51345' OR content_17.category_id='53873' OR content_17.category_id='49206' OR content_17.category_id='49193' OR content_17.category_id='53853' OR content_17.category_id='410' OR content_17.category_id='18' OR content_17.category_id='51216' OR content_17.category_id='49204' OR content_17.category_id='53176' OR content_17.category_id='53032' OR content_17.category_id='51600' OR content_17.category_id='49197' OR content_17.category_id='60139' OR content_17.category_id='51602' OR content_17.category_id='50994' OR content_17.category_id='52266' OR content_17.category_id='57022' OR content_17.category_id='51743' OR content_17.category_id='49194' OR content_17.category_id='51585' OR content_17.category_id='51851' OR content_17.category_id='51744' OR content_17.category_id='52736' OR content_17.category_id='49198' OR content_17.category_id='205' OR content_17.category_id='46172' OR content_17.category_id='358' OR content_17.category_id='52947' OR content_17.category_id='46145')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_70.id,
content_70.profileid,
content_70.URLid,
content_70.address_URLid,
content_70.userid,
content_70.parentcategory_id,
content_70.category_id,
content_70.company,
content_70.address,
content_70.city,
content_70.zip,
content_70.state,
content_70.county,
content_70.phone,
content_70.rating,
content_70.owner_name,
content_70.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_70.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_70,users_editedprofiles WHERE content_70.state_id='8' AND users_editedprofiles.parentcategory_id='70' AND users_editedprofiles.content_id = content_70.id AND users_editedprofiles.plan_id != 0
             AND (content_70.category_id='51510' OR content_70.category_id='53874')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_9.id,
content_9.profileid,
content_9.URLid,
content_9.address_URLid,
content_9.userid,
content_9.parentcategory_id,
content_9.category_id,
content_9.company,
content_9.address,
content_9.city,
content_9.zip,
content_9.state,
content_9.county,
content_9.phone,
content_9.rating,
content_9.owner_name,
content_9.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_9.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_9,users_editedprofiles WHERE content_9.state_id='8' AND users_editedprofiles.parentcategory_id='9' AND users_editedprofiles.content_id = content_9.id AND users_editedprofiles.plan_id != 0
             AND (content_9.category_id='228' OR content_9.category_id='693')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_30.id,
content_30.profileid,
content_30.URLid,
content_30.address_URLid,
content_30.userid,
content_30.parentcategory_id,
content_30.category_id,
content_30.company,
content_30.address,
content_30.city,
content_30.zip,
content_30.state,
content_30.county,
content_30.phone,
content_30.rating,
content_30.owner_name,
content_30.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_30.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_30,users_editedprofiles WHERE content_30.state_id='8' AND users_editedprofiles.parentcategory_id='30' AND users_editedprofiles.content_id = content_30.id AND users_editedprofiles.plan_id != 0
             AND (content_30.category_id='51820' OR content_30.category_id='87')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50 UNION 
 SELECT 
content_41.*,
users_editedprofiles.*,
content_41.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance
FROM content_41,users_editedprofiles,assigned_categories WHERE content_41.id = '251214' AND
users_editedprofiles.parentcategory_id='41' AND users_editedprofiles.content_id = content_41.id
AND users_editedprofiles.plan_id != 0
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_80.id,
content_80.profileid,
content_80.URLid,
content_80.address_URLid,
content_80.userid,
content_80.parentcategory_id,
content_80.category_id,
content_80.company,
content_80.address,
content_80.city,
content_80.zip,
content_80.state,
content_80.county,
content_80.phone,
content_80.rating,
content_80.owner_name,
content_80.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_80.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_80,users_editedprofiles WHERE content_80.state_id='8' AND users_editedprofiles.parentcategory_id='80' AND users_editedprofiles.content_id = content_80.id AND users_editedprofiles.plan_id != 0
             AND (content_80.category_id='44296' OR content_80.category_id='54278' OR content_80.category_id='180')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_97.id,
content_97.profileid,
content_97.URLid,
content_97.address_URLid,
content_97.userid,
content_97.parentcategory_id,
content_97.category_id,
content_97.company,
content_97.address,
content_97.city,
content_97.zip,
content_97.state,
content_97.county,
content_97.phone,
content_97.rating,
content_97.owner_name,
content_97.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_97.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_97,users_editedprofiles WHERE content_97.state_id='8' AND users_editedprofiles.parentcategory_id='97' AND users_editedprofiles.content_id = content_97.id AND users_editedprofiles.plan_id != 0
             AND (content_97.category_id='53293')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_47.id,
content_47.profileid,
content_47.URLid,
content_47.address_URLid,
content_47.userid,
content_47.parentcategory_id,
content_47.category_id,
content_47.company,
content_47.address,
content_47.city,
content_47.zip,
content_47.state,
content_47.county,
content_47.phone,
content_47.rating,
content_47.owner_name,
content_47.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_47.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_47,users_editedprofiles WHERE content_47.state_id='8' AND users_editedprofiles.parentcategory_id='47' AND users_editedprofiles.content_id = content_47.id AND users_editedprofiles.plan_id != 0
             AND (content_47.category_id='49007' OR content_47.category_id='48990')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_5.id,
content_5.profileid,
content_5.URLid,
content_5.address_URLid,
content_5.userid,
content_5.parentcategory_id,
content_5.category_id,
content_5.company,
content_5.address,
content_5.city,
content_5.zip,
content_5.state,
content_5.county,
content_5.phone,
content_5.rating,
content_5.owner_name,
content_5.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_5.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_5,users_editedprofiles WHERE content_5.state_id='8' AND users_editedprofiles.parentcategory_id='5' AND users_editedprofiles.content_id = content_5.id AND users_editedprofiles.plan_id != 0
             AND (content_5.category_id='56547')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_41.id,
content_41.profileid,
content_41.URLid,
content_41.address_URLid,
content_41.userid,
content_41.parentcategory_id,
content_41.category_id,
content_41.company,
content_41.address,
content_41.city,
content_41.zip,
content_41.state,
content_41.county,
content_41.phone,
content_41.rating,
content_41.owner_name,
content_41.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_41.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_41,users_editedprofiles WHERE content_41.state_id='8' AND users_editedprofiles.parentcategory_id='41' AND users_editedprofiles.content_id = content_41.id AND users_editedprofiles.plan_id != 0
             AND (content_41.category_id='56891' OR content_41.category_id='48919')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50             UNION 
 SELECT
content_25.id,
content_25.profileid,
content_25.URLid,
content_25.address_URLid,
content_25.userid,
content_25.parentcategory_id,
content_25.category_id,
content_25.company,
content_25.address,
content_25.city,
content_25.zip,
content_25.state,
content_25.county,
content_25.phone,
content_25.rating,
content_25.owner_name,
content_25.plan_id,

            users_editedprofiles.plan_id as theplan_id,content_25.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_25,users_editedprofiles WHERE content_25.state_id='8' AND users_editedprofiles.parentcategory_id='25' AND users_editedprofiles.content_id = content_25.id AND users_editedprofiles.plan_id != 0
             AND (content_25.category_id='52706' OR content_25.category_id='51590')
            
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50 ORDER BY distance asc, theplan_id DESC, rating DESC) as t1 UNION SELECT * FROM (             SELECT
content_17.id,
content_17.profileid,
content_17.URLid,
content_17.address_URLid,
content_17.userid,
content_17.parentcategory_id,
content_17.category_id,
content_17.company,
content_17.address,
content_17.city,
content_17.zip,
content_17.state,
content_17.county,
content_17.phone,
content_17.rating,
content_17.owner_name,
content_17.plan_id,

            0 as nf_plan_id,content_17.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_17 WHERE 
            state_id='8' 
            
             AND (content_17.category_id='53167' OR content_17.category_id='53300' OR content_17.category_id='57445' OR content_17.category_id='53097' OR content_17.category_id='529' OR content_17.category_id='49211' OR content_17.category_id='51361' OR content_17.category_id='53023' OR content_17.category_id='51614' OR content_17.category_id='53681' OR content_17.category_id='51345' OR content_17.category_id='53873' OR content_17.category_id='49206' OR content_17.category_id='49193' OR content_17.category_id='53853' OR content_17.category_id='410' OR content_17.category_id='18' OR content_17.category_id='51216' OR content_17.category_id='49204' OR content_17.category_id='53176' OR content_17.category_id='53032' OR content_17.category_id='51600' OR content_17.category_id='49197' OR content_17.category_id='60139' OR content_17.category_id='51602' OR content_17.category_id='50994' OR content_17.category_id='52266' OR content_17.category_id='57022' OR content_17.category_id='51743' OR content_17.category_id='49194' OR content_17.category_id='51585' OR content_17.category_id='51851' OR content_17.category_id='51744' OR content_17.category_id='52736' OR content_17.category_id='49198' OR content_17.category_id='205' OR content_17.category_id='46172' OR content_17.category_id='358' OR content_17.category_id='52947' OR content_17.category_id='46145')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_70.id,
content_70.profileid,
content_70.URLid,
content_70.address_URLid,
content_70.userid,
content_70.parentcategory_id,
content_70.category_id,
content_70.company,
content_70.address,
content_70.city,
content_70.zip,
content_70.state,
content_70.county,
content_70.phone,
content_70.rating,
content_70.owner_name,
content_70.plan_id,

            0 as nf_plan_id,content_70.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_70 WHERE 
            state_id='8' 
            
             AND (content_70.category_id='51510' OR content_70.category_id='53874')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_9.id,
content_9.profileid,
content_9.URLid,
content_9.address_URLid,
content_9.userid,
content_9.parentcategory_id,
content_9.category_id,
content_9.company,
content_9.address,
content_9.city,
content_9.zip,
content_9.state,
content_9.county,
content_9.phone,
content_9.rating,
content_9.owner_name,
content_9.plan_id,

            0 as nf_plan_id,content_9.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_9 WHERE 
            state_id='8' 
            
             AND (content_9.category_id='228' OR content_9.category_id='693')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_30.id,
content_30.profileid,
content_30.URLid,
content_30.address_URLid,
content_30.userid,
content_30.parentcategory_id,
content_30.category_id,
content_30.company,
content_30.address,
content_30.city,
content_30.zip,
content_30.state,
content_30.county,
content_30.phone,
content_30.rating,
content_30.owner_name,
content_30.plan_id,

            0 as nf_plan_id,content_30.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_30 WHERE 
            state_id='8' 
            
             AND (content_30.category_id='51820' OR content_30.category_id='87')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_80.id,
content_80.profileid,
content_80.URLid,
content_80.address_URLid,
content_80.userid,
content_80.parentcategory_id,
content_80.category_id,
content_80.company,
content_80.address,
content_80.city,
content_80.zip,
content_80.state,
content_80.county,
content_80.phone,
content_80.rating,
content_80.owner_name,
content_80.plan_id,

            0 as nf_plan_id,content_80.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_80 WHERE 
            state_id='8' 
            
             AND (content_80.category_id='44296' OR content_80.category_id='54278' OR content_80.category_id='180')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_97.id,
content_97.profileid,
content_97.URLid,
content_97.address_URLid,
content_97.userid,
content_97.parentcategory_id,
content_97.category_id,
content_97.company,
content_97.address,
content_97.city,
content_97.zip,
content_97.state,
content_97.county,
content_97.phone,
content_97.rating,
content_97.owner_name,
content_97.plan_id,

            0 as nf_plan_id,content_97.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_97 WHERE 
            state_id='8' 
            
             AND (content_97.category_id='53293')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_47.id,
content_47.profileid,
content_47.URLid,
content_47.address_URLid,
content_47.userid,
content_47.parentcategory_id,
content_47.category_id,
content_47.company,
content_47.address,
content_47.city,
content_47.zip,
content_47.state,
content_47.county,
content_47.phone,
content_47.rating,
content_47.owner_name,
content_47.plan_id,

            0 as nf_plan_id,content_47.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_47 WHERE 
            state_id='8' 
            
             AND (content_47.category_id='49007' OR content_47.category_id='48990')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_5.id,
content_5.profileid,
content_5.URLid,
content_5.address_URLid,
content_5.userid,
content_5.parentcategory_id,
content_5.category_id,
content_5.company,
content_5.address,
content_5.city,
content_5.zip,
content_5.state,
content_5.county,
content_5.phone,
content_5.rating,
content_5.owner_name,
content_5.plan_id,

            0 as nf_plan_id,content_5.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_5 WHERE 
            state_id='8' 
            
             AND (content_5.category_id='56547')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_41.id,
content_41.profileid,
content_41.URLid,
content_41.address_URLid,
content_41.userid,
content_41.parentcategory_id,
content_41.category_id,
content_41.company,
content_41.address,
content_41.city,
content_41.zip,
content_41.state,
content_41.county,
content_41.phone,
content_41.rating,
content_41.owner_name,
content_41.plan_id,

            0 as nf_plan_id,content_41.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_41 WHERE 
            state_id='8' 
            
             AND (content_41.category_id='56891' OR content_41.category_id='48919')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
                         UNION 
 SELECT
content_25.id,
content_25.profileid,
content_25.URLid,
content_25.address_URLid,
content_25.userid,
content_25.parentcategory_id,
content_25.category_id,
content_25.company,
content_25.address,
content_25.city,
content_25.zip,
content_25.state,
content_25.county,
content_25.phone,
content_25.rating,
content_25.owner_name,
content_25.plan_id,

            0 as nf_plan_id,content_25.id as content_id,TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) AS distance FROM content_25 WHERE 
            state_id='8' 
            
             AND (content_25.category_id='52706' OR content_25.category_id='51590')
             AND TRUNCATE((DEGREES(ACOS(SIN(RADIANS(37.41780090332)) * SIN(RADIANS(lat)) + COS(RADIANS(37.41780090332)) * COS(RADIANS(lat)) * COS(RADIANS(-122.17199707031 - `long`)) )) * 60 * 1.1515),1) < 50
            AND plan_id = 0 
             ORDER BY distance asc, rating DESC) as t2  LIMIT 0,10 DB:businessdir_dec22 / businessdir<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta style="display: block; zoom: 1;" http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" id="viewport" />
<script>
 var viewport = document.getElementById('viewport');
 var content = screen.width<=480 ? "width=device-width,initial-scale=1" : "width=768px, minimum-scale=1.0, maximum-scale=1.0";
 viewport.setAttribute("content", content);
// var content = navigator.userAgent.match(/iPhone/i) || navigator.userAgent.match(/iPod/i) ? "width=device-width,initial-scale=1" : "width=768px, minimum-scale=1.0, maximum-scale=1.0";
</script>
<!--<meta name="viewport" content="width=device-width,initial-scale=1"/>-->
<meta name="robots" content="index, follow"/>
 

<title>Business Services Companies In Your Local Area Or State</title>
<meta name="description" content="Business Services Companies In Your Local Area Or State will keep their profiles up to date so you can easily get their Phone Numbers, Address, Reviews, or Business Hours"/>
<meta name="keywords" content="Business Services,company,reviews,directions"/>
<meta name="revisit-after" content="1 days"/>
<meta name="rating" content="general"/>
<meta property="og:title" content="Business Services Companies In Your Local Area Or State" />
<meta property="og:type" content="website" />
<meta property="og:url" content="http://www.majon.com/local/business-services" />
<meta property="og:site_name" content="Majon Marketing & Advertising Businesses" />
 
  
 

<link href="http://www.majon.com/local/v3styles/profile.css" type="text/css" rel="stylesheet"/>
<link rel="next" href='http://www.majon.com/local/business-services/2'>


<link href="http://www.majon.com/local/v3styles/fonts.css" type="text/css" rel="stylesheet"/>


<!--if IE>
    <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<!endif-->

<!--if IE 6>
<link rel="stylesheet" href="ie/ie6.css" type="text/css" />
<!endif-->

<!--if IE 7>
<link rel="stylesheet" href="ie/ie7.css" type="text/css" />
<!endif-->

<!--if IE 8>
<link rel="stylesheet" href="ie/ie8.css" type="text/css" />
<!endif-->

<script type="text/javascript">

  var _gaq = _gaq || [];
_gaq.push(
  ['_setAccount', 'UA-315230-1'],
  ['_trackPageview'],
  ['b._setAccount', 'UA-315230-9'],
  ['b._trackPageview']
);
  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>

<script type="text/javascript">

function loadjscssfile(filename, filetype){
 if (filetype=="js"){ //if filename is a external JavaScript file
  var fileref=document.createElement('script')
  fileref.setAttribute("type","text/javascript")
  fileref.setAttribute("src", filename)
 }
 else if (filetype=="css"){ //if filename is an external CSS file
  var fileref=document.createElement("link")
  fileref.setAttribute("rel", "stylesheet")
  fileref.setAttribute("type", "text/css")
  fileref.setAttribute("href", filename)
 }
 if (typeof fileref!="undefined")
  document.getElementsByTagName("head")[0].appendChild(fileref)
}

// JavaScript Document
var winW = 0, winH = 0;

function loadcss(loadtype) {
if (parseInt(navigator.appVersion)>3) {
if (navigator.appName=="Netscape") {
winW = window.innerWidth-16;
winH = window.innerHeight-16;
}
if (navigator.appName.indexOf("Microsoft")!=-1) {
winW = screen.width;
winH = screen.height;
}
}
if (winW <=768) {
loadjscssfile("http://www.majon.com/local/v3styles/phone.css", "css");
} else if(loadtype!='initial') {

}


}


window.onresize = function(event) {
loadcss('resize');  
}
loadcss('initial'); 

</script>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js" type="text/javascript"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.21/jquery-ui.min.js" type="text/javascript"></script>

<script type="text/javascript" src="http://www.majon.com/local/javascript/alljs.js"></script>

</head>

<body class="search-business-page" id="body">
<!--startbody-->
<header>

	


	<div class="header-top">
    	<div class="header-top-content globalwidth">
        	<div class="logo">
            <a href="http://www.majon.com"><img src="/local/v3images/logo.png" alt="majon-logo"/></a>
            </div><!--logo-->
            
			<div style="float:left; position:relative; margin-left:7px; margin-top:20px;">
			<font color="#b3ad15" size="3"><b><i>The Social Business Directory for Your Community!</i></b></font>
			<br>
				<div style="margin-left:60px; font-style:italic; color:#b3ad15; font-size:12px; font-weight:bold; ">
			Search - Social Reviews - Directions - Phone Numbers & More!
			</div>
			</div>
		
			
			
            <div class="header-top-right">
		<div class="account-option" id="loggedin" style="display:none;">
                	<a href="#" class="user"><span id="email"></span></a>
                     <span class="separator"></span>                    
                     <div class="user-account corner-radius" style="display:none;">
                                                        
                            
                            <ul class="top">
                            	<li><a href="/local/members">PROFILE</a></li>
                                      <ul>
								    <li><a href="/local/profile/profile_search_members.php?go=addbulk">ADD NEW BUSINESS</a></li>
                                    <li><a href="/local/members/businesses.php">MY BUSINESSES</a></li>
                                    <li><a href="/local/members/billing.php">BILLING</a></li>
                               
                              
                                    </ul>
                             <li><a href="/local/members/support.php">CUSTOMER SUPPORT</a></li>
                               
                            </ul>
                            
                             <ul class="bottom">
                                <li><a href="/local/members/profile.php">SETTINGS</a></li>
                                <li><a href="/local/auth/login.php?go=logout">LOG OUT</a></li>
                                
                            </ul>
							<script type="text/javascript">
                            $(".user").click(function () {
                            $(".user-account").slideToggle("slow");
                            });
                            </script>
                        
                        </div><!--signin-form-->
                </div><!--account-option-->
            	<div class="account-option" id="signin">
				
               <a href="http://www.majon.com/local/order/register.php?go=continue"> Sign Up</a> <span>|</span> <A href="/local/auth/login.php">Login</a>
                    
                    
                     <div class="signin-form corner-radius" id="signin-form" style="display:none;">
                         <ul class="social-link">
                            <li><a href="/local/media_login/loginhandler.php?r=66896&go=login_and_return&media_type=linkedin" class="linkedin">Linkedin</a></li>
                            <li><a href="/local/media_login/loginhandler.php?r=66896&go=login_and_return&media_type=facebook" class="facebook">Facebook</a></li>
                            <li><a href="/local/media_login/loginhandler.php?r=66896&go=login_and_return&media_type=twitter" class="twitter">Twitter</a></li>
                            <li><a href="/local/media_login/loginhandler.php?r=66896&go=login_and_return&media_type=google" class="gplus">Google+</a></li>
                            </ul>
                            
							<center><A href="/local/auth/register.php">Register Now</a></center>
							
                            <form action="/local/auth/login.php" method="POST">
<input type=hidden name="go" value="login">
                            	<p><label>Email:</label><input type="email" class="input_txt" name="email" id="email"/></p>
                                <p><label>Password:</label><input type="password" class="input_txt" value="" name="password" id="password"/></p>
                                 <p><span class="left"><a href="/local/auth/login.php#forgotpass">forget password?</a></span><span class="right"><input type="submit" class="signin-btn green-button" value="Sign In"/></span></p>
                            </form>
                            <script type="text/javascript">
                            $("#signinlink").click(function () {
                            $("#signin-form").slideToggle("slow");
                            });
                            </script>
                        
                        </div><!--signin-form-->
                </div><!--account-option-->
                
                <div class="navi-links">
                 <p class="add-button"><a href="/local/order/register.php?go=continue" class="corner-radius">Add My Business</a></p>
                <nav>
                	<ul>
                    	<li><a href="/local"><span>Why Local</span></a></li>
                        <li><a href="/local/featured-business-program.html"><span>What You Get</span></a></li>
                    </ul>
                </nav><!--nav-->
                
               
                </div><!--nav-links-->
                
            </div><!--header-top-right-->
            
        </div><!--header-top-content-->
    </div><!--header-top-->



     <div class="header-bottom" id="searchbar">
	 
	 
       
	 <div id="displaysearching" class="displaysearching">
	  <div class="displaysearching_loading" style="display:none;">
	 <img src="http://www.majon.com/local/v3images/ajax-loader.gif"> Please wait...
	 </div>
	 </div>


<style>
.ui-autocomplete {
                max-height: 150px;
                overflow-y: auto;
                /* prevent horizontal scrollbar */
                overflow-x: hidden;
                /* add padding to account for vertical scrollbar */
                padding-right: 20px;
        }

</style>

<link href="http://www.majon.com/local/javascript/jquery/redmond/jquery-ui-1.8.16.custom.css" rel="stylesheet" type="text/css"/>

<script>
$(document).ready(function() {
  $( "#locationtxt" ).autocomplete({
        source: "http://www.majon.com/local/locsearch.php",
        minLength: 2,
        select: function( event, ui ) {
             doLocation(ui.item.label,ui.item.id);
             return false;
             },
        close:  function() {
        }

    });

   function doLocation(name,id) {
       $("#locationtxt").val(name);
   }
});

</script>

	 
    	<div class="search-box globalwidth">
        	<form action="http://www.majon.com/local/search/search_results.php" onsubmit="">
            	<p>
                	<label>SEARCH HERE:</label>
					<input type="hidden" name="search_location" id="search_location" value="">
                    <input type="text" name="searchtxt" value=" " class="input_txt" onBlur="if (this.value == '') {this.value = 'Search Field:';}" onFocus="if (this.value == 'Search Field:') {this.value = '';}"/>
                </p>

<div style="text-align:center;">
<div class="search_field">

<input type=hidden name="usegps" id="usegps" value="0">
<input type=hidden name="userlocationtxt" id="userlocationtxt" value="Stanford, CA">
                    <input type="text" value="Stanford, CA"  class="location_txt" id="locationtxt" name="locationtxt" onBlur="if (this.value == '') {this.value = 'Location Field:';}" onFocus="if (this.value == 'Location Field:') {this.value = '';}"/>
<a href="#" class="search_field_button" onClick="document.getElementById('locationtxt').value=document.getElementById('userlocationtxt').value;document.getElementById('usegps').value=1;return false;"><img src="http://www.majon.com/local/v3images/gps-icon.png" alt="Use GPS Location"></a>
</div>
                    <input type="submit" onClick="displaysearching('anywhere'); this.form.submit();" value="&nbsp;" class="search-btn"/>                  


<div class="googlesearchbox" style="float:right; margin-top:-10px; width:250px; height:37px; overflow:hidden;">

            </form>
<form action="http://www.majon.com/local/googleresults.php" id="cse-search-box">

    <input type="hidden" name="cx" value="partner-pub-7281988974135432:7206808688" />
    <input type="hidden" name="cof" value="FORID:10" />
    <input type="hidden" name="ie" value="UTF-8" />
    <input type="text" name="q" size="25" />
    <input type="submit" name="sa" value="Search" />
  </div>
</form>
                  
</div>					
	

  

<script type="text/javascript" src="http://www.google.com/coop/cse/brand?form=cse-search-box&amp;lang=en"></script>



        </div><!--search-box-->
    </div><!--header-bottom-->
<div class="header-bottom">
    	<div class="search-box globalwidth">
        	<div class="introduce">
             	 <h1 class="cat-title">Local Business Services Companies in California (CA)
</h1>
                
             </div>
        </div><!--search-box-->
    </div><!--header-bottom-->
</header><!--header-->

<div id="maincontent" class="main-content">
    <div class="primary globalwidth">
            	<div class="breadcrumb bottom">
                	<span>Navigation:</span>
                	<nav>
                    		<ul>
                                                            <li><a href="http://www.majon.com/local">Home</a></li>
                            	<li itemscope itemtype="http://data-vocabulary.org/Breadcrumb"><a href="http://www.majon.com/local/business-services" itemprop="url"><span itemprop="title">Business Services</span></a></li>                                
                            </ul>
                    </nav>
                </div><!--breadcrump-->
                
                 <div class="sidebar sidebar-box left">
                   
                          <aside class="widget corner-radius categories">
                        <p class="widget-title corner-top">Order results by:</p>
                        <div class="whitebox corner-bottom">
         
<a rel="nofollow"  href="javascript:category_sort('all');">Display All</a><Br>
<a rel="nofollow" class="boldlink" href="javascript:category_sort('distance');"><img src='/local/v3images/icon-arrow-sort-up.png' border=0>Distance</a><Br><a  href="javascript:radius_sort('2');">2 miles</a><Br>
<a  href="javascript:radius_sort('5');">5 miles</a><Br>
<a  href="javascript:radius_sort('10');">10 miles</a><Br>
<a  href="javascript:radius_sort('20');">20 miles</a><Br>
<a  href="javascript:radius_sort('30');">30 miles</a><Br>
<a class="boldlink" href="javascript:radius_sort('50');">50 miles</a><Br>
<a  href="javascript:radius_sort('100');">100 miles</a><Br>
<a  href="javascript:radius_sort('500');">500 miles</a><Br><br><a rel="nofollow"  href="javascript:category_sort('alphabetical');">Alphabetical</a><Br>
<a rel="nofollow"  href="javascript:category_sort('rating');">Rating</a><Br>
<a rel="nofollow"  href="javascript:category_sort('athroughz');">A-Z</a>
<div id="athroughz"></div>
                        </div><!--categories-->
                        </aside>




  <aside class="widget corner-radius categories">
                        <p class="widget-title corner-top">Sponsored Links</p>
   <div class="whitebox corner-bottom" style="margin-left:0px; padding:0px;">
     <script type="text/javascript"><!--
        google_ad_client = "ca-pub-7281988974135432";
        google_ad_slot = "7539830998";
        google_ad_width = "300";
        google_ad_height = "250";
//-->
        </script >
<script type = "text/javascript"
src ="http://pagead2.googlesyndication.com/pagead/show_ads.js" >
</script >

   </div>
                       </aside>



                    
                     <aside class="widget corner-radius categories"> 
                        <p class="widget-title corner-top">Categories</p>
                        <div class="whitebox corner-bottom">
                        <ul><li><a href="http://www.majon.com/local/advertising">Advertising</a></li><li><a href="http://www.majon.com/local/advertisingcomputer">Advertising-Computer</a></li><li><a href="http://www.majon.com/local/advertisingmagazine">Advertising-Magazine</a></li><li><a href="http://www.majon.com/local/advertisingpromotional">Advertising-Promotional</a></li><li><a href="http://www.majon.com/local/advertisingtelevision">Advertising-Television</a></li><li><a href="http://www.majon.com/local/auctioneers">Auctioneers</a></li><li><a href="http://www.majon.com/local/billing-service">Billing Service</a></li><li><a href="http://www.majon.com/local/building-inspection-service">Building Inspection Service</a></li><li><a href="http://www.majon.com/local/business-associations">Business Associations and Trade Organizations</a></li><li><a href="http://www.majon.com/local/business-forms-systems-wholesale">Business Forms amd Systems</a></li><li><a href="http://www.majon.com/local/business-support-service">Business Support Service</a></li>            <div id="morecategories_link"><a href="#" onClick="document.getElementById('morecategories').style.display='block';document.getElementById('morecategories_link').style.display='none';return false;">More Categories...</a></div>
            <div id="morecategories" style="display:none;"><li><a href="http://www.majon.com/local/garment-pressing-and-cleaners-agents">Cleaners and Dry Cleaners</a></li><li><a href="http://www.majon.com/local/collection-agencies">Collection agencies</a></li><li><a href="http://www.majon.com/local/commercial-artgraphic-design">Commercial Art/graphic Design</a></li><li><a href="http://www.majon.com/local/computer-graphics">Computer Graphics</a></li><li><a href="http://www.majon.com/local/computer-maintenance-and-repair">Computer Maintenance and Repair</a></li><li><a href="http://www.majon.com/local/computer-services">Computer Services</a></li><li><a href="http://www.majon.com/local/computer-systems-design">Computer Systems Design</a></li><li><a href="http://www.majon.com/local/copying-duplicating-services">Copying & Duplicating Services</a></li><li><a href="http://www.majon.com/local/detectivearmored-car-services">Detective/armored Car Services</a></li><li><a href="http://www.majon.com/local/direct-mail-advertising-services">Direct Mail Advertising Services</a></li><li><a href="http://www.majon.com/local/distribution-services">Distribution Services</a></li><li><a href="http://www.majon.com/local/editorial-services">Editorial Services</a></li><li><a href="http://www.majon.com/local/estate-sales">Estate Sales</a></li><li><a href="http://www.majon.com/local/freight-transportation-arrangement">Freight Services</a></li><li><a href="http://www.majon.com/local/inventory-service">Inventory Service</a></li><li><a href="http://www.majon.com/local/janitor-service">Janitor Service</a></li><li><a href="http://www.majon.com/local/linen-supply">Linen and Uniform Supply and Rental</a></li><li><a href="http://www.majon.com/local/lithographers">Lithographers</a></li><li><a href="http://www.majon.com/local/lot-cleaners">Lot Cleaners</a></li><li><a href="http://www.majon.com/local/merchandise-brokers">Merchandise Brokers</a></li><li><a href="http://www.majon.com/local/office-furniture-interior-design">Office Furniture - Interior Design</a></li><li><a href="http://www.majon.com/local/packaging-service">Packaging Service</a></li><li><a href="http://www.majon.com/local/personal-chefs">Personal Chefs</a></li><li><a href="http://www.majon.com/local/disinfecting-and-pest-control-services">Pest Control</a></li><li><a href="http://www.majon.com/local/photographerscommercial">Photographers-Commercial</a></li><li><a href="http://www.majon.com/local/plantsinterior-design-maintenance">Plants-Interior Design & Maintenance</a></li><li><a href="http://www.majon.com/local/printers">Printers</a></li><li><a href="http://www.majon.com/local/security-guard-patrol-service">Security Guard & Patrol Service</a></li><li><a href="http://www.majon.com/local/signsmaintenance-repairing">Signs-Maintenance & Repairing</a></li><li><a href="http://www.majon.com/local/telemarketing-services">Telemarketing Services</a></li><li><a href="http://www.majon.com/local/telephone-answering-services">Telephone answering services</a></li><li><a href="http://www.majon.com/local/vending-machines">Vending Machines and Operators</a></li><li><a href="http://www.majon.com/local/video-conferencing">Video Conferencing</a></li><li><a href="http://www.majon.com/local/window-cleaning">Window Cleaning</a></li></ul>                        	
                        </div><!--categories-->
                    </aside> <!--aside-->
                    

  <aside class="widget corner-radius categories">






   <div class="whitebox corner-bottom">

    <A href="http://www.majon.com/local/health-insurance-carriers/alabama/sipsey/medical-insurance-quote">medical insurance quote Sipsey AL</a> <br>

   </div>





  <aside class="widget corner-radius categories">
                        <p class="widget-title corner-top">Sponsored Links</p>
   <div class="whitebox corner-bottom" style="margin-left:0px; padding:0px;">
     <script type="text/javascript"><!--
        google_ad_client = "ca-pub-7281988974135432";
        google_ad_slot = "7539830998";
        google_ad_width = "300";
        google_ad_height = "250";
//-->
        </script >
<script type = "text/javascript"
src ="http://pagead2.googlesyndication.com/pagead/show_ads.js" >
</script >

   </div>
                       </aside>


<div style="width:120px; height:600px; float:right; margin-top:40px; clear:both;" id="skyscraper">
 <!-- ity.im Basic Code 120x600 POPUP ENABLED -->
<script type="text/javascript" src="http://ity.im/adserver_remote/adserver3.js"></script>
<script type="text/javascript">
var varsarray=[];
varsarray[0]='1';
varsarray[1]='1';
varsarray["nointer"]=1;
if(!token) {var token='0'} else {var token=token+1;}
var loadtype='0';
var adtype='3';
var background_color='#F0F0F0';
var border_color='#000000';
var text_color='#060606';
var text_rollcolor='#0033FF';
var domain_color='#9F9F9F';
varsarray['interhours']='';
varsarray['interpages']='';
adserver_initialize(token,loadtype,adtype,background_color,border_color,text_color,text_rollcolor,domain_color,varsarray);
</script>
</div>
                <br>

<div style="width:120px; height:600px; float:right; margin-top:40px; clear:both;" id="skyscraper">
<a href="http://www.majon.com/facebook-fans.html" target=_new><img src="http://www.optinemailpro.com/affiliate_banners/facebook-fans/facebook-fans_120x600.gif" border=0></a>
</div>

                    </aside> <!--aside-->

		
					
					
        
                </div><!--sidebar-->
               
	
				
				
                <div class="content right">

<div>     <script type="text/javascript"><!--
        google_ad_client = "ca-pub-7281988974135432";
        google_ad_slot = "0450156910";
        google_ad_width = "728";
        google_ad_height = "90";
//-->
        </script >
<script type = "text/javascript"
src ="http://pagead2.googlesyndication.com/pagead/show_ads.js" >
</script ></div>


                    <div class="pagenavi">
                            
                    	<ul>
            <li><a href="http://www.majon.com/local/business-services">&#171;</a></li>
            <li class="prev corner-radius"><a href="http://www.majon.com/local/business-services">Prev</a></li>&nbsp;&nbsp;<li class="current"><a href='http://www.majon.com/local/business-services'>1</a></li>
 <li ><a href='http://www.majon.com/local/business-services/2'>2</a></li>
 <li ><a href='http://www.majon.com/local/business-services/3'>3</a></li>
 <li ><a href='http://www.majon.com/local/business-services/4'>4</a></li>
  <li class="next corner-radius"><a href='http://www.majon.com/local/business-services/2'>Next &#155;</a></li>  <li><a href='http://www.majon.com/local/business-services/904' class="pagelink">&#187;</a></li>
</ul>
       <div class="pagesdisplay">
Showing  <b>1</b> - <b>10</b> of <b>9039</b>
</div>

                
                    </div><!--pagenavi-->
                    
                    <div class="category-post">
                        
                        	<div class="category-post">
                    	
                        
                                <div class="post  skin2">
                        	<div class="top-details">
                        
                            
                            <div class="entry">
                            	<div class="entry-header">
                                	<h2>We are sorry, no results were found.</h2>
									
									<Div style="float:left; width:100%;">
									<br><Br> <b>SEARCH TIPS:</b>
									<BR>
									<li><b>-</b> Check to make sure the location is correct, type in your location in the search box above.</li>
									<li><b>-</b> Make sure your search phrase is correct.<Br><u>examples:
									Car Repair, Braums, Pizza Hut, Hair Salons.</u></li>
                                    </div>
                                 
                                </div>
                                
                
                   
                            </div><!--entry-->
                            
                            </div><!--top-details-->
                        
                        </div><!--div--featured-->    


                        
                    </div>





      <Center>


    <!-- ity.im Basic Code 728x90 POPUP ENABLED -->
<script type="text/javascript" src="http://ity.im/adserver_remote/adserver2.js"></script>
<script type="text/javascript">
var varsarray=[];
varsarray[0]='1';
varsarray[1]='1';
if(!token) {var token='0'} else {var token=token+1;}
var loadtype='0';
var adtype='2';
var background_color='#F0F0F0';
var border_color='#000000';
var text_color='#060606';
var text_rollcolor='#0033FF';
var domain_color='#9F9F9F';
varsarray['interhours']='';
varsarray['interpages']='';
adserver_initialize(token,loadtype,adtype,background_color,border_color,text_color,text_rollcolor,domain_color,varsarray);
</script>

</center>  <br>





<div style="float:left; margin-top:10px; width:100%;">


<br>
                <div style="width:100%;">
               <div class="adbox" style="margin-right:5px; min-width:230px;">
	<div class="moduletable" style="margin-right:5px; min-width:230px;">

		<center>
		<a href="http://www.majon.com/video-creation.html" title="HD Video Creation/Promotion" target="_new">
		<img src="http://www.optinemailpro.com/affiliate_banners/HDVideo2_230X125.gif" alt="HD Video Creation/Promotion" border="0"></a><br>
		<a href="http://www.majon.com/video-creation.html" title="HD Video Creation / Promotion" target="_new">HD Video Creation/Promotion</a></center>
       </div>
</div>
<div class="adbox" style="margin-right:5px; min-width:230px;">
	<div class="moduletable" style="margin-right:5px; min-width:230px;">
		<center>
		<a href="http://www.majon.com/facebook-fans.html" title="Facebook Fans" target="_new">
		<img src="http://www.optinemailpro.com/affiliate_banners/FacebookFans_230X125.gif" alt="Facebook Fans" border="0"></a><br>
		<a href="http://www.majon.com/facebook-fans.html" alt="facebook fans" target="_new">Get Facebook Fans</a></center>
       </div>
</div>
<div class="adbox" style="margin-right:5px; min-width:230px;">
	<div class="moduletable" style="min-width:230px;">
		<center>
		<a href="http://www.majon.com/business-links.html" title="Quality Web Links" target="_new">
		<img src="http://www.optinemailpro.com/affiliate_banners/QualityWebLinks-230x125.gif" alt="Quality Web Links" border="0"></a><br>
		<a href="http://www.majon.com/business-links.html" alt="search engine marketing" target="_new">Quality Website Links</a></center>
       </div>
       </div>
</div>



</div>




                    </div><!--category-post-->


                    <div class="pagenavi">
                            
                    	<ul>
            <li><a href="http://www.majon.com/local/business-services">&#171;</a></li>
            <li class="prev corner-radius"><a href="http://www.majon.com/local/business-services">Prev</a></li>&nbsp;&nbsp;<li class="current"><a href='http://www.majon.com/local/business-services'>1</a></li>
 <li ><a href='http://www.majon.com/local/business-services/2'>2</a></li>
 <li ><a href='http://www.majon.com/local/business-services/3'>3</a></li>
 <li ><a href='http://www.majon.com/local/business-services/4'>4</a></li>
  <li class="next corner-radius"><a href='http://www.majon.com/local/business-services/2'>Next &#155;</a></li>  <li><a href='http://www.majon.com/local/business-services/904' class="pagelink">&#187;</a></li>
</ul>
       <div class="pagesdisplay">
Showing  <b>1</b> - <b>10</b> of <b>9039</b>
</div>
                    </div><!--pagenavi-->
				
				

                    
                </div><!--content-->
                
               
           
        
    </div><!--primary-->
	
	
					 
		
<div id="floatleft" class="traffic-info2 corner-radius2" style="width:250px; display:none;">
<div class="banner-list2 left">
        <h2 class="green-title">   More Sales, More Profits with Majon!</h2>
<ul>
<li>FEATURED Businesses Get More Sales</li>
<li>Move Your Business to the TOP </li>
<li>Remove Competitors from Your Profile</li>
<li>Featured In The TOPS of Up to 5 Cities</li>
</ul>
<h2 class="green-title">Claim Your Profile today...</h2>
            </div>
</div>			

			   
		
	
	
</div><!--main-content-->

<footer>
<script>

 var ajax = new sack();
 ajax.execute=true;
 ajax.requestFile = "/local/ajaxoperations/checklogin.php";
 ajax.method = 'GET';
 ajax.runAJAX();

</script>
    <div class="footer-top">
        <div class="footer-widget-area globalwidth">
        	<div class="widget-area first">
            		<div class="footerlinks">
                	<h2>Majon International</h2>
                    <ul>
                    	<li><a href="http://www.majon.com/local/index.php">Home</a></li>
						<li><a href="http://www.majon.com/local/tos.php">Terms of Service</a></li>
                        <li><a href="http://www.majon.com/local/privacy.php">Privacy Policy</a></li>

                        <li><a href="http://www.majon.com/local/sitemap.php">Sitemap</a></li>

                        <li><a href="http://www.majon.com/local/copyright.php">Copyright&copy; 1995 - 2012</a></li>
                    </ul>
                </div><!--aside-->
                
               
            </div><!--widget-->
            
            <div class="widget-area second">
            		<div class="footerlinks">
                	<h2>Customer Support</h2>
                    <ul>
                    	<li><a href="http://www.majon.com/local/auth/login.php">Member login</a></li>
                        <li><a href="http://www.majon.com/local/contactus.php">Contact Us</a></li>
             
                        
                    </ul>
                </div><!--aside-->
                
                
            </div><!--widget-->
            
            <div class="widget-area third">
            		<div class="footerlinks">
                	<h2>Marketing</h2>
                    <ul>
                    	<li><a href="http://www.majon.com/services/improving-search-engine-ranking/">Majon Website Advertising</a></li>                      
                    	<li><a href="http://www.majon.com/social-advertising.html">Majon Social Advertising</a></li>                      
                    </ul>
                </div><!--aside-->

            </div><!--widget-->
            			
			
            <div class="widget-area fourth last">
            		<div class="footerlinks">
                	<h2>CONTACT US</h2>
                    <ul>
                    	<div>
Arroyo Grande, CA 93421<br />
Telephone (805) 270-5585<br />
</div>
                     
                    </ul>
                </div><!--aside-->
            </div><!--widget-->
			
			
     <div style="width:100%; float:left; clear:both;">
 	<center>
						<a href="http://santabarbara.bbb.org/business-reviews/Internet-Services/Majon-International-LLC-in-Arroyo-Grande-CA-5000589" target=_NEW>
						<img height="53" src="http://www.majon.com/images/bbb-transparent.gif" border=0></a>
						
						<a style="margin-left:8px;" href="http://www.majon.com/images/security-3916-header-gray.gif" target=_NEW>
						<img height="53" src="http://www.majon.com/images/security-3916-header-gray.gif" border=0></a>
						
						<a style="margin-left:8px;" href="http://verify.authorize.net/anetseal/?pid=411a8c82-f59e-44ac-9d69-e350f951e30c&rurl=http%3A//www.majon.com/" target=_NEW>
						<img height=53 src="http://www.majon.com/images/secure90x72.gif" border=0></a>
	</center>
<div>
<center>
<hr><span class="alphaNav">Business Profile Index:  <a href="/local/sitemap-maker/0">0</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/1">1</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/2">2</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/3">3</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/4">4</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/5">5</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/6">6</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/7">7</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/8">8</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/9">9</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/A">A</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/B">B</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/C">C</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/D">D</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/E">E</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/F">F</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/G">G</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/H">H</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/I">I</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/J">J</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/K">K</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/L">L</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/M">M</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/N">N</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/O">O</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/P">P</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/Q">Q</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/R">R</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/S">S</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/T">T</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/U">U</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/V">V</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/W">W</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/X">X</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/Y">Y</a>&nbsp;&nbsp;  <a href="/local/sitemap-maker/Z">Z</a>&nbsp;&nbsp; <hr>State Index:  <a href="/local/sitemap-maker/AK">AK</a>  <a href="/local/sitemap-maker/AL">AL</a>  <a href="/local/sitemap-maker/AR">AR</a>  <a href="/local/sitemap-maker/AZ">AZ</a>  <a href="/local/sitemap-maker/CA">CA</a>  <a href="/local/sitemap-maker/CO">CO</a>  <a href="/local/sitemap-maker/CT">CT</a>  <a href="/local/sitemap-maker/DC">DC</a>  <a href="/local/sitemap-maker/DE">DE</a>  <a href="/local/sitemap-maker/FL">FL</a>  <a href="/local/sitemap-maker/GA">GA</a>  <a href="/local/sitemap-maker/HI">HI</a>  <a href="/local/sitemap-maker/IA">IA</a>  <a href="/local/sitemap-maker/ID">ID</a>  <a href="/local/sitemap-maker/IL">IL</a>  <a href="/local/sitemap-maker/IN">IN</a>  <a href="/local/sitemap-maker/KS">KS</a>  <a href="/local/sitemap-maker/KY">KY</a>  <a href="/local/sitemap-maker/LA">LA</a>  <a href="/local/sitemap-maker/MA">MA</a>  <a href="/local/sitemap-maker/MD">MD</a>  <a href="/local/sitemap-maker/ME">ME</a>  <a href="/local/sitemap-maker/MI">MI</a>  <a href="/local/sitemap-maker/MN">MN</a>  <a href="/local/sitemap-maker/MO">MO</a>  <a href="/local/sitemap-maker/MS">MS</a> <br> <a href="/local/sitemap-maker/MT">MT</a>  <a href="/local/sitemap-maker/NC">NC</a>  <a href="/local/sitemap-maker/ND">ND</a>  <a href="/local/sitemap-maker/NE">NE</a>  <a href="/local/sitemap-maker/NH">NH</a>  <a href="/local/sitemap-maker/NJ">NJ</a>  <a href="/local/sitemap-maker/NM">NM</a>  <a href="/local/sitemap-maker/NV">NV</a>  <a href="/local/sitemap-maker/NY">NY</a>  <a href="/local/sitemap-maker/OH">OH</a>  <a href="/local/sitemap-maker/OK">OK</a>  <a href="/local/sitemap-maker/OR">OR</a>  <a href="/local/sitemap-maker/PA">PA</a>  <a href="/local/sitemap-maker/PR">PR</a>  <a href="/local/sitemap-maker/RI">RI</a>  <a href="/local/sitemap-maker/SC">SC</a>  <a href="/local/sitemap-maker/SD">SD</a>  <a href="/local/sitemap-maker/TN">TN</a>  <a href="/local/sitemap-maker/TX">TX</a>  <a href="/local/sitemap-maker/UT">UT</a>  <a href="/local/sitemap-maker/VA">VA</a>  <a href="/local/sitemap-maker/VT">VT</a>  <a href="/local/sitemap-maker/WA">WA</a>  <a href="/local/sitemap-maker/WI">WI</a>  <a href="/local/sitemap-maker/WV">WV</a>  <a href="/local/sitemap-maker/WY">WY</a> <hr></span>			
</center>
</div>	
     </div> 
		
            
        </div><!--footer-top-->
    </div><!--footer-top-->
    
    <div class="footer-bottom">
    	<div class="copyright globalwidth">
        	<p class="footer-logo"><a href="#"><img src="http://www.majon.com/local/v3images/footer-logo.png" alt=""/></a></p>
            <p class="copy_text">&copy; 2006-2012  Majon Inc. </p>
        </div><!--copyright-->
    </div><!--footer-bottom-->
    
</footer><!--footer-->




</div> <!--main-content-->

<!--endbody-->
</body></html