Advertisement
Guest User

QWE

a guest
Dec 10th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.93 KB | None | 0 0
  1. SELECT
  2.     tracker_productions_oe_entries.id as tracker_productions_oe_entry_id,
  3.     production,
  4.     performance,
  5.     botes_vacios,
  6.     roturas_naturales,
  7.     roturas_purgado,
  8.     T.titulo,
  9.     T.ne
  10. FROM tracker_productions_oe_entries
  11. INNER JOIN
  12. (
  13.     SELECT
  14.     tracker_productions_oe_entries.id as tracker_productions_oe_entry_id,
  15.     tracker_production_changes.id as tracker_production_change_id,
  16.     #tracker_productions_oe_entries.production,
  17.     core_product_titles.description as titulo,
  18.     (tracker_productions_oe_entries.production * CAST(core_product_titles.description AS DECIMAL(10,6))) as ne
  19.     FROM tracker_productions_oe_entries
  20.     INNER JOIN tracker_production_changes ON tracker_production_changes.id = tracker_productions_oe_entries.tracker_production_change_id
  21.     INNER JOIN core_product_titles ON core_product_titles.id = tracker_production_changes.core_product_title_id
  22. ) as T ON T.tracker_productions_oe_entry_id = tracker_productions_oe_entries.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement