SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1), kr AS ( SELECT a.*, rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR s.symbol in ($14)) AND ($15 = 0 OR p.patternname in ($16)) AND ($17 = 0 OR kr.patternclassid in ($18, $19)) AND ($20 = 0 OR kr.patternlengthbars <= $21) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $22 OR relevant = 1) AND ($23 = 0 OR age <= $24) ORDER BY identified DESC, length DESC;

Date: 2022-02-04 10:00:39
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT JOIN currencypips cps on cps.symbol = s.symbol WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR s.symbol in ($14)) AND ($15 = 0 OR fr.pattern in ($16)) AND ($17 = 0 OR fr.patternlengthbars <= $18) AND ($19 = 0 OR ($20 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($21 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $22 OR relevant = 1) AND ($23 = 0 OR age <= $24) ORDER BY identified DESC, length DESC;

Date: 2022-02-04 10:00:40
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR s.symbol in ($8)) AND ($9 = 0 OR fr.pattern in ($10)) AND ($11 = 0 OR fr.patternlengthbars <= $12) AND ($13 = 0 OR ($14 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($15 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $16 OR relevant = 1) AND ($17 = 0 OR age <= $18) ORDER BY identified DESC, length DESC;

Date: 2022-02-04 10:01:38
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1), kr AS ( SELECT a.*, rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END), results AS ( SELECT DISTINCT ON (s.symbolid) kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4)) AND ($5 = 0 OR s.exchange in ($6)) AND ($7 = 0 OR s.symbol in ($8)) AND ($9 = 0 OR p.patternname in ($10)) AND ($11 = 0 OR kr.patternclassid in ($12)) AND ($13 = 0 OR kr.patternlengthbars <= $14) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

Date: 2022-02-04 10:01:29
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%xauusd%' AND timegranularity = 240))) AND breakout >= 0.0 AND patternendtime = LatestBarAtBreakoutTime AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 546581455 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-02-04 10:08:44
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

SELECT distinct a.symbolid, p.resultuid, case when a.breakout >= 0 then 1 else 2 end as type, a.resultid, a.bandwidth, a.patternlengthbars, a.patternendtime, a.resy0, a.supporty0, a.resy1, a.supporty1, a.direction, a.predictionpriceto, a.patternendprice, a.predictionpricefrom, a.resx0, a.supportx0, a.resgradient, a.supportgradient FROM relevance_autochartist_results p INNER JOIN autochartist_results a ON p.resultuid = a.resultuid INNER JOIN autochartist_stocklist asl ON a.symbolid = asl.symbolid WHERE asl.enabled = 1 AND asl.recognitionengine ILIKE 'GLOBALGTMT5 - 1';

Date: 2022-02-04 10:15:27
Duration: 231ms
Database: acaweb_fx
User: postgres

SELECT distinct a.symbolid, p.resultuid, case when a.breakout >= 0 then 1 else 2 end as type, a.resultid, a.bandwidth, a.patternlengthbars, a.patternendtime, a.resy0, a.supporty0, a.resy1, a.supporty1, a.direction, a.predictionpriceto, a.patternendprice, a.predictionpricefrom, a.resx0, a.supportx0, a.resgradient, a.supportgradient FROM relevance_autochartist_results p INNER JOIN autochartist_results a ON p.resultuid = a.resultuid INNER JOIN autochartist_stocklist asl ON a.symbolid = asl.symbolid WHERE asl.enabled = 1 AND asl.recognitionengine ILIKE 'GLOBALGTMT5 - 1';

Date: 2022-02-04 10:30:44
Duration: 224ms
Database: acaweb_fx
User: postgres

SELECT distinct a.symbolid, p.resultuid, case when a.breakout >= 0 then 1 else 2 end as type, a.resultid, a.bandwidth, a.patternlengthbars, a.patternendtime, a.resy0, a.supporty0, a.resy1, a.supporty1, a.direction, a.predictionpriceto, a.patternendprice, a.predictionpricefrom, a.resx0, a.supportx0, a.resgradient, a.supportgradient FROM relevance_autochartist_results p INNER JOIN autochartist_results a ON p.resultuid = a.resultuid INNER JOIN autochartist_stocklist asl ON a.symbolid = asl.symbolid WHERE asl.enabled = 1 AND asl.recognitionengine ILIKE 'GLOBALGTMT5 - 1';

Date: 2022-02-04 10:45:39
Duration: 216ms
Database: acaweb_fx
User: postgres

x Hide

)) AND breakout >= 0.0 AND patternendtime = LatestBarAtBreakoutTime AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-02-04 10:04:31
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%us30%' AND timegranularity = 60)) OR ((c.symbol ilike '%us30%' AND timegranularity = 240)) OR ((c.symbol ilike '%de30%' AND timegranularity = 30)) OR ((c.symbol ilike '%de30%' AND timegranularity = 60)) OR ((c.symbol ilike '%de30%' AND timegranularity = 240)) OR ((c.symbol ilike '%us500%' AND timegranularity = 30)) OR ((c.symbol ilike '%us500%' AND timegranularity = 60)) OR ((c.symbol ilike '%us500%' AND timegranularity = 240)) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 30)) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 60)) OR ((c.symbol ilike '%xauusd%' AND timegranularity = 240)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 30)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 60)) OR ((c.symbol ilike '%xagusd%' AND timegranularity = 240))) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2022-02-04 10:48:41
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

)) AND patternlengthbars >= 20 AND averagequality >= 0.0 AND (timequality >= 0.0 OR timequality = - 1) AND errormargin >= 0.0 AND 1 - noise >= 0.0 AND s.nonliquid = 0 AND PatternID & 63 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND PatternEndPrice > - 1 AND a.resultuid > 66838683 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

Date: 2022-02-04 10:00:42
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2022-02-04 10:27:50
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

select fixcandlegaps ('XM', false);

Date: 2022-02-04 10:06:11
Duration: 4s89ms
Database: acaweb_fx
User: postgres

select fixcandlegaps ('LEGACYFXMT5', false);

Date: 2022-02-04 10:06:06
Duration: 2s42ms
Database: acaweb_fx
User: postgres

select fixcandlegaps ('PHILLIPFUTURES', false);

Date: 2022-02-04 10:06:03
Duration: 1s731ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%audjpy%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%audusd%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%euraud%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%eurcad%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%eurnzd%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%eurusd%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%gbpcad%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%gbpchf%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdchf%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdpln%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdcad%' AND timegranularity <= 1440))) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2022-02-04 10:10:12
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%audjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%audusd%' AND timegranularity = 60)) OR ((s.symbol ilike '%cadjpy%' AND timegranularity = 240)) OR ((s.symbol ilike '%cadjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%euraud%' AND timegranularity = 240)) OR ((s.symbol ilike '%eurcad%' AND timegranularity = 60)) OR ((s.symbol ilike '%eurcad%' AND timegranularity = 240)) OR ((s.symbol ilike '%eurcad%' AND timegranularity = 1440)) OR ((s.symbol ilike '%eurjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%gbpcad%' AND timegranularity = 60)) OR ((s.symbol ilike '%gbpcad%' AND timegranularity = 240)) OR ((s.symbol ilike '%gbpcad%' AND timegranularity = 1440)) OR ((s.symbol ilike '%nzdcad%' AND timegranularity = 240))) AND breakout >= 0.0 AND patternendtime = LatestBarAtBreakoutTime AND patternlengthbars >= 20 AND patternquality >= 0.5 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 53151 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 550892459 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-02-04 10:35:18
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%audchf%' AND timegranularity = 1440)) OR ((s.symbol ilike '%audjpy%' AND timegranularity = 1440)) OR ((s.symbol ilike '%audnzd%' AND timegranularity = 1440)) OR ((s.symbol ilike '%audusd%' AND timegranularity = 1440)) OR ((s.symbol ilike '%audcad%' AND timegranularity = 240)) OR ((s.symbol ilike '%gbpaud%' AND timegranularity = 1440))) AND breakout >= 0.0 AND patternendtime = LatestBarAtBreakoutTime AND patternlengthbars >= 20 AND patternquality >= 0.3 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 65535 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 546561064 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-02-04 10:46:18
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%eurnzd%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%audusd%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%nzdcad%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdzar%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdpln%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%gbpaud%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%chfjpy%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%eurjpy%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%audjpy%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdmxn%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%cadjpy%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdnok%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%usdcad%' AND timegranularity <= 1440))) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2022-02-04 10:15:12
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((s.symbol ilike '%eurnzd%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%audusd%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%nzdcad%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%usdzar%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%usdpln%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%gbpaud%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%chfjpy%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%eurjpy%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%audjpy%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%usdmxn%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%cadjpy%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%usdnok%' AND timegranularity <= 1440)) OR ((s.symbol ilike '%usdcad%' AND timegranularity <= 1440))) AND breakout >= 0.0 AND patternendtime = LatestBarAtBreakoutTime AND patternlengthbars >= 20 AND patternquality >= 0.5 AND initialtrend >= 0.0 AND symmetry >= 0.0 AND noise <= 1.0 AND volumeincrease >= 0.0 AND TemporaryPattern = 0 AND PatternID & 57243 > 0 AND s.nonliquid = 0 AND s.deleted = 0 AND dss.enabled = 1 AND a.resultuid > 0 AND s.nonliquid = 0 AND dftt.dayofweek = 3 ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

Date: 2022-02-04 10:05:43
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%nzdcad%' AND timegranularity = 240)) OR ((c.symbol ilike '%usdpln%' AND timegranularity = 60)) OR ((c.symbol ilike '%gbpaud%' AND timegranularity = 1440)) OR ((c.symbol ilike '%usdczk%' AND timegranularity = 1440)) OR ((c.symbol ilike '%chfjpy%' AND timegranularity = 60)) OR ((c.symbol ilike '%chfjpy%' AND timegranularity = 240)) OR ((c.symbol ilike '%eurjpy%' AND timegranularity <= 1440)) OR ((c.symbol ilike '%audjpy%' AND timegranularity = 1440)) OR ((c.symbol ilike '%eurusd%' AND timegranularity = 240)) OR ((c.symbol ilike '%audusd%' AND timegranularity = 60)) OR ((c.symbol ilike '%cadjpy%' AND timegranularity = 240)) OR ((c.symbol ilike '%usdnok%' AND timegranularity = 30)) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 60)) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 240)) OR ((c.symbol ilike '%usddkk%' AND timegranularity = 60)) OR ((c.symbol ilike '%usddkk%' AND timegranularity = 240)) OR ((c.symbol ilike '%btcusd%' AND timegranularity = 240)) OR ((c.symbol ilike '%eurnzd%' AND timegranularity = 240)) OR ((c.symbol ilike '%eurnzd%' AND timegranularity = 1440)) OR ((c.symbol ilike '%euraud%' AND timegranularity = 240))) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2022-02-04 10:13:43
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide

) OR ((c.symbol ilike '%audjpy%' AND timegranularity = 30)) OR ((c.symbol ilike '%audusd%' AND timegranularity = 30)) OR ((c.symbol ilike '%chfjpy%' AND timegranularity = 30)) OR ((c.symbol ilike '%euraud%' AND timegranularity = 30)) OR ((c.symbol ilike '%gbpcad%' AND timegranularity = 30)) OR ((c.symbol ilike '%gbpchf%' AND timegranularity = 30)) OR ((c.symbol ilike '%gbpnzd%' AND timegranularity = 30)) OR ((c.symbol ilike '%gbpusd%' AND timegranularity = 30)) OR ((c.symbol ilike '%nzdchf%' AND timegranularity = 30)) OR ((c.symbol ilike '%nzdusd%' AND timegranularity = 30)) OR ((c.symbol ilike '%usdcad%' AND timegranularity = 30))) AND patternclassid = $1 AND patternlengthbars >= $2 AND a.PatternID & $3 > 0 AND dftt.dayofweek = $4 AND a.resultuid > $5 AND c.nonliquid = $6 AND c.deleted = 0 AND dss.enabled = 1 ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

Date: 2022-02-04 10:33:46
Duration: 0ms
Database: acaweb_fx
User: postgres

x Hide