php - MySQL 内连接/左连接

Question

我有以下 MySQL 语句

SELECT * FROM node
        LEFT JOIN field_data_field_featured ON field_data_field_featured.entity_id = node.nid 
        LEFT JOIN field_data_field_mobile_only ON field_data_field_mobile_only.entity_id = node.nid AND field_data_field_mobile_only.field_mobile_only_value = 1
        INNER JOIN field_data_field_related_show ON field_data_field_related_show.entity_id = node.nid 
        WHERE node.status = '1' AND (node.type IN ('game','video','post')) 
        AND field_related_show_nid = 64
        ORDER BY field_featured_value DESC, node.created DESC

它当前返回符合所述条件的所有记录，但我想添加一个条件语句，其中如果字段类型是游戏，我只想在字段 field_mobile_only_value 为 1 时将该记录包含在结果集中。

当前 SQL 的示例记录如下所示

      nid: 351
                    vid: 351
                   type: game
               language: und
                  title: Avalanche at Plankton's Peak
                    uid: 53
                 status: 1
                created: 1403730218
                changed: 1403730218
                comment: 0
                promote: 1
                 sticky: 0
                   tnid: 0
              translate: 0
            entity_type: node
                 bundle: game
                deleted: 0
              entity_id: 351
            revision_id: 351
               language: und
                  delta: 0
   field_featured_value: 0
            entity_type: NULL
                 bundle: NULL
                deleted: NULL
              entity_id: NULL
            revision_id: NULL
               language: NULL
                  delta: NULL
field_mobile_only_value: NULL
            entity_type: node
                 bundle: game
                deleted: 0
              entity_id: 351
            revision_id: 351
               language: und
                  delta: 0
 field_related_show_nid: 64

Answer 1

我认为您不能根据选择查询中另一列的值向结果添加列。

为什么不在你的 php 代码中验证这一点？

如果不是游戏，则忽略 field_mobile_only_value 列。