Shanky Phoenix

select p.id as pid,p.post_title,p.post_content,GROUP_CONCAT(cat.name ORDER BY cat.term_id SEPARATOR ',') as catname,cat.slug as catslug from wp_posts as p left join wp_term_relationships as r on  p.id = r.object_id  left join wp_term_taxonomy as t on r.term_taxonomy_id = t.term_taxonomy_id left join wp_terms as cat on t.term_id = cat.term_id where id in (select id from wp_posts) GROUP BY pid ORDER BY pid desc limit 0,10

select SQL_CALC_FOUND_ROWS from <tablename> where flag = 1 limit 10 and then select found_rows();

select * from (SELECT @row := @row + 1 as row1, t.* FROM cms_users t, (SELECT @row := 0) as r order by t.id) as n where n.row1  2

http://rpbouman.blogspot.com/2005/10/nesting-mysql-cursor-loops.html begin 01        declare no_more_rows boolean default false; 02        declare v_col1       int; 03        declare v_col2       int; 04        declare cursor1 cursor for 05            select col1 06            from   MyTable 07            ; 08        declare cursor2 cursor for 09            select col2 10            from   MyOtherTable 11        ...