title: Left join with multiple status
body: <p>Lets say i have two stores. <code>Store A(22)</code> and <code>Store B(21)</code>. This is the query to fetch the things that matched with the Store ID: </p>
  
  <pre><code>SELECT c . * , s.s_name, s.logo, s.s_slug, cm.c_code, cm.c_shorturl, cm.c_shorturl_id
  FROM ci_cptbl c
  LEFT JOIN ci_stores s ON s.store_id = c.store_id
  LEFT JOIN ci_cptbl_mapper cm ON cm.c_id = c._id
  WHERE c.coupon_id &lt;&gt;  ''
  AND c.store_id in ('22', '21')
  AND s.s_status =  '1' 
  AND c.c_status =  '1'
  AND DATE( c.c_end_date ) &gt;=  '2014-10-04'
  ORDER BY c.c_id DESC 
  </code></pre>
  
  <p><code>ci_cptbl</code> Has the collection of product including the <code>store_id</code>. And <code>ci_stores</code> holds the store name, etc.. including <code>s_status</code>(0, 1). </p>
  
  <pre><code>CREATE TABLE `ci_stores` (
   `store_id` int(10) NOT NULL AUTO_INCREMENT,
   `cat_id` int(10) NOT NULL,
   `s_name` varchar(255) NOT NULL,
   `s_slug` varchar(255) NOT NULL,
   `logo` varchar(255) NOT NULL,
   `display_name` varchar(255) NOT NULL,
   `s_description` text NOT NULL,
   `network_id` int(10) NOT NULL,
   `s_status` tinyint(1) NOT NULL DEFAULT '0',
   `merged_stores` text NOT NULL,
   `stat` bigint(20) NOT NULL,
   PRIMARY KEY (`store_id`),
   KEY `network_id` (`network_id`),
   KEY `cat_id` (`cat_id`),
   FULLTEXT KEY `display_name` (`display_name`)
  ) ENGINE=MyISAM AUTO_INCREMENT=127 DEFAULT CHARSET=utf8
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/iRCDp.png" alt="Sample"></p>
  
  <p>Now condition is i have only first store id( <code>22</code> ) enabled and rest is disabled (21, .....) in my stores table and my <code>AND s.s_status =  '1'</code> statement works only if all the stores are enabled but i want all stores including disabled. </p>
  
  <p><strong>BUT FIRST STORE ID MUST BE ENABLED</strong></p>