SELECT `thewebsite0_observation`.`id`,
       `thewebsite0_observation`.`tickershort_id`,
       `thewebsite0_observation`.`series_id`,
       `thewebsite0_observation`.`agency_id`,
       `thewebsite0_observation`.`currency`,
       `thewebsite0_observation`.`transformation`,
       `thewebsite0_observation`.`scale`,
       `thewebsite0_observation`.`obs_type`,
       `thewebsite0_observation`.`date`,
       `thewebsite0_observation`.`ref_period`,
       `thewebsite0_observation`.`value`,
       `thewebsite0_observation`.`frequency`,
       `thewebsite0_observation`.`created_on`
FROM `thewebsite0_observation`
INNER JOIN `thewebsite0_obsagency` ON (`thewebsite0_observation`.`agency_id` = `thewebsite0_obsagency`.`id`)
WHERE (`thewebsite0_observation`.`tickershort_id` = 73294
       AND `thewebsite0_obsagency`.`name` = NOT Available
       AND `thewebsite0_observation`.`frequency` = Q
       AND `thewebsite0_observation`.`ref_period` >= 2010-01-01
       AND `thewebsite0_observation`.`ref_period` <= 2019-01-01)
ORDER BY `thewebsite0_observation`.`ref_period` ASC