So I am using LokiJS as a local database, although I am having some trouble replicating a MySQL query to work…
The query I am trying to replicate is:
SELECT DISTINCT advertisers_approved.* FROM advertisers_approved INNER JOIN advertiser_categories_approved ON advertisers_approved.id = advertiser_categories_approved.advertiser_id INNER JOIN locations_approved ON advertisers_approved.id = locations_approved.advertiser_id INNER JOIN advertiser_times_approved ON advertisers_approved.id = advertiser_times_approved.advertiser_id WHERE ( advertiser_categories_approved.category_id = 12 OR advertiser_categories_approved.category_id = 11 ) AND ( locations_approved.region_id = 5 ) AND ( advertiser_times_approved.day_id = 3 AND '1055' >= advertiser_times_approved.open AND '1055' < advertiser_times_approved.close )
Could someone let me know if this is even possible to do in LokiJS, or will I have to do it manually, calling each item manually and filtering it manually?
It it is possible to replicate with LokiJS, could you give me some pointers?