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_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 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_136.*, users_editedprofiles.*, content_136.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_136,users_editedprofiles,assigned_categories WHERE content_136.id = '104700' AND users_editedprofiles.parentcategory_id='136' AND users_editedprofiles.content_id = content_136.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_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 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_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 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_136.*, users_editedprofiles.*, content_136.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_136,users_editedprofiles,assigned_categories WHERE content_136.id = '104700' AND users_editedprofiles.parentcategory_id='136' AND users_editedprofiles.content_id = content_136.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_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 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