Building Toys
Showing 421–432 of 1285 results
-
-
-
-
-
-
-
WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
insert into `wp_superspeedysearch` SELECT `wp_posts`.ID, `wp_posts`.post_author, `wp_posts`.post_date, `wp_posts`.post_date_gmt, `wp_posts`.post_content, `wp_posts`.post_title, `wp_posts`.post_excerpt, `wp_posts`.post_status, `wp_posts`.comment_status, `wp_posts`.ping_status, `wp_posts`.post_password, `wp_posts`.post_name, `wp_posts`.to_ping, `wp_posts`.pinged, `wp_posts`.post_modified, `wp_posts`.post_modified_gmt, `wp_posts`.post_content_filtered, `wp_posts`.post_parent, `wp_posts`.guid, `wp_posts`.menu_order, `wp_posts`.post_type, `wp_posts`.post_mime_type, `wp_posts`.comment_count, MIN(CASE WHEN pv.object_id IS NULL then 0 ELSE 1 END) as product_hidden, MIN(custommeta0.meta_value) AS meta_match__stock_status, GROUP_CONCAT( DISTINCT CONCAT(COALESCE(`wp_terms`.name,''), ' ', COALESCE(`wp_term_taxonomy`.description,''), ' ') SEPARATOR ' ') as taxonomydescriptions, GROUP_CONCAT( DISTINCT COALESCE(`wp_postmeta`.meta_value,'') SEPARATOR ' ' ) as metavalues , '' as language FROM `wp_posts` LEFT JOIN `wp_term_relationships` ON `wp_posts`.ID = `wp_term_relationships`.object_id LEFT JOIN `wp_terms` ON `wp_term_relationships`.term_taxonomy_id = `wp_terms`.term_id LEFT JOIN `wp_term_taxonomy` ON `wp_term_relationships`.term_taxonomy_id = `wp_term_taxonomy`.term_taxonomy_id LEFT JOIN `wp_postmeta` ON `wp_postmeta`.post_id = `wp_posts`.ID AND `wp_postmeta`.meta_key in ('_sku') LEFT JOIN `wp_postmeta` AS custommeta0 ON custommeta0.post_id = `wp_posts`.ID AND custommeta0.meta_key = '_stock_status' LEFT JOIN `wp_term_relationships` pv ON `wp_posts`.ID = pv.object_id and pv.term_taxonomy_id = 6 WHERE 'WPIBACKGROUNDTASK' = 'WPIBACKGROUNDTASK' AND `wp_posts`.ID = 482686 and not exists (select * from `wp_superspeedysearch` sss_exists where sss_exists.ID = `wp_posts`.ID) group by `wp_posts`.ID;
WordPress database error: [Deadlock found when trying to get lock; try restarting transaction]
insert into `wp_superspeedysearch`
SELECT `wp_posts`.ID, `wp_posts`.post_author, `wp_posts`.post_date, `wp_posts`.post_date_gmt,
`wp_posts`.post_content,
`wp_posts`.post_title,
`wp_posts`.post_excerpt,
`wp_posts`.post_status, `wp_posts`.comment_status, `wp_posts`.ping_status, `wp_posts`.post_password, `wp_posts`.post_name, `wp_posts`.to_ping, `wp_posts`.pinged, `wp_posts`.post_modified, `wp_posts`.post_modified_gmt, `wp_posts`.post_content_filtered, `wp_posts`.post_parent, `wp_posts`.guid, `wp_posts`.menu_order, `wp_posts`.post_type, `wp_posts`.post_mime_type, `wp_posts`.comment_count,
MIN(CASE WHEN pv.object_id IS NULL then 0 ELSE 1 END) as product_hidden,
MIN(custommeta0.meta_value) AS meta_match__stock_status,
GROUP_CONCAT( DISTINCT CONCAT(COALESCE(`wp_terms`.name,''), ' ', COALESCE(`wp_term_taxonomy`.description,''), ' ') SEPARATOR ' ') as taxonomydescriptions,
GROUP_CONCAT( DISTINCT COALESCE(`wp_postmeta`.meta_value,'') SEPARATOR ' ' ) as metavalues
, '' as language
FROM `wp_posts`
LEFT JOIN `wp_term_relationships`
ON `wp_posts`.ID = `wp_term_relationships`.object_id
LEFT JOIN `wp_terms`
ON `wp_term_relationships`.term_taxonomy_id = `wp_terms`.term_id
LEFT JOIN `wp_term_taxonomy`
ON `wp_term_relationships`.term_taxonomy_id = `wp_term_taxonomy`.term_taxonomy_id
LEFT JOIN `wp_postmeta`
ON `wp_postmeta`.post_id = `wp_posts`.ID
AND `wp_postmeta`.meta_key in ('_sku')
LEFT JOIN `wp_postmeta` AS custommeta0 ON custommeta0.post_id = `wp_posts`.ID AND custommeta0.meta_key = '_stock_status'
LEFT JOIN `wp_term_relationships` pv ON `wp_posts`.ID = pv.object_id and pv.term_taxonomy_id = 6
WHERE 'WPIBACKGROUNDTASK' = 'WPIBACKGROUNDTASK'
AND `wp_posts`.ID = 482744
and not exists (select * from `wp_superspeedysearch` sss_exists where sss_exists.ID = `wp_posts`.ID)
group by `wp_posts`.ID;
