Home

Fix for Code

March 12, 2010 - 2:09pm — Anonymous
  1. SELECT DISTINCT(node.nid), node.title AS node_title, chargify_subscriptions_chargify_sites.subscription_id AS chargify_subscriptions_chargify_sites_subscription_id, node.created AS node_created, users.mail AS users_mail, users.uid AS users_uid, chargify_subscriptions_chargify_sites.state AS chargify_subscriptions_chargify_sites_state, uid
  2. FROM node node
  3. LEFT JOIN chargify_sites chargify_sites ON node.nid = chargify_sites.nid
  4. LEFT JOIN chargify_subscriptions chargify_subscriptions_chargify_sites ON chargify_sites.subscription_id = chargify_subscriptions_chargify_sites.subscription_id
  5. INNER JOIN users users ON node.uid = users.uid WHERE (node.status <> 0) AND (node.type in ('site')) LIMIT 0, 10

Submit Fix

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