Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- tracker_productions_oe_entries.id as tracker_productions_oe_entry_id,
- production,
- performance,
- botes_vacios,
- roturas_naturales,
- roturas_purgado,
- T.titulo,
- T.ne
- FROM tracker_productions_oe_entries
- INNER JOIN
- (
- SELECT
- tracker_productions_oe_entries.id as tracker_productions_oe_entry_id,
- tracker_production_changes.id as tracker_production_change_id,
- #tracker_productions_oe_entries.production,
- core_product_titles.description as titulo,
- (tracker_productions_oe_entries.production * CAST(core_product_titles.description AS DECIMAL(10,6))) as ne
- FROM tracker_productions_oe_entries
- INNER JOIN tracker_production_changes ON tracker_production_changes.id = tracker_productions_oe_entries.tracker_production_change_id
- INNER JOIN core_product_titles ON core_product_titles.id = tracker_production_changes.core_product_title_id
- ) as T ON T.tracker_productions_oe_entry_id = tracker_productions_oe_entries.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement