StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Add the date condition into the <code>WHERE</code>-statement and the exclusion of your <code>SUM</code> as a <code>HAVING</code>-statement. It should then look like this:</p> <pre><code>SELECT cms_module_ladu_batch.id AS batch_id, cms_module_ladu_batch.date_changed AS date_ch, kogused.kogus AS kogus, SUM(kogused.kogus) AS total FROM cms_module_ladu_batch LEFT JOIN kogused ON cms_module_ladu_batch.id = kogused.bid WHERE t2 != 'Sildid' AND ( ( cms_module_ladu_batch.date_changed < DATE_SUB(NOW(), INTERVAL 1 MONTH) AND SUM(kogused.kogus) > 0 ) OR cms_module_ladu_batch.date_changed > DATE_SUB(NOW(), INTERVAL 1 MONTH) ) GROUP BY batch_id; </code></pre> <p>Alternatively... use a UNION-Statement to glue two SELECTS together. </p> <pre><code>SELECT cms_module_ladu_batch.id AS batch_id, cms_module_ladu_batch.date_changed AS date_ch, kogused.kogus AS kogus, SUM(kogused.kogus) AS total FROM cms_module_ladu_batch LEFT JOIN kogused ON cms_module_ladu_batch.id = kogused.bid WHERE t2 != 'Sildid' AND cms_module_ladu_batch.date_changed < DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY batch_id HAVING total > 0 UNION SELECT cms_module_ladu_batch.id AS batch_id, cms_module_ladu_batch.date_changed AS date_ch, kogused.kogus AS kogus, SUM(kogused.kogus) AS total FROM cms_module_ladu_batch LEFT JOIN kogused ON cms_module_ladu_batch.id = kogused.bid WHERE t2 != 'Sildid' AND cms_module_ladu_batch.date_changed > DATE_SUB(NOW(), INTERVAL 1 MONTH) GROUP BY batch_id; </code></pre> <p>Try both, see what fits best for your solution.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload