RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / tmp /
Filename : sess_328686b9b8bb527f3246fe9d31798203
back
 PMA_token |s:32:"62702240626e6531255d7b237b26355e"; HMAC_secret |s:16:"fBe#7P"O1r1/G>yB";auth_type|s:3:"env";browser_access_time|a:17:{s:7:"default";i:1743510125;s:36:"849a065c-a442-dfba-156f-1194d11a0e05";i:1743506563;s:36:"a35d5851-d7fa-af9c-7a70-73583fd07530";i:1743487669;s:36:"9d94276d-c03e-7580-a3d6-5cdfa80d8f05";i:1743488258;s:36:"e6ceff45-c4b0-d47c-c71b-377096052814";i:1743506024;s:36:"0e429bd7-6e59-a874-d846-a6046e67c7f0";i:1743506320;s:36:"8e6e0800-8420-c65a-72db-0b4204f7c911";i:1743506606;s:36:"d537a2f3-eea3-6a6f-4456-3c393a6811f2";i:1743492487;s:36:"75fc4591-532d-7c80-dbf8-9742438fab68";i:1743496828;s:36:"ad0c683b-3828-0794-da45-5ece5d23c5da";i:1743506204;s:36:"0954dcf5-b10d-93d6-8502-42b7a3828218";i:1743506603;s:36:"2a945cc7-07b8-7111-5503-a096d1856467";i:1743506260;s:36:"6120467b-bd13-40ca-1727-22c73f91ab37";i:1743499572;s:36:"5b3d485f-67ca-36d9-c616-b42012a6e03f";i:1743506720;s:36:"2fc494a2-161a-93aa-c7ba-b383784ac501";i:1743509091;s:36:"ada943c0-06e8-f360-530b-ed435548de29";i:1743511246;s:36:"d32f4fd6-026f-a043-63bc-6cc270db091b";i:1743511474;}encryption_key|s:32:"�S5��b+گ�糣����K��ӗ�R�/";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.1";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:2:{s:4:"lang";s:5:"en_GB";s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1743509784;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1743509784;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1701727214;s:9:"userprefs";a:2:{s:4:"lang";s:5:"en_GB";s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:21:"server_1_o5t6x7pgljbm";a:18:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:8:{i:0;s:15:"i9676382\_au2k1";i:1;s:13:"i9676382\_wp1";i:2;s:15:"i9676382\_cntp1";i:3;s:15:"i9676382\_v5y61";i:4;s:15:"i9676382\_amo71";i:5;s:3:"cfc";i:6;s:13:"i9676382\_wp2";i:7;s:15:"i9676382\_dsab1";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:8:"Plug-ins";s:6:"engine";s:7:"Engines";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:5:"query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}s:19:"profiling_supported";b:1;s:17:"menu-levels-table";a:11:{s:6:"browse";s:6:"Browse";s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:6:"insert";s:6:"Insert";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:10:"privileges";s:10:"Privileges";s:9:"operation";s:10:"Operations";s:8:"tracking";s:8:"Tracking";s:8:"triggers";s:8:"Triggers";}s:12:"is_superuser";b:0;s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;s:14:"mysql_cur_user";s:22:"o5t6x7pgljbm@localhost";}}tmpval|a:16:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:7:{i:0;a:2:{s:2:"db";s:3:"cfc";s:5:"table";s:8:"products";}i:1;a:2:{s:2:"db";s:3:"cfc";s:5:"table";s:5:"users";}i:2;a:2:{s:2:"db";s:3:"cfc";s:5:"table";s:13:"store_product";}i:3;a:2:{s:2:"db";s:3:"cfc";s:5:"table";s:5:"store";}i:4;a:2:{s:2:"db";s:3:"cfc";s:5:"table";s:6:"groups";}i:5;a:2:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";}i:6;a:2:{s:2:"db";s:3:"cfc";s:5:"table";s:17:"reward_visibility";}}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:3:"cfc";s:13:"table_uiprefs";a:1:{i:1;a:1:{s:3:"cfc";a:7:{s:5:"users";a:0:{}s:8:"products";a:0:{}s:15:"reward_settings";a:0:{}s:17:"reward_visibility";a:0:{}s:6:"groups";a:0:{}s:5:"store";a:0:{}s:13:"store_product";a:0:{}}}}s:5:"query";a:10:{s:32:"689afbb7c039bc518ffc9a7f06f80bd4";a:8:{s:3:"sql";s:903:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
(
    (
        reward_settings.visible_to IN ('GLOBAL_FOR_PARENT')
        AND reward_settings.visible_in_family_store = 1 
        AND store_product.store_id = 456
        AND store_product.is_published = 1
    ) OR
    (
        reward_settings.visible_to IN ('SINGLE_GROUP')
        AND products.group_id = 458
    ) OR
    (
        store_product.store_id = 456
        AND store_product.is_published = 1
    )
)
AND products.deleted_at IS NULL
GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 10;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"267da4c656c9132ff130f10833e8b219";a:8:{s:3:"sql";s:1421:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
(
    -- Condition for GLOBAL_FOR_PARENT
    (
        reward_settings.visible_to IN ('GLOBAL_FOR_PARENT')
        AND reward_settings.visible_in_family_store = 1 
        AND store_product.store_id = 456
        AND store_product.is_published = 1
    ) 
    OR
    -- Condition for SINGLE_GROUP
    (
        reward_settings.visible_to IN ('SINGLE_GROUP')
        AND products.group_id = 18
    ) 
    OR
    -- Condition for COUNTRY_GROUP
    (
        reward_settings.visible_to IN ('COUNTRY_GROUP')
        AND (
            reward_settings.visible_in_family_store != 0 
            OR reward_settings.visible_in_family_store IS NULL
        )
        AND reward_visibility.entity_type = 'COUNTRY'
        AND reward_visibility.entity_value = 'Afghanistan'
    ) 
    OR
    -- Condition for store product being published
    (
        store_product.store_id = 456
        AND store_product.is_published = 1
    )
)
AND products.deleted_at IS NULL
GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 12;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"94387629ae96552b41d2a89b4ca9eb9b";a:8:{s:3:"sql";s:975:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
(
    -- Condition for GLOBAL_FOR_PARENT
    reward_settings.visible_to IN ('GLOBAL_FOR_PARENT')
    
    OR 
    -- Condition for SELECTED_PARENT with USER entity type
    (
        reward_settings.visible_to IN ('SELECTED_PARENT') 
        AND reward_visibility.entity_type = 'USER'
        AND reward_visibility.entity_value = 87
    )

    OR 
    -- Condition for SINGLE_GROUP
    (
        reward_settings.visible_to IN ('SINGLE_GROUP')
        AND products.group_id = 458
    )
)
AND products.deleted_at IS NULL
GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 12;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"c3b647d939428b934401a48f8eb221ce";a:8:{s:3:"sql";s:21:"SELECT * FROM `users`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"f69d8b7a3128f9e6dbce022fa2e48005";a:8:{s:3:"sql";s:67:"SELECT *  FROM `users` WHERE `email` LIKE 'gosiya.kartik@gmail.com'";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"210021c90e10a1ba6aca56e66970d9d6";a:8:{s:3:"sql";s:60:"SELECT `api_token` FROM `users` WHERE `users`.`user_id` = 87";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"982b617653fa54bdb3109fa0a132626a";a:8:{s:3:"sql";s:1204:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
    (
        -- Check if visible_to is GLOBAL_FOR_PARENT
        reward_settings.visible_to IN ('GLOBAL_FOR_PARENT')
        
        OR
        
        -- Check if visible_to is SELECTED_PARENT and entity_type is USER and entity_value is 87
        (
            reward_settings.visible_to IN ('SELECTED_PARENT') 
            AND reward_visibility.entity_type = 'USER'
            AND reward_visibility.entity_value = 87
        )
        
        OR
        
        -- Check if visible_to is SINGLE_GROUP and products belong to group 458
        (
            reward_settings.visible_to IN ('SINGLE_GROUP') 
            AND products.group_id = 458
        )
    )
    
    -- Exclude deleted products
    AND products.deleted_at IS NULL

GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 12;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"a0364e5c121657c17de5f2255eaf7f75";a:8:{s:3:"sql";s:67:"SELECT *  FROM `users` WHERE `email` LIKE 'kartik.g.dweb@gmail.com'";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"3aadb6949cec6870ea258bb08d677808";a:8:{s:3:"sql";s:60:"SELECT `api_token` FROM `users` WHERE `users`.`user_id` = 88";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"431bc728d55ce704a94045cae26b1a2b";a:8:{s:3:"sql";s:777:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
    -- Check if visible_to is SINGLE_GROUP and products belong to group 458
    reward_settings.visible_to IN ('SINGLE_GROUP') 
    AND products.group_id = 458
    
    -- Ensure the product is not published
    AND store_product.is_published <> 0
    
    -- Ensure the product is not deleted
    AND products.deleted_at IS NULL

GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 12;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:20:"possible_as_geometry";b:1;}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}is_multi_query|b:0;sql_history|a:25:{i:0;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:1;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:2;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:3;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:4;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:5;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:17:"reward_visibility";s:8:"sqlquery";s:33:"SELECT * FROM `reward_visibility`";}i:6;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:7;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:8;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:9;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:10;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:11;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:12;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:8:"products";s:8:"sqlquery";s:24:"SELECT * FROM `products`";}i:13;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:8:"products";s:8:"sqlquery";s:24:"SELECT * FROM `products`";}i:14;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:15:"reward_settings";s:8:"sqlquery";s:31:"SELECT * FROM `reward_settings`";}i:15;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:8:"products";s:8:"sqlquery";s:558:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE (
    reward_settings.visible_to IN ('SINGLE_GROUP')
    AND products.group_id = 458
)
AND products.deleted_at IS NULL
GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 10;";}i:16;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:6:"groups";s:8:"sqlquery";s:22:"SELECT * FROM `groups`";}i:17;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:5:"store";s:8:"sqlquery";s:21:"SELECT * FROM `store`";}i:18;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:13:"store_product";s:8:"sqlquery";s:29:"SELECT * FROM `store_product`";}i:19;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:8:"products";s:8:"sqlquery";s:903:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
(
    (
        reward_settings.visible_to IN ('GLOBAL_FOR_PARENT')
        AND reward_settings.visible_in_family_store = 1 
        AND store_product.store_id = 456
        AND store_product.is_published = 1
    ) OR
    (
        reward_settings.visible_to IN ('SINGLE_GROUP')
        AND products.group_id = 458
    ) OR
    (
        store_product.store_id = 456
        AND store_product.is_published = 1
    )
)
AND products.deleted_at IS NULL
GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 10;";}i:20;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:8:"products";s:8:"sqlquery";s:975:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
(
    -- Condition for GLOBAL_FOR_PARENT
    reward_settings.visible_to IN ('GLOBAL_FOR_PARENT')
    
    OR 
    -- Condition for SELECTED_PARENT with USER entity type
    (
        reward_settings.visible_to IN ('SELECTED_PARENT') 
        AND reward_visibility.entity_type = 'USER'
        AND reward_visibility.entity_value = 87
    )

    OR 
    -- Condition for SINGLE_GROUP
    (
        reward_settings.visible_to IN ('SINGLE_GROUP')
        AND products.group_id = 458
    )
)
AND products.deleted_at IS NULL
GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 12;";}i:21;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:5:"users";s:8:"sqlquery";s:21:"SELECT * FROM `users`";}i:22;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:5:"users";s:8:"sqlquery";s:60:"SELECT `api_token` FROM `users` WHERE `users`.`user_id` = 87";}i:23;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:5:"users";s:8:"sqlquery";s:60:"SELECT `api_token` FROM `users` WHERE `users`.`user_id` = 88";}i:24;a:3:{s:2:"db";s:3:"cfc";s:5:"table";s:8:"products";s:8:"sqlquery";s:777:"SELECT products.*
FROM products
LEFT JOIN store_product 
    ON store_product.product_id = products.product_id 
    AND store_product.deleted_at IS NULL
LEFT JOIN reward_settings 
    ON reward_settings.reward_id = products.product_id
LEFT JOIN reward_visibility 
    ON reward_visibility.reward_settings_id = reward_settings.reward_settings_id
WHERE 
    -- Check if visible_to is SINGLE_GROUP and products belong to group 458
    reward_settings.visible_to IN ('SINGLE_GROUP') 
    AND products.group_id = 458
    
    -- Ensure the product is not published
    AND store_product.is_published <> 0
    
    -- Ensure the product is not deleted
    AND products.deleted_at IS NULL

GROUP BY products.product_id
ORDER BY products.created_at DESC
LIMIT 12;";}}Import_message|a:2:{s:7:"message";N;s:11:"go_back_url";s:54:"index.php?route=/table/structure&db=cfc&table=products";}errors|a:0:{}