DrupalBin

Summary:

Tags:

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).

Source code: * SELECT content_type_avisartikel.nid, content_field_brdtekst.field_brdtekst_value, \ GROUP_CONCAT(DISTINCT term_data.name SEPARATOR ' '), content_type_avisartikel.field_underrubrik_value,\ content_field_ekstern_skribent.field_ekstern_skribent_value, node.title, \ GROUP_CONCAT(DISTINCT profile_values.value SEPARATOR ' ' ), \ UNIX_TIMESTAMP( content_field_avisdato.field_avisdato_value ) AS avisdato \ FROM `content_type_avisartikel` \ JOIN `node` FORCE INDEX(nid) ON content_type_avisartikel.nid = node.nid \ JOIN term_node ON node.nid = term_node.nid \ JOIN term_data ON term_data.tid = term_node.tid \ JOIN `content_field_skribent` ON content_field_skribent.nid = content_type_avisartikel.nid \ JOIN `content_field_ekstern_skribent` ON content_field_ekstern_skribent.nid = content_type_avisartikel.nid \ JOIN `content_field_avisdato` ON content_field_avisdato.nid = content_type_avisartikel.nid \ JOIN `content_field_brdtekst` ON content_field_brdtekst.nid = content_type_avisartikel.nid \ LEFT JOIN `profile_values` ON content_field_skribent.field_skribent_uid = profile_values.uid \ AND profile_values.fid =1 \ WHERE node.status = 1 \ GROUP BY content_type_avisartikel.nid \

Syntax highlighting mode: ActionScriptColdFusionDiffDrupalDrupal 5Drupal 6HTMLJavascriptMySQLPHPPythonrobots.txtSQLText

Select the syntax highlighting mode to use.