Jump to content

shan2batman

Members
  • Content count

    90
  • Joined

  • Last visited

Community Reputation

0 Neutral

About shan2batman

  • Rank
    Regular Member
  1. i understand pm your email ill send the sql file it is not live so it aint harmful.@barand
  2. plus i'm willing to give data as it is not live
  3. i added another table here just posted to let you know the changes.Plus isn't there any way for me to get those unique values???? @Barand
  4. here is an update on the results: gp_id pid gname author_gp type title data pdate vote_up vote_down user_id_g group_id comment_id comment_body time_c os_id author_c type_c vote_up_c vote_down_c user_id_c gm_id gname mname approved admin g_id name creation logo invrule creator description update_id update_body url time host vote_up vote_down title user_id_u account_name author type data uname avatar user_id 1 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 19 17 MEP news shan2batman 1 this is a second comment 2018-09-24 12:32:39 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 19 17 MEP news shan2batman 1 this is a second comment 2018-09-24 12:32:39 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 19 17 MEP news shan2batman 1 this is a second comment 2018-09-24 12:32:39 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 19 17 MEP news shan2batman 1 this is a second comment 2018-09-24 12:32:39 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 19 17 MEP news shan2batman 1 this is a second comment 2018-09-24 12:32:39 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 297 Hi, @aboutthecreator i welcome you to myexpresspad 2016-09-25 16:53:01 0 0 lets test this message 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 297 Hi, @aboutthecreator i welcome you to myexpresspad 2016-09-25 16:53:01 0 0 lets test this message 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 19 17 MEP news shan2batman 1 this is a second comment 2018-09-24 12:32:39 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 297 Hi, @aboutthecreator i welcome you to myexpresspad 2016-09-25 16:53:01 0 0 lets test this message 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 299 what to expect from <a class="twitter-hashtag pret... 2016-11-04 03:54:27 0 0 my first post 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 299 what to expect from <a class="twitter-hashtag pret... 2016-11-04 03:54:27 0 0 my first post 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 19 17 MEP news shan2batman 1 this is a second comment 2018-09-24 12:32:39 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 299 what to expect from <a class="twitter-hashtag pret... 2016-11-04 03:54:27 0 0 my first post 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 16 0 MEP news shan2batman 0 how do i overcome the problems lets see how it works after i delete group posts 2018-09-24 11:55:44 0 0 0 25 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 304 i'm on cloud nine 2016-12-07 10:22:14 0 0 oooh yeah 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 18 16 MEP news shan2batman 1 this is a comment 2018-09-24 12:31:48 0 0 0 0 2 this is a profile comment 2018-09-24 12:36:21 302 shan2batman b 0 0 127 1 MEP news aboutthecreator 1 1 NULL NULL NULL NULL NULL NULL NULL 304 i'm on cloud nine 2016-12-07 10:22:14 0 0 oooh yeah 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 here is the query: select distinct g.* ,cu.*,gm.*,gp.*,up.*, u.uname,u.avatar,u.user_id from group_posts as g left join user as u on u.uname=g.author_gp left join updates as up on up.author=u.uname left join groups as gp on g.group_id=gp.g_id left join gmembers as gm on gm.gname=g.gname inner join comment_update as cu on cu.author_c=up.author where g.gname='MEP news' and u.uname='shan2batman' GROUP by g.data,up.update_body having u.uname='shan2batman'and g.gname='MEP news' order by u.user_id desc
  5. yes it is, but how do i correct the group_id values because it is the reason why i posted it in our forum @Barand
  6. @Barand repeated values coming while fetching data from tables
  7. finally i managed to fetch data from tables but the problem now is even after using distinct, groupby and having clauses the result is producing duplicate results its killing my brain @requinix can you point me where it is going wrong this is the updated query: select distinct g.* ,gp.*,up.*, u.uname,u.avatar,u.user_id from group_posts as g left join user as u on u.uname=g.author_gp left join updates as up on up.author=u.uname left join groups as gp on g.group_id=gp.g_id where g.gname='MEP news' and u.uname='shan2batman' GROUP by g.data,up.update_body having u.uname='shan2batman'and g.gname='MEP news' order by u.user_id desc here is the output: pid gname gp_id author_gp type title data pdate vote_up vote_down user_id_g group_id g_id name creation logo invrule creator description update_id update_body url time host vote_up vote_down title user_id_u account_name author type data uname avatar user_id 1 0 MEP news 11 shan2batman 0 ok lets see my first message #qwert 2016-08-12 20:17:21 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 12 shan2batman 0 my second message welcome to chennai 2018-09-23 18:39:30 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 13 shan2batman 0 see what can i do to create a perfect social network 2018-09-23 18:54:54 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 14 shan2batman 0 lets see hi this is a test msg 2018-09-24 09:27:14 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 15 shan2batman 0 group post this is a test for group post 2018-09-24 09:28:46 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 288 what kind of a life am i living?? 2016-06-15 22:01:09 0 0 hai 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 11 shan2batman 0 ok lets see my first message #qwert 2016-08-12 20:17:21 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 12 shan2batman 0 my second message welcome to chennai 2018-09-23 18:39:30 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 13 shan2batman 0 see what can i do to create a perfect social network 2018-09-23 18:54:54 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 14 shan2batman 0 lets see hi this is a test msg 2018-09-24 09:27:14 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 15 shan2batman 0 group post this is a test for group post 2018-09-24 09:28:46 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 289 man im having the best luck im going to be a billi... 2016-06-15 22:05:00 0 0 bye 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 11 shan2batman 0 ok lets see my first message #qwert 2016-08-12 20:17:21 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 12 shan2batman 0 my second message welcome to chennai 2018-09-23 18:39:30 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 13 shan2batman 0 see what can i do to create a perfect social network 2018-09-23 18:54:54 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 14 shan2batman 0 lets see hi this is a test msg 2018-09-24 09:27:14 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 15 shan2batman 0 group post this is a test for group post 2018-09-24 09:28:46 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 290 #qwert is it ready&lt;br /&gt;&lt;img src=&quot;ht... 2016-08-12 20:16:15 0 0 qwertyu 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 11 shan2batman 0 ok lets see my first message #qwert 2016-08-12 20:17:21 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 0 MEP news 12 shan2batman 0 my second message welcome to chennai 2018-09-23 18:39:30 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 0 MEP news 13 shan2batman 0 see what can i do to create a perfect social network 2018-09-23 18:54:54 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 0 MEP news 14 shan2batman 0 lets see hi this is a test msg 2018-09-24 09:27:14 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 0 MEP news 15 shan2batman 0 group post this is a test for group post 2018-09-24 09:28:46 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 291 &lt;img src=&quot;tinymce/js/tinymce/plugins/emoti... 2016-08-12 20:18:27 0 0 poiuytr 127 shan2batman shan2batman a <br><b>Shared via .<br> shan2batman WedDec715012120167478.png 127 0 MEP news 11 shan2batman 0 ok lets see my first message #qwert 2016-08-12 20:17:21 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 12 shan2batman 0 my second message welcome to chennai 2018-09-23 18:39:30 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 13 shan2batman 0 see what can i do to create a perfect social network 2018-09-23 18:54:54 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 14 shan2batman 0 lets see hi this is a test msg 2018-09-24 09:27:14 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 0 MEP news 15 shan2batman 0 group post this is a test for group post 2018-09-24 09:28:46 0 0 0 25 25 MEP news 2016-06-25 06:06:41 TueDec619191620165366.png 1 aboutthecreator MEP is a social network that aims to be like faceb... 296 hello #qwert 2016-08-12 20:21:10 0 0 test message! 127 shan2batman shan2batman a shan2batman WedDec715012120167478.png 127 1 2 | Show all | | Number of rows: 25 50 100 250 500 Filter rows: Sort by key: PRIMARY (ASC)PRIMARY (DESC)None Sorry if it is a bit too long
  8. and i'm sorry for being too sloppy.
  9. @Barand but there are no ids matching the group between diferrent columns.
  10. sorry @requinix i don't have any indexes in those tables
  11. here is the EXPLAIN output: @requinix id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE updates ALL NULL NULL NULL NULL 36 Using where; Using temporary; Using filesort 1 SIMPLE group_photos ALL NULL NULL NULL NULL 1 Using join buffer (flat, BNL join) 1 SIMPLE user ref PRIMARY,uname uname 52 const 1 Using where; Using index 1 SIMPLE group_posts eq_ref PRIMARY PRIMARY 4 project.user.user_id 1 Using where 1 SIMPLE friends ref friend_one friend_one 257 const 2 Using index condition; Using where 1 SIMPLE groups ALL NULL NULL NULL NULL 4 Using where; Using join buffer (flat, BNL join) 1 SIMPLE gmembers ALL NULL NULL NULL NULL 6 Using where; Using join buffer (incremental, BNL j
  12. it produces no results just empty rows. how can i share data with you to trouble shoot the problem???? @requinix
  13. here is my trimmed code for update select user.uname, friends.friend_one,friends.friend_two,updates.update_id,updates.update_body,updates.time,updates.title,updates.vote_up,updates.vote_down,updates.user_id_u,updates.account_name,updates.author, groups.name,groups.creator,groups.logo,group_photos.g_p_id,group_photos.avatar, group_photos.g_id, group_posts.gp_id,group_posts.pid,group_posts.author_gp,group_posts.type, group_posts.title, group_posts.data, group_posts.pdate,group_posts.vote_up, group_posts.vote_down, group_posts.user_id_g from user inner join friends on friends.friend_one=user.uname OR friends.friend_two=user.uname and accepted='1' inner join updates on updates.author=friends.friend_one and updates.author=friends.friend_two AND updates.author=user.uname inner join group_posts on group_posts.gp_id=user.user_id inner join gmembers on gmembers.mname=group_posts.author_gp inner join groups on groups.name=gmembers.gname inner join group_photos on group_posts.gname=groups.name and groups.name=group_posts.gname where user.uname='shan2batman'and groups.name="MEP news" order by time desc limit 10 i'll try to explain what i'm trying to do first i want to fetch friend_one and friend_two along with the session user uname value and fetch the results from updates table. second i'm trying to match the author names and group names stored in group_posts and fetch it along with the query.
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.