5

Out of memory (Needed 3355472 bytes) SQL=SELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count FROM qtf34_djc2_items_extra_fields_values_int as fv INNER JOIN qtf34_djc2_items_extra_fields as ef on ef.id=fv.field_id INNER JOIN qtf34_djc2_items_extra_fields_options as opt on opt.field_id=ef.id and opt.id=fv.value INNER JOIN ( SELECT distinct i.id FROM qtf34_djc2_items as i LEFT JOIN qtf34_djc2_categories AS c ON c.id = i.cat_id LEFT JOIN qtf34_djc2_producers AS p ON p.id = i.producer_id LEFT JOIN `setno_net_Knet0Fa`.`o0dmk_users` AS ua ON ua.id = i.created_by LEFT JOIN qtf34_djc2_countries AS countries ON countries.id = i.country LEFT JOIN qtf34_djc2_countries_states AS states ON states.id = i.state WHERE c.published = 1 AND (i.publish_up ='0000-00-00 00:00:00' OR i.publish_up <= '2024-05-17 08:55:16') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-17 08:55:16') AND ( LOWER(i.name) LIKE 'ش%' COLLATE utf8_bin OR UPPER(i.name) LIKE 'ش%' COLLATE utf8_bin ) AND i.published = 1 AND i.access IN (1,1,5) AND i.parent_id=0 ORDER BY i.id asc , i.ordering, c.ordering ) as item_ids on fv.item_id = item_ids.id WHERE ef.id = 22 GROUP BY ef.id, opt.value ORDER BY ef.name asc