Advertisement
Guest User

Untitled

a guest
Apr 26th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1.  
  2. 1) select ID from a_1c_exchange_files_new_iblock where STATUS='fail';
  3. 2) select ID from a_1c_exchange_files_orders where STATUS='fail';
  4. 3) SELECT
  5. IF(
  6. TIMESTAMPDIFF(MINUTE, DATE_LAST_CONNECT, CURRENT_TIMESTAMP) > 90,
  7. 1,
  8. 0
  9. )
  10. FROM `a_1c_exchange_files_new_iblock` as ib
  11. where ib.`STATUS`="success"
  12. ORDER BY `DATE_LAST_CONNECT` DESC
  13. LIMIT 1
  14. 4) SELECT
  15. IF(
  16. HOUR(CURRENT_TIMESTAMP) BETWEEN 0 AND 8,
  17. 0,
  18. (
  19. SELECT
  20. IF(
  21. TIMESTAMPDIFF(HOUR, DATE_LAST_CONNECT, CURRENT_TIMESTAMP) > 0,
  22. 1,
  23. 0
  24. )
  25. FROM `a_1c_exchange_files_orders` as ib
  26. where ib.`STATUS`="success"
  27. ORDER BY `DATE_LAST_CONNECT` DESC
  28. LIMIT 1
  29. )
  30. ) AS `ERROR`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement