Error in No of Rows Query
SELECT date_format(str_to_date(j.StartDate, '%m/%d/%Y'), '%W') as daye, date_format(str_to_date(j.StartDate, '%m/%d/%Y'), '%M') as Monthu, date_format(str_to_date(j.StartDate, '%m/%d/%Y'), '%e') as dateu,DATE_FORMAT(STR_TO_DATE(j.StartDate, '%m/%d/%Y %h:%i %p'), '%h:%i %p') as Time, j.EndDate, j.JobTitle, j.description, j.Country, j.State, j.City, j.Type, j.JobID, j.EmployerId, STR_TO_DATE(j.StartDate, '%m/%d/%Y' ) as startdate from `tbl_jobinvite` jb, `tbl_job` j, tbl_user u where jb.`ToId` = '' and jb.`Reply`='4' and jb.JobId=j.JobID AND j.EmployerId = u.UserId AND STR_TO_DATE(j.StartDate, '%m/%d/%Y') >= CURDATE() UNION SELECT DATE_FORMAT(STR_TO_DATE(g.Gig_Start_Date, '%m/%d/%Y'), '%W') as daye, DATE_FORMAT(STR_TO_DATE(g.Gig_Start_Date, '%m/%d/%Y'), '%M') as Monthu, DATE_FORMAT(STR_TO_DATE(g.Gig_Start_Date, '%m/%d/%Y'), '%e') as dateu, DATE_FORMAT(STR_TO_DATE(g.Gig_Start_Date, '%m/%d/%Y %h:%i %p'), '%h:%i %p') as Time, g.Gig_End_Date, g.Gig_Venue, g.Description, g.Country, g.State, g.City, g.Type, g.Gig_ID, g.Admin, STR_TO_DATE(g.Gig_Start_Date, '%m/%d/%Y' ) as startdate from tbl_gig g where STR_TO_DATE(g.Gig_End_Date, '%m/%d/%Y' ) >= CURDATE() AND FIND_IN_SET (, g.Created_By) GROUP BY Gig_ID ORDER BY daye ASC
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 ' g.Created_By) GROUP BY Gig_ID ORDER BY daye ASC' at line 48