select *, DATE_FORMAT(birthday, "%b %e, %Y") as _birthday, DATE_FORMAT(died, "%b %e, %Y") as _died, MONTH(birthday) as month_birth, DAY(birthday) as day_birth, DATE_FORMAT(birthday, "%b %e") as _birth_day_month from agatti_people where agatti_people.u_name = "pierre-watkin"
Pierre Watkin : Classic Movie Hub (CMH)
Classic Movie Hub (CMH)
 
 
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 ') and agatti_films.active=1' at line 1
select agatti_films.genre1,agatti_films.genre2,agatti_films.genre3,agatti_films.genre4,agatti_films.genre5,agatti_films.genre6,agatti_films.genre7,agatti_films.genre8,agatti_films.genre9,agatti_films.genre10 from agatti_films where id in (14,15,35,40,41,45,47,74,213,300,354,360,428,535,678,682,703,738,761,838,845,868,1057,1194,1286,1461,1463,1465,1473,1502,1512,1521,1572,1906,1976,2051,2214,2386,2390,2391,2405,2409,2495,2499,2521,2602,2603,3002,3036,3510,3563,3660,3775,3782,3783,3975,3980,3988,4033,4053,4105,4275,4339,4359,4401,4436,4592,4602,4632,4675,4735,4821,4848,4849,5173,5177,5540,5660,6293,6317,6320,6350,6356,6388,6574,6576,6622,6644,6882,6905,6922,7004,7081,7181,7359,7688,7907,7966,8033,8130,8174,8213,8351,8434,8435,8601,8626,8635,8727,8927,9155,9317,9393,9537,9631,9973,10270,10552,10730,10923,10928,11510,11747,11788,12020,12590,12931,12992,13482,13667,13939,14382,14383,14384,14385,14386,14387,14388,14889,15182,15767,16068,16077,16614,16618,16947,16949,17026,17132,17251,17394,17395,17596,18127,18132,18801,19165,19456,19463,19859,21836,21837,21906,21935,22017,22031,22168,22199,22202,22215,22235,22237,22312,22382,22421,22423,22497,22535,22560,22708,22732,22783,22895,22909,22913,23084,23087,23093,23130,23132,23384,23473,23524,23578,23723,) and agatti_films.active=1