HTML code for sharing Если в кеше нехватает только одного детектора для пары Сенсор-Время измерения то возвращаются все имеющиеся в хранилище, если нет то ПУСТО source code

HTML Copy To Clipboarddone!

<div class="highlight" style="background: #f8f8f8"><pre style="line-height: 125%"><div id="lc1">select * 
</div><div id="lc2">from detector_cache ,
</div><div id="lc3"> (select count(*) countSensorParts from detector where sensor_id=119) tmp,
</div><div id="lc4"> (select count(*) countSensorPartsCache from detector_cache where sensor_id=119 and TO_CHAR(measure_date,&#39;dd.mm.YYYY HH:MI&#39;)=&#39;28.12.1983 08:30&#39;) tmp2
</div><div id="lc5">where sensor_id=119 and TO_CHAR(measure_date,&#39;dd.mm.YYYY HH:MI&#39;)=&#39;28.12.1983 08:30&#39; and tmp.countSensorParts=tmp2.countSensorPartsCache+1;
</div></pre></div>
 Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a>

BBCODE Copy To Clipboarddone!

[color=#008000][b]select[/b][/color] [color=#666666]*[/color] 
[color=#008000][b]from[/b][/color] detector_cache ,
     ([color=#008000][b]select[/b][/color] [color=#008000][b]count[/b][/color]([color=#666666]*[/color]) countSensorParts [color=#008000][b]from[/b][/color] detector [color=#008000][b]where[/b][/color] sensor_id[color=#666666]=[/color][color=#666666]119[/color]) tmp,
     ([color=#008000][b]select[/b][/color] [color=#008000][b]count[/b][/color]([color=#666666]*[/color]) countSensorPartsCache [color=#008000][b]from[/b][/color] detector_cache [color=#008000][b]where[/b][/color] sensor_id[color=#666666]=[/color][color=#666666]119[/color] [color=#008000][b]and[/b][/color] TO_CHAR(measure_date,[color=#BA2121]'dd.mm.YYYY HH:MI'[/color])[color=#666666]=[/color][color=#BA2121]'28.12.1983 08:30'[/color]) tmp2
[color=#008000][b]where[/b][/color] sensor_id[color=#666666]=[/color][color=#666666]119[/color] [color=#008000][b]and[/b][/color] TO_CHAR(measure_date,[color=#BA2121]'dd.mm.YYYY HH:MI'[/color])[color=#666666]=[/color][color=#BA2121]'28.12.1983 08:30'[/color] [color=#008000][b]and[/b][/color] tmp.countSensorParts[color=#666666]=[/color]tmp2.countSensorPartsCache[color=#666666]+[/color][color=#666666]1[/color];

--------------------------------------
Colored with http://dumpz.org

Light HTML Copy To Clipboarddone!

That method generates HTML with CSS classes. Hence you'll need the style sheet file

<div class="highlight"><pre><div id="lc1">select * 
</div><div id="lc2">from detector_cache ,
</div><div id="lc3"> (select count(*) countSensorParts from detector where sensor_id=119) tmp,
</div><div id="lc4"> (select count(*) countSensorPartsCache from detector_cache where sensor_id=119 and TO_CHAR(measure_date,&#39;dd.mm.YYYY HH:MI&#39;)=&#39;28.12.1983 08:30&#39;) tmp2
</div><div id="lc5">where sensor_id=119 and TO_CHAR(measure_date,&#39;dd.mm.YYYY HH:MI&#39;)=&#39;28.12.1983 08:30&#39; and tmp.countSensorParts=tmp2.countSensorPartsCache+1;
</div></pre></div>
 Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a>

Habrahabr.ru HTML Copy To Clipboarddone!

Use that HTML for publications on habrahabr.ru

<blockquote><code>select&nbsp;*&nbsp;
from&nbsp;detector_cache&nbsp;,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(select&nbsp;count(*)&nbsp;countSensorParts&nbsp;from&nbsp;detector&nbsp;where&nbsp;sensor_id=119)&nbsp;tmp,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(select&nbsp;count(*)&nbsp;countSensorPartsCache&nbsp;from&nbsp;detector_cache&nbsp;where&nbsp;sensor_id=119&nbsp;and&nbsp;TO_CHAR(measure_date,&#39;dd.mm.YYYY&nbsp;HH:MI&#39;)=&#39;28.12.1983&nbsp;08:30&#39;)&nbsp;tmp2
where&nbsp;sensor_id=119&nbsp;and&nbsp;TO_CHAR(measure_date,&#39;dd.mm.YYYY&nbsp;HH:MI&#39;)=&#39;28.12.1983&nbsp;08:30&#39;&nbsp;and&nbsp;tmp.countSensorParts=tmp2.countSensorPartsCache+1;
</code></blockquote>Colored with <a href="http://dumpz.org">dumpz.org</a>