Tango.info sql query list

SELECT *
FROM tango_persons_x_pascale , tango_persons
WHERE tango_persons.person_code = tango_persons_x_pascale.code


SELECT *
FROM tango_persons_x_pascale
LEFT JOIN tango_persons ON tango_persons.person_code = tango_persons_x_pascale.code

wiki article datetime

task

from

dbwiki.mul_page : page_id, page_title 

fill

dbtango.tango_wiki_pages : page_id, time_start, time_end

where page_title can be like

• 2007-10-12--14_Festival_Karlsruhe
• 2007-05-30--06-03_Festival_Sydney
• 2007-12-07--2008-01-06_Festival_Roma

solution

TRUNCATE TABLE `tango_wiki_pages` ;
INSERT INTO `tango_wiki_pages` SET page_id = 1
[to be completed!]

Chrisjjj To convert page_title to page_id, time_start, time_end you could use PHP preg_match().