Untitled diff

Created Diff never expires
2 removals
16 lines
4 additions
18 lines
SELECT (COUNT(*)) AS `count`
SELECT *
FROM forms Forms
FROM forms Forms
INNER JOIN form_fields FormFields ON (
INNER JOIN form_fields FormFields ON (
content_value >= '2016-01-04'
content_value >= '2016-01-04'
AND content_value <= '2016-07-07'
AND content_value <= '2016-07-07'
AND FormFieldTypes.identifier = 'date'
AND Forms.id = (FormFields.form_id)
AND Forms.id = (FormFields.form_id)
AND (FormFields.deleted) IS NULL
AND (FormFields.deleted) IS NULL
)
)
INNER JOIN form_field_types FormFieldTypes ON (
INNER JOIN form_field_types FormFieldTypes ON (
FormFieldTypes.identifier = 'date'
FormFieldTypes.identifier = 'date'
AND FormFieldTypes.id = (FormFields.form_field_type_id)
AND FormFieldTypes.id = (FormFields.form_field_type_id)
AND (FormFieldTypes.deleted) IS NULL
AND (FormFieldTypes.deleted) IS NULL
)
)
WHERE (Forms.Company_Id = 'e44f293e-5395-46fa-9d0e-947956a44f4a'
WHERE (Forms.Company_Id = 'e44f293e-5395-46fa-9d0e-947956a44f4a'
AND (Forms.deleted) IS NULL)
AND (Forms.deleted) IS NULL)
ORDER BY Forms.created desc
LIMIT 20
OFFSET 0;