Home

Sphinx sql

February 29, 2008 - 7:45am — Anonymous
  1. SELECT content_type_avisartikel.nid, content_field_brdtekst.field_brdtekst_value, \
  2. GROUP_CONCAT(DISTINCT term_data.name SEPARATOR ' '),  content_type_avisartikel.field_underrubrik_value,\
  3. content_field_ekstern_skribent.field_ekstern_skribent_value, node.title, \
  4. GROUP_CONCAT(DISTINCT profile_values.value SEPARATOR ' ' ), \
  5. UNIX_TIMESTAMP( content_field_avisdato.field_avisdato_value ) AS avisdato \
  6. FROM `content_type_avisartikel`  \
  7. JOIN `node` FORCE INDEX(nid) ON content_type_avisartikel.nid = node.nid \
  8. JOIN term_node ON node.nid = term_node.nid \
  9. JOIN term_data ON term_data.tid = term_node.tid \
  10. JOIN `content_field_skribent` ON content_field_skribent.nid = content_type_avisartikel.nid \
  11. JOIN `content_field_ekstern_skribent` ON content_field_ekstern_skribent.nid = content_type_avisartikel.nid \
  12. JOIN `content_field_avisdato` ON content_field_avisdato.nid = content_type_avisartikel.nid \
  13. JOIN `content_field_brdtekst` ON content_field_brdtekst.nid = content_type_avisartikel.nid \
  14. LEFT JOIN `profile_values` ON content_field_skribent.field_skribent_uid = profile_values.uid \
  15. AND profile_values.fid =1 \
  16. WHERE node.STATUS = 1 \
  17. GROUP BY content_type_avisartikel.nid \