Site & Details

SELECT id, title, alias, catid FROM sjoomla.lfx_content WHERE catid IN (101, 341, 514, 343, 345, 497, 344, 498, 496, 411, 495, 506, 346) AND state = 1 AND publish_up <= curdate() ORDER BY created desc
SELECT id, title, alias, catid FROM sjoomla.lfx_content WHERE id IN (1073, 1236, 1302, 2195, 2214, 2382, 2571, 3176, 3549, 4013, 4057, 4184, 4954, 4976, 4977, 4978, 5571, 5708, 5779, 5971, 6043, 6148, 6494, 6515, 6795, 6826, 6841, 7423, 3175, 3192, 3235, 4208, 4282, 4391, 4845, 5569, 6829, 1058, 1086, 1213, 2154, 2177, 2272, 2407, 2412, 2756, 3044, 3105, 3444, 3598, 3985, 4402, 4523, 4600, 4657, 4970, 4976, 4977, 4978, 5571, 5973, 6502, 6778, 1036, 2106, 2601, 2650, 2845, 3096, 3139, 3383, 3388, 3526, 3552, 3598, 3704, 4470, 4680, 4736, 4825, 5408, 5571, 5914, 6700, 1020, 1036, 2283, 2409, 2799, 2807, 2988, 3037, 3192, 3372, 3383, 3388, 3526, 3704, 4353, 4678, 4825, 4966, 6107, 6863, 7267, 1057, 2577, 2584, 2668, 2733, 2790, 3235, 3372, 3406, 3450, 4322, 4327, 4714, 4747, 4829, 5069, 5473, 5474, 5475, 6226, 6778, 6799, 6863, 6875, 1088, 1552, 2407, 2668, 2733, 2789, 2790, 2845, 3008, 3044, 3104, 3388, 3526, 3598, 3911, 4033, 4358, 4374, 4425, 4657, 4680, 4932, 4976, 4977, 4978, 5032, 5069, 5753, 5786, 5795, 5973, 6047, 6436, 6778, 6795, 1023, 2103, 2123, 2789, 2841, 3139, 3486, 4341, 4444, 4523, 4970, 5032, 5753, 5893, 6014, 6306, 6342, 6502, 973, 2056, 2123, 2624, 3411, 3477, 4080, 4248, 4932, 4970, 5198, 5593, 5753, 5786, 5795, 5912, 6095, 6226, 6815, 1073, 2264, 2417, 3386, 3911, 4400, 7413, 1023, 1034, 1948, 2211, 3241, 4168, 4228, 3417, 4332, 5016, 6436) AND state = 1 AND publish_up <= curdate() ORDER BY created desc
string(324) "IN ('Site & Details', 'Errors: Site & Details', 'Basic Troubleshooting: Site & Details', 'Reference Notes', 'Hatches', 'Blocks', 'Callouts', 'Text & Annotation', 'Site & Details Schedules', 'Organizing Details & Detail Folders', 'Adding & Placing Details', 'Creating, Editing & Saving Details', 'Customizing Site & Details')"

---

array(13) { [397]=> string(24) "Adding & Placing Details" [1808]=> string(26) "Customizing Site & Details" [1838]=> string(6) "Blocks" [1848]=> string(8) "Callouts" [1849]=> string(17) "Text & Annotation" [1852]=> string(24) "Site & Details Schedules" [1883]=> string(15) "Reference Notes" [1887]=> string(7) "Hatches" [1888]=> string(22) "Errors: Site & Details" [1911]=> string(35) "Organizing Details & Detail Folders" [2022]=> string(37) "Basic Troubleshooting: Site & Details" [2054]=> string(34) "Creating, Editing & Saving Details" [2598]=> string(14) "Site & Details" }