1,808 views

Speaktoit Assistant now available on Windows Phone 8 and Windows 8

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
select max(ID) as max_id from wp_yarpp_related_cache where reference_ID = 45872

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
select distinct ID from wp_yarpp_related_cache where reference_ID = 45872 and ID != 0

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 45872 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (1514,5,6,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (4371,7536,9815,5495,5450,576,8294,5496,9360,8295,8298,8297,8296), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '45872' and post_password ='' and post_type = 'post' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) union (SELECT 45872 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (1514,5,6,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (4371,7536,9815,5495,5450,576,8294,5496,9360,8295,8298,8297,8296), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '45872' and post_password ='' and post_type = 'page' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) union (SELECT 45872 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (1514,5,6,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (4371,7536,9815,5495,5450,576,8294,5496,9360,8295,8298,8297,8296), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '45872' and post_password ='' and post_type = 'attachment' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) on duplicate key update date = now()

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (45872,0,0) on duplicate key update date = now()

For those who are using Android Smartphones, Speaktoit Assistant is not something new. It is a Siri-like app with an avatar. Now, it is available on Windows Phone 8 and Windows 8.

Speaktoit - Yelp (Tablet Version)

I have downloaded the app. So far so good. The layout is clean and nice. However, since it is new, I have yet to explore everything. Here is some skills that Speaktoit Assistant has (for Windows Phone 8).

speaktoit-skills

Here is how you can get it.

Click Here to Download Speaktoit Assistant for Windows Phone 8

or

Click Here to Download Speaktoit Assistant for Windows 8

Subscribe

Subscribe to our e-mail newsletter to receive updates.

, , , , , , , , , , , ,