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_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 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 ORDER BY distance asc, theplan_id DESC, rating DESC) as t1 UNION SELECT * FROM ( 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 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_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 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 ORDER BY distance asc, theplan_id DESC, rating DESC) as t1 UNION SELECT * FROM ( 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 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