Incorrect parameter count in the call to native function 'RADIANS'
SELECT DISTINCT c.campaign_id FROM campaign c JOIN merchant m ON c.merchant_id = m.merchant_id WHERE c.campaign_live = 1 AND c.campaign_start <= '2011-09-27' AND c.campaign_expiration >= '2011-09-27 19:09:35' AND (c.campaign_gender = 1 OR c.campaign_gender = 0) AND c.campaign_age_start <= 24 AND c.campaign_age_end >= 24 AND (c.category_id1 IN(4,6,9,14,15,16,18,19,21,29,30,36,49) OR c.category_id2 IN(4,6,9,14,15,16,18,19,21,29,30,36,49) OR c.category_id3 IN(4,6,9,14,15,16,18,19,21,29,30,36,49) OR c.category_id4 IN(4,6,9,14,15,16,18,19,21,29,30,36,49) OR c.category_id5 IN(4,6,9,14,15,16,18,19,21,29,30,36,49) ) AND (c.campaign_zip = "" OR c.campaign_zip IS NULL OR c.campaign_zip IN( SELECT postal_code FROM postal2.postalcode WHERE (3959 * ACOS( COS( RADIANS() ) * COS( RADIANS( latitude ) ) * COS( RADIANS( longitude ) - RADIANS() ) + SIN( RADIANS() ) * SIN( RADIANS( latitude ) ) ) ) <= c.campaign_zip_radius )) ORDER BY c.campaign_rating DESC, RAND() LIMIT 0, 1
I think your expectations of what's to come in 9 years time is similar to people in the 80's expecting the world to be similar to The Jetsons when we hit the year 2000.
One thing I must point out is that, you think Facebook will cease to exist in 9 years time? What draws you to that kind of conclusion?
Another thing with your wording, you seem to be confusing "the internet" with "the web". You might want to look a little further into that before handing in your paper.
I agree with you. Alot of the applications seem to contradict themselves with massive descriptions on the features it contains, then because of the clause in which they say (this is only a toy) it somehow exempts them from providing any actual features that they have listed.
I wonder though, if any people are actually flagging these apps for apple to review and if so, why aren't they being audited and amended to show a true description of what the app really does.
I think the major issue is people's general lack of reading and research before they purchase these apps. They will read the brief description and think it's some savvy app.
BUYERS BEWARE! You must always read the full description!!!!