I do sql queries that do selects with lots of results across several
custom tables. To pull in semantic data I would add the following to
mediaWikis database abstraction query variables:
(assuming I have a bunch of mv_index_page results as part of a complex
join query and wanted property like "spoken_by", or "other properties"
that I could add conditions on I would add the following (where
'spoken_by' is the $prop variable
$vars[] = $prop.object_title as $prop;
$from_tables.=' ' .
LEFT JOIN 'smw_relations'
as $prop
ON (mv_mvd_index.mv_page_id= $prop . subject_id
AND
$prop . relation_title = '$prop'
This is a LOT more difficult to do with the new database structure....
Any advice how I would approach this with the new db structure?
peace,
--michael
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Semediawiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
