Debug = hide_meta =
Debug SQL = SELECT post_id, post_content, post_title, REPLACE(um__key, ',', ' | ') AS um__key, REPLACE(REPLACE(um__value, ',', ' | '), ' - ', ',') AS um__value FROM ( SELECT post_id, post_content, post_title, GROUP_CONCAT(um__key) AS um__key, GROUP_CONCAT(um__value) AS um__value FROM data_posts dp LEFT JOIN ( SELECT um.database_id AS um__dbID, um.key AS um__key, REPLACE(um.value, ',', ' - ') AS um__value FROM users_meta um WHERE 1 = 1 AND um.database = 'data_posts' ) um ON um__dbID = dp.post_id WHERE dp.data_type = 98 AND dp.post_title != '' GROUP BY um__dbID ) tbl_src
Keys = Array ( [0] => form [1] => au_selector [2] => au_length [3] => au_ttlimit [4] => au_hint [5] => au_main_info [6] => au_limit [7] => au_header [8] => au_photo [9] => au_location [10] => au_link [11] => au_comesf [12] => website_id [13] => form_name [14] => method [15] => noheader [16] => save [17] => id [18] => myid [19] => au_module [20] => auHeaderTitle )
Values = Array ( [0] => myform [1] => class [2] => 2 [3] => 5 [4] => 0 [5] => Listing|users_data|1,Member Article|data_posts|15,Event|data_posts|8,Job Listing|data_posts|9,Coupon|data_posts|7,Video|data_posts|13,Audio File|data_posts|5,Blog Article|data_posts|14,Sweepstake|data_posts|70,News|data_posts|71,Classified|users_portfolio_groups|6,Photo Album|users_portfolio_groups|10,Property|users_portfolio_groups|12,Product|users_portfolio_groups|11,Main Category|list_professions|88,Sub Category|list_services|89,Listing|users_data|55,Article|data_posts|49,Event|data_posts|52,Job Posting|data_posts|59,Special Offers|data_posts|61,Video|data_posts|62,Classified|users_portfolio_groups|47,Photo Album|users_portfolio_groups|48,Property|users_portfolio_groups|58 [6] => 2,3,3,3,3,3,3,3,3,3,3,3,3,3,2,2,2,3,2,3,3,3,3,3,3 [7] => 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 [8] => 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1, )
Wrong data found, num of keys (21 and num of values (9 do not match on Users Meta table.
Debug...