BoonEx - Software Development & e-Commerce
Hello there! Would you like to sign in to your DreamSCat account?
 
(DreamSCat Member)
's bio:
Member's Home
Member's Articles
Member's Comments

AUTHOR'S LATEST

ffffff
ffeeeeeeeeeeeeeee eeeeeeeeeeeeee zzzzzzzzzzzzzzzz
 08/04/08   Science   By
Follow me
Follow me
 05/12/07   Fun   By
caede
afsdfds
 12/06/07   Science   By
The Thanksgiving food ever
Me and my family knows how to cook the best thanksgiving ...
 16/11/06   Cakes & ...   By
Height
Hi I dream last night that i am getting tall but not that ...
 05/10/05   Miracles   By
my boyfriend
hiya i have a boyfriend that i met in summerset and he ...
 21/09/05   Dating   By
DB Error: syntax error
SELECT t1.*, t2.id author_id, t2.username, SUM(`points`) AS rate, t4.name category_name, IF(!ISNULL(t1.story_avatar), t1.story_avatar, t2.avatar) AS avatar, IF(!ISNULL(t1.story_avatar), t1.story_avatar_ext, t2.avatar_ext) AS avatar_ext, IF(!ISNULL(t1.story_avatar), 1, 0) AS is_story_avatar FROM `amc_stories` t1 LEFT JOIN `amc_accounts` t2 ON t1.id_amc_accounts = t2.id INNER JOIN `amc_polls_stories` t3 ON t1.id = t3.id_story LEFT JOIN `amc_story_categories` t4 ON t1.category = t4.id WHERE t1.status<>'deleted' AND t1.status<>'disapproved' t1.id_amc_accounts > 0 AND (t2.status = 'approval' OR t2.status = 'active') GROUP BY t1.id ORDER BY rate DESC LIMIT 10 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't1.id_amc_accounts > 0 AND (t2.status = 'approval' OR t2.status = 'active') GROU' at line 1]