| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT nama_website FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.0001 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT meta_deskripsi FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.0001 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT meta_deskripsi FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.0001 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT meta_keyword FROM identitas ORDER BY id_identitas DESC LIMIT 1
|
| 0.2183 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT COUNT(*) AS total
FROM t_content
WHERE publish_date <= NOW()
AND publish = 'Y'
AND hapus = 'N'
AND tag LIKE '%%'
|
| 0.2827 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.site_id = 1
AND tc.tag LIKE '% Bersihkan Lidah%'
ORDER BY tc.publish_date DESC
LIMIT 0, 10
|
| 0.0006 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT tc.*, CONCAT(tk.kanal_name, '|', tk.surel) AS kanal, CONCAT(ts.site_name, '|', ts.url) AS main_site
FROM `t_content` `tc`
LEFT JOIN `t_kanal` `tk` ON `tk`.`id` = `tc`.`id_kanal`
LEFT JOIN `t_site` `ts` ON `ts`.`id_site` = `tc`.`site_id`
WHERE tc.publish_date <= NOW()
AND `tc`.`publish` = 'Y'
AND `tc`.`hapus` = 'N'
ORDER BY `tc`.`publish_date` DESC
LIMIT 6
|
| 0.0006 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 68
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 1
|
| 0.0005 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 64
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 6
|
| 0.0005 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/
SELECT
tc.id,
tc.title,
tc.description,
tc.body_text,
tc.foto,
tc.tag,
tc.id_kanal,
tc.publisher,
tc.author,
tc.publish_date,
tc.url_seo,
tc.deck,
tc.foto_caption,
tc.sumberfoto,
tc.publish,
tc.headline,
tc.hapus,
tc.rep,
tc.red,
tc.sumber_berita,
tc.path,
tc.file_type,
tc.kontributor,
tc.id_berita,
(SELECT CONCAT(tk.kanal_name, '|', tk.surel)
FROM t_kanal tk
WHERE tk.id = tc.id_kanal
LIMIT 1) AS kanal,
(SELECT CONCAT(ts.site_name, '|', ts.url)
FROM t_site ts
WHERE ts.id_site = tc.site_id
LIMIT 1) AS main_site
FROM t_content tc
WHERE tc.publish_date <= NOW()
AND tc.publish = 'Y'
AND tc.hapus = 'N'
AND tc.id_kanal = 66
AND tc.site_id = 1
ORDER BY tc.publish_date DESC
LIMIT 0, 4
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT * FROM video ORDER BY id_video DESC LIMIT 0, 1
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT folder FROM templates where aktif='Y'
|
| 0.0001 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT folder FROM templates where aktif='Y'
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT folder FROM templates where aktif='Y'
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='home' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='64' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='65' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='68' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='297' AND id_site=1 order by short ASC
|
| 0.0003 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='home' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='64' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='65' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='68' AND id_site=1 order by short ASC
|
| 0.0002 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT id, kanal_name, surel,induk FROM t_kanal where publish='enable' AND induk='297' AND id_site=1 order by short ASC
|
| 0.0001 |
<?php
/*
Authors : initappz (Rahul Jograna)
Website : https://initappz.com/
App Name : ionic 5 groceryee app
Created : 10-Sep-2020
This App Template Source code is licensed as per the
terms found in the Website https://initappz.com/license
Copyright and Good Faith Purchasers © 2020-present initappz.
*/ SELECT folder FROM templates where aktif='Y'
|
