0.0006561 |
50.01% |
SELECT "me"."id", "me"."cobrand", "me"."name", "me"."short_name", "me"."background_colour", "me"."theme_colour", "me"."images", "me"."wasteworks_name", "me"."wasteworks_short_name"
FROM "manifest_theme" "me"
WHERE "me"."cobrand" = 'olacobrand' |
0.0006559 |
49.99% |
SELECT "me"."id", "me"."postcode", "me"."latitude", "me"."longitude", "me"."bodies_str", "me"."bodies_missing", "me"."areas", "me"."category", "me"."title", "me"."detail", "me"."photo", "me"."used_map", "me"."user_id", "me"."name", "me"."anonymous", "me"."external_id", "me"."external_body", "me"."external_team", "me"."created", "me"."confirmed", "me"."state", "me"."lang", "me"."service", "me"."cobrand", "me"."cobrand_data", "me"."lastupdate", "me"."whensent", "me"."send_questionnaire", "me"."extra", "me"."flagged", "me"."geocode", "me"."response_priority_id", "me"."send_state", "me"."send_fail_count", "me"."send_fail_reason", "me"."send_fail_timestamp", "me"."send_fail_body_ids", "me"."send_method_used", "me"."non_public", "me"."external_source", "me"."external_source_id", "me"."interest_count", "me"."subcategory", "me"."defect_type_id"
FROM "problem" "me"
WHERE "non_public" = '0' AND "photo" IS NOT NULL AND ( "state" = 'closed' OR "state" = 'planned' OR "state" = 'duplicate' OR "state" = 'cancelled' OR "state" = 'fixed - council' OR "state" = 'fixed - user' OR "state" = 'unable to fix' OR "state" = 'internal referral' OR "state" = 'confirmed' OR "state" = 'not responsible' OR "state" = 'action scheduled' OR "state" = 'investigating' OR "state" = 'in progress' OR "state" = 'fixed' )
ORDER BY "id" DESC
LIMIT '10' |