3D Additive Fabrication Colorado

Upload an STL File for an Instant Quote

3D Printing Instant Quote

Quicksearch

Recent Entries

SELECT DISTINCT id,
                                title,
                                timestamp,
                                epm.value AS multilingual_title
                           FROM serendipity_entries AS e
                                 LEFT JOIN serendipity_entrycat ec
                                           ON e.id = ec.entryid LEFT JOIN serendipity_category c
                                       ON ec.categoryid = c.categoryid LEFT JOIN serendipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 0
                            LEFT JOIN serendipity_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'category'
                                       AND acl_acc.artifact_id   = c.categoryid
                                      )

                LEFT OUTER JOIN serendipity_entryproperties AS epm
                             ON (epm.entryid = e.id AND epm.property = 'multilingual_title_en')

                          WHERE isdraft = 'false' AND timestamp <= 1495960777 AND     (
                                 c.categoryid IS NULL
                                 OR ( acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                                ORDER BY timestamp DESC 
                                 LIMIT 10
/ Got error 28 from storage engine
SELECT DISTINCT id, title, timestamp, epm.value AS multilingual_title FROM serendipity_entries AS e LEFT JOIN serendipity_entrycat ec ON e.id = ec.entryid LEFT JOIN serendipity_category c ON ec.categoryid = c.categoryid LEFT JOIN serendipity_authorgroups AS acl_a ON acl_a.authorid = 0 LEFT JOIN serendipity_access AS acl_acc ON ( acl_acc.artifact_mode = 'read' AND acl_acc.artifact_type = 'category' AND acl_acc.artifact_id = c.categoryid ) LEFT OUTER JOIN serendipity_entryproperties AS epm ON (epm.entryid = e.id AND epm.property = 'multilingual_title_en') WHERE isdraft = 'false' AND timestamp <= 1495960777 AND ( c.categoryid IS NULL OR ( acl_acc.groupid = 0) OR ( acl_acc.artifact_id IS NULL ) ) ORDER BY timestamp DESC LIMIT 10

Categories